Debian Codegraph @

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

raw
1 CREATE TABLE t1 (
2 g GEOMETRY NOT NULL
3 ) ENGINE=InnoDB;
4 ALTER TABLE t1 ADD SPATIAL(g);
5 SET @g1 = ST_GeomFromText('POINT(10 10)');
6 SET @g2 = ST_GeomFromText('POLYGON((5 5, 20 5, 20 21, 5 21, 5 5))');
7 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))');
8 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
9 id select_type table type possible_keys key key_len ref rows Extra
10 1 SIMPLE t1 ALL g NULL NULL NULL 1 Using where
11 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
12 ST_AsText(g)
13 INSERT INTO t1 VALUES(@g1);
14 INSERT INTO t1 VALUES(@g2);
15 INSERT INTO t1 VALUES(@g3);
16 SELECT ST_AsText(g) FROM t1;
17 ST_AsText(g)
18 POINT(10 10)
19 POLYGON((5 5,20 5,20 21,5 21,5 5))
20 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
21 ANALYZE TABLE t1;
22 Table Op Msg_type Msg_text
23 test.t1 analyze status Engine-independent statistics collected
24 test.t1 analyze status OK
25 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
26 id select_type table type possible_keys key key_len ref rows Extra
27 1 SIMPLE t1 range g g 34 NULL 1 Using where
28 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
29 ST_AsText(g)
30 POINT(10 10)
31 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g1);
32 id select_type table type possible_keys key key_len ref rows Extra
33 1 SIMPLE t1 range g g 34 NULL 2 Using where
34 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
35 ST_AsText(g)
36 POINT(10 10)
37 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g1);
38 id select_type table type possible_keys key key_len ref rows Extra
39 1 SIMPLE t1 range g g 34 NULL 1 Using where
40 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
41 ST_AsText(g)
42 POINT(10 10)
43 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g1);
44 id select_type table type possible_keys key key_len ref rows Extra
45 1 SIMPLE t1 range g g 34 NULL 1 Using where
46 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
47 ST_AsText(g)
48 POINT(10 10)
49 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
50 id select_type table type possible_keys key key_len ref rows Extra
51 1 SIMPLE t1 range g g 34 NULL 1 Using where
52 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
53 ST_AsText(g)
54 POINT(10 10)
55 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g2);
56 id select_type table type possible_keys key key_len ref rows Extra
57 1 SIMPLE t1 range g g 34 NULL 1 Using where
58 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
59 ST_AsText(g)
60 POINT(10 10)
61 POLYGON((5 5,20 5,20 21,5 21,5 5))
62 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g2);
63 id select_type table type possible_keys key key_len ref rows Extra
64 1 SIMPLE t1 range g g 34 NULL 1 Using where
65 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
66 ST_AsText(g)
67 POINT(10 10)
68 POLYGON((5 5,20 5,20 21,5 21,5 5))
69 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g2);
70 id select_type table type possible_keys key key_len ref rows Extra
71 1 SIMPLE t1 range g g 34 NULL 1 Using where
72 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
73 ST_AsText(g)
74 POINT(10 10)
75 POLYGON((5 5,20 5,20 21,5 21,5 5))
76 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g2);
77 id select_type table type possible_keys key key_len ref rows Extra
78 1 SIMPLE t1 range g g 34 NULL 2 Using where
79 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
80 ST_AsText(g)
81 POINT(10 10)
82 POLYGON((5 5,20 5,20 21,5 21,5 5))
83 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
84 id select_type table type possible_keys key key_len ref rows Extra
85 1 SIMPLE t1 range g g 34 NULL 2 Using where
86 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
87 ST_AsText(g)
88 POINT(10 10)
89 POLYGON((5 5,20 5,20 21,5 21,5 5))
90 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g3);
91 id select_type table type possible_keys key key_len ref rows Extra
92 1 SIMPLE t1 ALL g NULL NULL NULL 3 Using where
93 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
94 ST_AsText(g)
95 POINT(10 10)
96 POLYGON((5 5,20 5,20 21,5 21,5 5))
97 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
98 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g3);
99 id select_type table type possible_keys key key_len ref rows Extra
100 1 SIMPLE t1 ALL g NULL NULL NULL 3 Using where
101 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
102 ST_AsText(g)
103 POINT(10 10)
104 POLYGON((5 5,20 5,20 21,5 21,5 5))
105 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
106 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g3);
107 id select_type table type possible_keys key key_len ref rows Extra
108 1 SIMPLE t1 ALL g NULL NULL NULL 3 Using where
109 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
110 ST_AsText(g)
111 POINT(10 10)
112 POLYGON((5 5,20 5,20 21,5 21,5 5))
113 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
114 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g3);
115 id select_type table type possible_keys key key_len ref rows Extra
116 1 SIMPLE t1 ALL g NULL NULL NULL 3 Using where
117 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
118 ST_AsText(g)
119 POINT(10 10)
120 POLYGON((5 5,20 5,20 21,5 21,5 5))
121 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
122 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
123 id select_type table type possible_keys key key_len ref rows Extra
124 1 SIMPLE t1 ALL g NULL NULL NULL 3 Using where
125 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
126 ST_AsText(g)
127 POINT(10 10)
128 POLYGON((5 5,20 5,20 21,5 21,5 5))
129 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
130 DROP TABLE t1;