Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 INT, c2 GEOMETRY NOT NULL, c3 GEOMETRY NOT NULL) ENGINE=INNODB;
2 CREATE TEMPORARY TABLE t LIKE t1;
3 INSERT INTO t VALUES
4 (1, Point(1,1), ST_GeomFromText('POLYGON (( 0 -1, 0 1, 2 1, 2 -1, 0 -1))')),
5 (2, Point(2,2), ST_GeomFromText('POLYGON (( 0 -3, 0 -1, 2 -1, 2 -3, 0 -3))')),
6 (3, Point(3,3), ST_GeomFromText('POLYGON (( 1 0, 1 2, 3 2, 3 0, 1 0))')),
7 (4, Point(4,4), ST_GeomFromText('POLYGON (( -3 0, -3 2, -1 2, -1 0, -3 0))')),
8 (5, Point(5,5), ST_GeomFromText('POLYGON (( 0 0, 0 1, 1 1, 1 0, 0 0))')),
9 (6, Point(6,6), ST_GeomFromText('POLYGON (( 2 0, 2 2, 4 2, 4 0, 2 0))')),
10 (7, Point(7,7), ST_GeomFromText('POLYGON (( 0 3, 0 5, 2 5, 2 3, 0 3))')),
11 (8, Point(8,8), ST_GeomFromText('POLYGON (( 0 1, 0 3, 2 3, 2 1, 0 1))')),
12 (9, Point(9,9), ST_GeomFromText('POLYGON (( 0 0, 0 3, 3 3, 3 0, 0 0))'));
13 INSERT INTO t1 SELECT t.* FROM t, seq_1_to_512;
14 DROP TEMPORARY TABLE t;
15 CREATE SPATIAL INDEX idx ON t1(c2);
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 4608
19 SET @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
20 SELECT COUNT(*) FROM t1 WHERE MBRWithin(t1.c2, @g1);
21 COUNT(*)
22 4608
23 SET @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
24 SELECT COUNT(*) FROM t1 WHERE MBRWithin(t1.c2, @g1);
25 COUNT(*)
26 0
27 ALTER TABLE t1 DROP INDEX idx, ADD SPATIAL INDEX idx3(c2);
28 SET SESSION debug_dbug="+d,row_merge_instrument_log_check_flush";
29 ALTER TABLE t1 DROP INDEX idx3, ADD SPATIAL INDEX idx4(c2), ADD SPATIAL INDEX idx5(c3);
30 ALTER TABLE t1 FORCE;
31 DROP TABLE t1;