Debian Codegraph @

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

raw
1 SET GLOBAL innodb_change_buffering=all;
2 SELECT @@global.innodb_change_buffering;
3 @@global.innodb_change_buffering
4 all
5 CREATE TABLE t1(f1 POINT NOT NULL);
6 INSERT INTO t1 VALUES (POINT(15, 20));
7 INSERT INTO t1 SELECT * FROM t1;
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 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 512
19 CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table SELECT * FROM t1 LIMIT 366;
20 CREATE SPATIAL INDEX k1 ON tmp_table(f1);
21 Warnings:
22 Warning 3674 The spatial index on column 'f1' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.
23 DROP TABLE t1;
24 SET GLOBAL innodb_change_buffering=default;