Debian Codegraph @

mysql-test/suite/innodb_gis/t/ibuf_spatial_temptable.test

raw
1 --source include/have_innodb_max_16k.inc
2
3 SET GLOBAL innodb_change_buffering=all;
4 SELECT @@global.innodb_change_buffering;
5
6 CREATE TABLE t1(f1 POINT NOT NULL);
7 INSERT INTO t1 VALUES (POINT(15, 20));
8 INSERT INTO t1 SELECT * FROM t1;
9 INSERT INTO t1 SELECT * FROM t1;
10 INSERT INTO t1 SELECT * FROM t1;
11 INSERT INTO t1 SELECT * FROM t1;
12 INSERT INTO t1 SELECT * FROM t1;
13 INSERT INTO t1 SELECT * FROM t1;
14 INSERT INTO t1 SELECT * FROM t1;
15 INSERT INTO t1 SELECT * FROM t1;
16 INSERT INTO t1 SELECT * FROM t1;
17 SELECT COUNT(*) FROM t1;
18 CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table SELECT * FROM t1 LIMIT 366;
19 CREATE SPATIAL INDEX k1 ON tmp_table(f1);
20 DROP TABLE t1;
21 SET GLOBAL innodb_change_buffering=default;