Debian Codegraph @

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

raw
1 # This is to test create GIS index with algorithm=inplace.
2
3 --source include/have_debug.inc
4 --source include/no_valgrind_without_big.inc
5
6 # Create table with geometry column
7 CREATE TABLE t1 (c1 INT, c2 GEOMETRY NOT NULL SRID 0, c3 GEOMETRY NOT NULL SRID 0) ENGINE=INNODB;
8
9 # Insert enough values
10 INSERT INTO t1 VALUES(1, Point(1,1), ST_GeomFromText('POLYGON (( 0 -1, 0 1, 2 1, 2 -1, 0 -1))'));
11 INSERT INTO t1 VALUES(2, Point(2,2), ST_GeomFromText('POLYGON (( 0 -3, 0 -1, 2 -1, 2 -3, 0 -3))'));
12 INSERT INTO t1 VALUES(3, Point(3,3), ST_GeomFromText('POLYGON (( 1 0, 1 2, 3 2, 3 0, 1 0))'));
13 INSERT INTO t1 VALUES(4, Point(4,4), ST_GeomFromText('POLYGON (( -3 0, -3 2, -1 2, -1 0, -3 0))'));
14 INSERT INTO t1 VALUES(5, Point(5,5), ST_GeomFromText('POLYGON (( 0 0, 0 1, 1 1, 1 0, 0 0))'));
15 INSERT INTO t1 VALUES(6, Point(6,6), ST_GeomFromText('POLYGON (( 2 0, 2 2, 4 2, 4 0, 2 0))'));
16 INSERT INTO t1 VALUES(7, Point(7,7), ST_GeomFromText('POLYGON (( 0 3, 0 5, 2 5, 2 3, 0 3))'));
17 INSERT INTO t1 VALUES(8, Point(8,8), ST_GeomFromText('POLYGON (( 0 1, 0 3, 2 3, 2 1, 0 1))'));
18 INSERT INTO t1 VALUES(9, Point(9,9), ST_GeomFromText('POLYGON (( 0 0, 0 3, 3 3, 3 0, 0 0))'));
19
20 INSERT INTO t1 SELECT * FROM t1;
21 INSERT INTO t1 SELECT * FROM t1;
22 INSERT INTO t1 SELECT * FROM t1;
23 INSERT INTO t1 SELECT * FROM t1;
24
25 INSERT INTO t1 SELECT * FROM t1;
26 INSERT INTO t1 SELECT * FROM t1;
27 INSERT INTO t1 SELECT * FROM t1;
28 INSERT INTO t1 SELECT * FROM t1;
29 INSERT INTO t1 SELECT * FROM t1;
30
31 # create spatial index
32 CREATE SPATIAL INDEX idx ON t1(c2);
33
34 SELECT COUNT(*) FROM t1;
35
36 SET @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
37 SELECT COUNT(*) FROM t1 WHERE MBRWithin(t1.c2, @g1);
38
39 SET @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
40 SELECT COUNT(*) FROM t1 WHERE MBRWithin(t1.c2, @g1);
41
42 ALTER TABLE t1 DROP INDEX idx, ADD SPATIAL INDEX idx3(c2);
43
44 SET SESSION debug="+d,ddl_instrument_log_check_flush";
45 ALTER TABLE t1 DROP INDEX idx3, ADD SPATIAL INDEX idx4(c2), ADD SPATIAL INDEX idx5(c3);
46 SET SESSION debug="-d,ddl_instrument_log_check_flush";
47
48 # Clean up.
49 DROP TABLE t1;