Debian Codegraph @

mysql-test/suite/innodb_gis/r/rtree_add_index.result

raw
1 CREATE TABLE t1 (g MULTIPOINT NOT NULL) ENGINE=InnoDB STATS_PERSISTENT=0;
2 INSERT INTO t1 VALUES (MultiPointFromText('MULTIPOINT(0 0,10 10,10 20,20 20)'));
3 connect purge_control,localhost,root;
4 START TRANSACTION WITH CONSISTENT SNAPSHOT;
5 connection default;
6 DELETE FROM t1;
7 ALTER TABLE t1 ADD SPATIAL INDEX (g);
8 disconnect purge_control;
9 InnoDB 0 transactions not purged
10 DROP TABLE t1;