Debian Codegraph @

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

raw
1 #
2 # BUG#21245805 HA_INNOBASE::RECORDS_IN_RANGE() RETURNS CONSTANT FOR SPATIAL INDEXES
3 #
4
5 --source include/have_debug.inc
6
7 CREATE TABLE t1 (
8 g GEOMETRY NOT NULL SRID 0
9 ) ENGINE=InnoDB;
10
11 ALTER TABLE t1 ADD SPATIAL(g);
12
13 SET @g1 = ST_GeomFromText('POINT(10 10)');
14 SET @g2 = ST_GeomFromText('POLYGON((5 5, 20 5, 20 21, 5 21, 5 5))');
15 SET @g3 = ST_GeomFromText('POLYGON((1.79769e+308 1.79769e+308, 20 5, -1.79769e+308 -1.79769e+308, 1.79769e+308 1.79769e+308))');
16
17 # Test empty table
18 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
19 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
20
21 # Insert gis data
22 INSERT INTO t1 VALUES(@g1);
23 INSERT INTO t1 VALUES(@g2);
24 INSERT INTO t1 VALUES(@g3);
25
26 SELECT ST_AsText(g) FROM t1;
27
28 ANALYZE TABLE t1;
29
30 # Test g1
31 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
32 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
33
34 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g1);
35 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
36
37 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g1);
38 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
39
40 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g1);
41 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
42
43 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
44 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
45
46 # Test g2
47 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g2);
48 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
49
50 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g2);
51 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
52
53 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g2);
54 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
55
56 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g2);
57 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
58
59 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
60 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
61
62 # Test g3
63 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g3);
64 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
65
66 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g3);
67 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
68
69 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g3);
70 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
71
72 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g3);
73 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
74
75 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
76 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
77
78 DROP TABLE t1;