Debian Codegraph @

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

raw
1 CREATE TABLE t1 (
2 g GEOMETRY NOT NULL SRID 0
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 partitions type possible_keys key key_len ref rows filtered Extra
10 1 SIMPLE t1 NULL ALL g NULL NULL NULL 1 100.00 Using where
11 Warnings:
12 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrcontains(`test`.`t1`.`g`,<cache>((@`g1`)))
13 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
14 ST_AsText(g)
15 INSERT INTO t1 VALUES(@g1);
16 INSERT INTO t1 VALUES(@g2);
17 INSERT INTO t1 VALUES(@g3);
18 SELECT ST_AsText(g) FROM t1;
19 ST_AsText(g)
20 POINT(10 10)
21 POLYGON((5 5,20 5,20 21,5 21,5 5))
22 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
23 ANALYZE TABLE t1;
24 Table Op Msg_type Msg_text
25 test.t1 analyze status OK
26 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
27 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
28 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
29 Warnings:
30 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrcontains(`test`.`t1`.`g`,<cache>((@`g1`)))
31 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
32 ST_AsText(g)
33 POINT(10 10)
34 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g1);
35 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
36 1 SIMPLE t1 NULL range g g 34 NULL 2 100.00 Using where
37 Warnings:
38 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrdisjoint(`test`.`t1`.`g`,<cache>((@`g1`)))
39 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
40 ST_AsText(g)
41 POINT(10 10)
42 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g1);
43 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
44 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
45 Warnings:
46 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrequals(`test`.`t1`.`g`,<cache>((@`g1`)))
47 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
48 ST_AsText(g)
49 POINT(10 10)
50 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g1);
51 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
52 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
53 Warnings:
54 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrintersects(`test`.`t1`.`g`,<cache>((@`g1`)))
55 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
56 ST_AsText(g)
57 POINT(10 10)
58 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
59 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
60 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
61 Warnings:
62 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrwithin(`test`.`t1`.`g`,<cache>((@`g1`)))
63 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
64 ST_AsText(g)
65 POINT(10 10)
66 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g2);
67 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
68 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
69 Warnings:
70 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrcontains(`test`.`t1`.`g`,<cache>((@`g2`)))
71 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
72 ST_AsText(g)
73 POINT(10 10)
74 POLYGON((5 5,20 5,20 21,5 21,5 5))
75 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g2);
76 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
77 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
78 Warnings:
79 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrdisjoint(`test`.`t1`.`g`,<cache>((@`g2`)))
80 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
81 ST_AsText(g)
82 POINT(10 10)
83 POLYGON((5 5,20 5,20 21,5 21,5 5))
84 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g2);
85 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
86 1 SIMPLE t1 NULL range g g 34 NULL 1 100.00 Using where
87 Warnings:
88 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrequals(`test`.`t1`.`g`,<cache>((@`g2`)))
89 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
90 ST_AsText(g)
91 POINT(10 10)
92 POLYGON((5 5,20 5,20 21,5 21,5 5))
93 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g2);
94 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
95 1 SIMPLE t1 NULL range g g 34 NULL 2 100.00 Using where
96 Warnings:
97 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrintersects(`test`.`t1`.`g`,<cache>((@`g2`)))
98 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
99 ST_AsText(g)
100 POINT(10 10)
101 POLYGON((5 5,20 5,20 21,5 21,5 5))
102 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
103 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
104 1 SIMPLE t1 NULL range g g 34 NULL 2 100.00 Using where
105 Warnings:
106 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrwithin(`test`.`t1`.`g`,<cache>((@`g2`)))
107 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
108 ST_AsText(g)
109 POINT(10 10)
110 POLYGON((5 5,20 5,20 21,5 21,5 5))
111 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g3);
112 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
113 1 SIMPLE t1 NULL ALL g NULL NULL NULL 3 100.00 Using where
114 Warnings:
115 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrcontains(`test`.`t1`.`g`,<cache>((@`g3`)))
116 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
117 ST_AsText(g)
118 POINT(10 10)
119 POLYGON((5 5,20 5,20 21,5 21,5 5))
120 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
121 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g3);
122 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
123 1 SIMPLE t1 NULL ALL g NULL NULL NULL 3 100.00 Using where
124 Warnings:
125 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrdisjoint(`test`.`t1`.`g`,<cache>((@`g3`)))
126 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
127 ST_AsText(g)
128 POINT(10 10)
129 POLYGON((5 5,20 5,20 21,5 21,5 5))
130 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
131 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g3);
132 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
133 1 SIMPLE t1 NULL ALL g NULL NULL NULL 3 100.00 Using where
134 Warnings:
135 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrequals(`test`.`t1`.`g`,<cache>((@`g3`)))
136 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
137 ST_AsText(g)
138 POINT(10 10)
139 POLYGON((5 5,20 5,20 21,5 21,5 5))
140 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
141 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g3);
142 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
143 1 SIMPLE t1 NULL ALL g NULL NULL NULL 3 100.00 Using where
144 Warnings:
145 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrintersects(`test`.`t1`.`g`,<cache>((@`g3`)))
146 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
147 ST_AsText(g)
148 POINT(10 10)
149 POLYGON((5 5,20 5,20 21,5 21,5 5))
150 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
151 EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
152 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
153 1 SIMPLE t1 NULL ALL g NULL NULL NULL 3 100.00 Using where
154 Warnings:
155 Note 1003 /* select#1 */ select st_astext(`test`.`t1`.`g`) AS `ST_AsText(g)` from `test`.`t1` where mbrwithin(`test`.`t1`.`g`,<cache>((@`g3`)))
156 SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
157 ST_AsText(g)
158 POINT(10 10)
159 POLYGON((5 5,20 5,20 21,5 21,5 5))
160 POLYGON((1.79769e308 1.79769e308,20 5,-1.79769e308 -1.79769e308,1.79769e308 1.79769e308))
161 DROP TABLE t1;