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