1--source include/have_innodb.inc 2 3SET @saved_frequency = @@GLOBAL.innodb_purge_rseg_truncate_frequency; 4SET GLOBAL innodb_purge_rseg_truncate_frequency = 1; 5 6CREATE TABLE t1 (g MULTIPOINT NOT NULL) ENGINE=InnoDB; 7INSERT INTO t1 VALUES (''); 8 9connect purge_control,localhost,root; 10START TRANSACTION WITH CONSISTENT SNAPSHOT; 11connection default; 12 13DELETE FROM t1; 14 15ALTER TABLE t1 ADD SPATIAL INDEX (g); 16 17disconnect purge_control; 18--source ../../innodb/include/wait_all_purged.inc 19DROP TABLE t1; 20SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency; 21