File: ibuf_spatial_temptable.result

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (24 lines) | stat: -rw-r--r-- 899 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
SET GLOBAL innodb_change_buffering=all;
SELECT @@global.innodb_change_buffering;
@@global.innodb_change_buffering
all
CREATE TABLE t1(f1 POINT NOT NULL);
INSERT INTO t1 VALUES (POINT(15, 20));
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
SELECT COUNT(*) FROM t1;
COUNT(*)
512
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table SELECT * FROM t1 LIMIT 366;
CREATE SPATIAL INDEX k1 ON tmp_table(f1);
Warnings:
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.
DROP TABLE t1;
SET GLOBAL innodb_change_buffering=default;