Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table='off';
2 CREATE TABLE t1 (
3 id bigint(12) unsigned NOT NULL auto_increment,
4 c2 varchar(15) collate utf8_bin DEFAULT NULL,
5 c1 varchar(15) collate utf8_bin DEFAULT NULL,
6 c3 varchar(10) collate utf8_bin DEFAULT NULL,
7 spatial_point point NOT NULL SRID 0,
8 PRIMARY KEY(id),
9 SPATIAL KEY (spatial_point)
10 ) ROW_FORMAT=REDUNDANT ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
11 Warnings:
12 Warning 1681 Integer display width is deprecated and will be removed in a future release.
13 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
14 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
15 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
16 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
17 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
18 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
19 ('y', 's', 'j', ST_GeomFromText('POINT(167 74)')),
20 ('r', 'n', 'd', ST_GeomFromText('POINT(215 118)')),
21 ('g', 'n', 'e', ST_GeomFromText('POINT(203 98)')),
22 ('h', 'd', 'd', ST_GeomFromText('POINT(54 193)')),
23 ('r', 'x', 'y', ST_GeomFromText('POINT(47 69)')),
24 ('t', 'q', 'r', ST_GeomFromText('POINT(109 42)')),
25 ('a', 'z', 'd', ST_GeomFromText('POINT(0 154)')),
26 ('x', 'v', 'o', ST_GeomFromText('POINT(174 131)')),
27 ('b', 'r', 'a', ST_GeomFromText('POINT(114 253)')),
28 ('x', 'z', 'i', ST_GeomFromText('POINT(163 21)')),
29 ('w', 'p', 'i', ST_GeomFromText('POINT(42 102)')),
30 ('g', 'j', 'j', ST_GeomFromText('POINT(170 133)')),
31 ('m', 'g', 'n', ST_GeomFromText('POINT(28 22)')),
32 ('b', 'z', 'h', ST_GeomFromText('POINT(174 28)')),
33 ('q', 'k', 'f', ST_GeomFromText('POINT(233 73)')),
34 ('w', 'w', 'a', ST_GeomFromText('POINT(124 200)')),
35 ('t', 'j', 'w', ST_GeomFromText('POINT(252 101)')),
36 ('d', 'r', 'd', ST_GeomFromText('POINT(98 18)')),
37 ('w', 'o', 'y', ST_GeomFromText('POINT(165 31)')),
38 ('y', 'h', 't', ST_GeomFromText('POINT(14 220)')),
39 ('d', 'p', 'u', ST_GeomFromText('POINT(223 196)')),
40 ('g', 'y', 'g', ST_GeomFromText('POINT(207 96)')),
41 ('x', 'm', 'n', ST_GeomFromText('POINT(214 3)')),
42 ('g', 'v', 'e', ST_GeomFromText('POINT(140 205)')),
43 ('g', 'm', 'm', ST_GeomFromText('POINT(10 236)')),
44 ('i', 'r', 'j', ST_GeomFromText('POINT(137 228)')),
45 ('w', 's', 'p', ST_GeomFromText('POINT(115 6)')),
46 ('o', 'n', 'k', ST_GeomFromText('POINT(158 129)')),
47 ('j', 'h', 'l', ST_GeomFromText('POINT(129 72)')),
48 ('f', 'x', 'l', ST_GeomFromText('POINT(139 207)')),
49 ('u', 'd', 'n', ST_GeomFromText('POINT(125 109)')),
50 ('b', 'a', 'z', ST_GeomFromText('POINT(30 32)')),
51 ('m', 'h', 'o', ST_GeomFromText('POINT(251 251)')),
52 ('f', 'r', 'd', ST_GeomFromText('POINT(243 211)')),
53 ('b', 'd', 'r', ST_GeomFromText('POINT(232 80)')),
54 ('g', 'k', 'v', ST_GeomFromText('POINT(15 100)')),
55 ('i', 'f', 'c', ST_GeomFromText('POINT(109 66)')),
56 ('r', 't', 'j', ST_GeomFromText('POINT(178 6)')),
57 ('y', 'n', 'f', ST_GeomFromText('POINT(233 211)')),
58 ('f', 'y', 'm', ST_GeomFromText('POINT(99 16)')),
59 ('z', 'q', 'l', ST_GeomFromText('POINT(39 49)')),
60 ('j', 'c', 'r', ST_GeomFromText('POINT(75 187)')),
61 ('c', 'y', 'y', ST_GeomFromText('POINT(246 253)')),
62 ('w', 'u', 'd', ST_GeomFromText('POINT(56 190)')),
63 ('n', 'q', 'm', ST_GeomFromText('POINT(73 149)')),
64 ('d', 'y', 'a', ST_GeomFromText('POINT(134 6)')),
65 ('z', 's', 'w', ST_GeomFromText('POINT(216 225)')),
66 ('d', 'u', 'k', ST_GeomFromText('POINT(132 70)')),
67 ('f', 'v', 't', ST_GeomFromText('POINT(187 141)')),
68 ('r', 'r', 'a', ST_GeomFromText('POINT(152 39)')),
69 ('y', 'p', 'o', ST_GeomFromText('POINT(45 27)')),
70 ('p', 'n', 'm', ST_GeomFromText('POINT(228 148)')),
71 ('e', 'g', 'e', ST_GeomFromText('POINT(88 81)')),
72 ('m', 'a', 'h', ST_GeomFromText('POINT(35 29)')),
73 ('m', 'h', 'f', ST_GeomFromText('POINT(30 71)')),
74 ('h', 'k', 'i', ST_GeomFromText('POINT(244 78)')),
75 ('z', 'v', 'd', ST_GeomFromText('POINT(241 38)')),
76 ('q', 'l', 'j', ST_GeomFromText('POINT(13 71)')),
77 ('s', 'p', 'g', ST_GeomFromText('POINT(108 38)')),
78 ('q', 's', 'j', ST_GeomFromText('POINT(92 101)')),
79 ('l', 'h', 'g', ST_GeomFromText('POINT(120 78)')),
80 ('w', 't', 'b', ST_GeomFromText('POINT(193 109)')),
81 ('b', 's', 's', ST_GeomFromText('POINT(223 211)')),
82 ('w', 'w', 'y', ST_GeomFromText('POINT(122 42)')),
83 ('q', 'c', 'c', ST_GeomFromText('POINT(104 102)')),
84 ('w', 'g', 'n', ST_GeomFromText('POINT(213 120)')),
85 ('p', 'q', 'a', ST_GeomFromText('POINT(247 148)')),
86 ('c', 'z', 'e', ST_GeomFromText('POINT(18 106)')),
87 ('z', 'u', 'n', ST_GeomFromText('POINT(70 133)')),
88 ('j', 'n', 'x', ST_GeomFromText('POINT(232 13)')),
89 ('e', 'h', 'f', ST_GeomFromText('POINT(22 135)')),
90 ('w', 'l', 'f', ST_GeomFromText('POINT(9 180)')),
91 ('a', 'v', 'q', ST_GeomFromText('POINT(163 228)')),
92 ('i', 'z', 'o', ST_GeomFromText('POINT(180 100)')),
93 ('e', 'c', 'l', ST_GeomFromText('POINT(182 231)')),
94 ('c', 'k', 'o', ST_GeomFromText('POINT(19 60)')),
95 ('q', 'f', 'p', ST_GeomFromText('POINT(79 95)')),
96 ('m', 'd', 'r', ST_GeomFromText('POINT(3 127)')),
97 ('m', 'e', 't', ST_GeomFromText('POINT(136 154)')),
98 ('w', 'w', 'w', ST_GeomFromText('POINT(102 15)')),
99 ('l', 'n', 'q', ST_GeomFromText('POINT(71 196)')),
100 ('p', 'k', 'c', ST_GeomFromText('POINT(47 139)')),
101 ('j', 'o', 'r', ST_GeomFromText('POINT(177 128)')),
102 ('j', 'q', 'a', ST_GeomFromText('POINT(170 6)')),
103 ('b', 'a', 'o', ST_GeomFromText('POINT(63 211)')),
104 ('g', 's', 'o', ST_GeomFromText('POINT(144 251)')),
105 ('w', 'u', 'w', ST_GeomFromText('POINT(221 214)')),
106 ('g', 'a', 'm', ST_GeomFromText('POINT(14 102)')),
107 ('u', 'q', 'z', ST_GeomFromText('POINT(86 200)')),
108 ('k', 'a', 'm', ST_GeomFromText('POINT(144 222)')),
109 ('j', 'u', 'r', ST_GeomFromText('POINT(216 142)')),
110 ('q', 'k', 'v', ST_GeomFromText('POINT(121 236)')),
111 ('p', 'o', 'r', ST_GeomFromText('POINT(108 102)')),
112 ('b', 'd', 'x', ST_GeomFromText('POINT(127 198)')),
113 ('k', 's', 'a', ST_GeomFromText('POINT(2 150)')),
114 ('f', 'm', 'f', ST_GeomFromText('POINT(160 191)')),
115 ('q', 'y', 'x', ST_GeomFromText('POINT(98 111)')),
116 ('o', 'f', 'm', ST_GeomFromText('POINT(232 218)')),
117 ('c', 'w', 'j', ST_GeomFromText('POINT(156 165)')),
118 ('s', 'q', 'v', ST_GeomFromText('POINT(98 161)'));
119 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
120 ('f', 'y', 'p', ST_GeomFromText('POINT(109 235)')),
121 ('b', 'e', 'v', ST_GeomFromText('POINT(20 48)')),
122 ('i', 'u', 'f', ST_GeomFromText('POINT(15 55)')),
123 ('o', 'r', 'z', ST_GeomFromText('POINT(105 64)')),
124 ('a', 'p', 'a', ST_GeomFromText('POINT(142 236)')),
125 ('g', 'i', 'k', ST_GeomFromText('POINT(10 49)')),
126 ('x', 'z', 'x', ST_GeomFromText('POINT(192 200)')),
127 ('c', 'v', 'r', ST_GeomFromText('POINT(94 168)')),
128 ('y', 'z', 'e', ST_GeomFromText('POINT(141 51)')),
129 ('h', 'm', 'd', ST_GeomFromText('POINT(35 251)')),
130 ('v', 'm', 'q', ST_GeomFromText('POINT(44 90)')),
131 ('j', 'l', 'z', ST_GeomFromText('POINT(67 237)')),
132 ('i', 'v', 'a', ST_GeomFromText('POINT(75 14)')),
133 ('b', 'q', 't', ST_GeomFromText('POINT(153 33)')),
134 ('e', 'm', 'a', ST_GeomFromText('POINT(247 49)')),
135 ('l', 'y', 'g', ST_GeomFromText('POINT(56 203)')),
136 ('v', 'o', 'r', ST_GeomFromText('POINT(90 54)')),
137 ('r', 'n', 'd', ST_GeomFromText('POINT(135 83)')),
138 ('j', 't', 'u', ST_GeomFromText('POINT(174 239)')),
139 ('u', 'n', 'g', ST_GeomFromText('POINT(104 191)')),
140 ('p', 'q', 'y', ST_GeomFromText('POINT(63 171)')),
141 ('o', 'q', 'p', ST_GeomFromText('POINT(192 103)')),
142 ('f', 'x', 'e', ST_GeomFromText('POINT(244 30)')),
143 ('n', 'x', 'c', ST_GeomFromText('POINT(92 103)')),
144 ('r', 'q', 'z', ST_GeomFromText('POINT(166 20)')),
145 ('s', 'a', 'j', ST_GeomFromText('POINT(137 205)')),
146 ('z', 't', 't', ST_GeomFromText('POINT(99 134)')),
147 ('o', 'm', 'j', ST_GeomFromText('POINT(217 3)')),
148 ('n', 'h', 'j', ST_GeomFromText('POINT(211 17)')),
149 ('v', 'v', 'a', ST_GeomFromText('POINT(41 137)')),
150 ('q', 'o', 'j', ST_GeomFromText('POINT(5 92)')),
151 ('z', 'y', 'e', ST_GeomFromText('POINT(175 212)')),
152 ('j', 'z', 'h', ST_GeomFromText('POINT(224 194)')),
153 ('a', 'g', 'm', ST_GeomFromText('POINT(31 119)')),
154 ('p', 'c', 'f', ST_GeomFromText('POINT(17 221)')),
155 ('t', 'h', 'k', ST_GeomFromText('POINT(26 203)')),
156 ('u', 'w', 'p', ST_GeomFromText('POINT(47 185)')),
157 ('z', 'a', 'c', ST_GeomFromText('POINT(61 133)')),
158 ('u', 'k', 'a', ST_GeomFromText('POINT(210 115)')),
159 ('k', 'f', 'h', ST_GeomFromText('POINT(125 113)')),
160 ('t', 'v', 'y', ST_GeomFromText('POINT(12 239)')),
161 ('u', 'v', 'd', ST_GeomFromText('POINT(90 24)')),
162 ('m', 'y', 'w', ST_GeomFromText('POINT(25 243)')),
163 ('d', 'n', 'g', ST_GeomFromText('POINT(122 92)')),
164 ('z', 'm', 'f', ST_GeomFromText('POINT(235 110)')),
165 ('q', 'd', 'f', ST_GeomFromText('POINT(233 217)')),
166 ('a', 'v', 'u', ST_GeomFromText('POINT(69 59)')),
167 ('x', 'k', 'p', ST_GeomFromText('POINT(240 14)')),
168 ('i', 'v', 'r', ST_GeomFromText('POINT(154 42)')),
169 ('w', 'h', 'l', ST_GeomFromText('POINT(178 156)')),
170 ('d', 'h', 'n', ST_GeomFromText('POINT(65 157)')),
171 ('c', 'k', 'z', ST_GeomFromText('POINT(62 33)')),
172 ('e', 'l', 'w', ST_GeomFromText('POINT(162 1)')),
173 ('r', 'f', 'i', ST_GeomFromText('POINT(127 71)')),
174 ('q', 'm', 'c', ST_GeomFromText('POINT(63 118)')),
175 ('c', 'h', 'u', ST_GeomFromText('POINT(205 203)')),
176 ('d', 't', 'p', ST_GeomFromText('POINT(234 87)')),
177 ('s', 'g', 'h', ST_GeomFromText('POINT(149 34)')),
178 ('o', 'b', 'q', ST_GeomFromText('POINT(159 179)')),
179 ('k', 'u', 'f', ST_GeomFromText('POINT(202 254)')),
180 ('u', 'f', 'g', ST_GeomFromText('POINT(70 15)')),
181 ('x', 's', 'b', ST_GeomFromText('POINT(25 181)')),
182 ('s', 'c', 'g', ST_GeomFromText('POINT(252 17)')),
183 ('a', 'c', 'f', ST_GeomFromText('POINT(89 67)')),
184 ('r', 'e', 'q', ST_GeomFromText('POINT(55 54)')),
185 ('f', 'i', 'k', ST_GeomFromText('POINT(178 230)')),
186 ('p', 'e', 'l', ST_GeomFromText('POINT(198 28)')),
187 ('w', 'o', 'd', ST_GeomFromText('POINT(204 189)')),
188 ('c', 'a', 'g', ST_GeomFromText('POINT(230 178)')),
189 ('r', 'o', 'e', ST_GeomFromText('POINT(61 116)')),
190 ('w', 'a', 'a', ST_GeomFromText('POINT(178 237)')),
191 ('v', 'd', 'e', ST_GeomFromText('POINT(70 85)')),
192 ('k', 'c', 'e', ST_GeomFromText('POINT(147 118)')),
193 ('d', 'q', 't', ST_GeomFromText('POINT(218 77)')),
194 ('k', 'g', 'f', ST_GeomFromText('POINT(192 113)')),
195 ('w', 'n', 'e', ST_GeomFromText('POINT(92 124)')),
196 ('r', 'm', 'q', ST_GeomFromText('POINT(130 65)')),
197 ('o', 'r', 'r', ST_GeomFromText('POINT(174 233)')),
198 ('k', 'n', 't', ST_GeomFromText('POINT(175 147)')),
199 ('q', 'm', 'r', ST_GeomFromText('POINT(18 208)')),
200 ('l', 'd', 'i', ST_GeomFromText('POINT(13 104)')),
201 ('w', 'o', 'y', ST_GeomFromText('POINT(207 39)')),
202 ('p', 'u', 'o', ST_GeomFromText('POINT(114 31)')),
203 ('y', 'a', 'p', ST_GeomFromText('POINT(106 59)')),
204 ('a', 'x', 'z', ST_GeomFromText('POINT(17 57)')),
205 ('v', 'h', 'x', ST_GeomFromText('POINT(170 13)')),
206 ('t', 's', 'u', ST_GeomFromText('POINT(84 18)')),
207 ('z', 'z', 'f', ST_GeomFromText('POINT(250 197)')),
208 ('l', 'z', 't', ST_GeomFromText('POINT(59 80)')),
209 ('j', 'g', 's', ST_GeomFromText('POINT(54 26)')),
210 ('g', 'v', 'm', ST_GeomFromText('POINT(89 98)')),
211 ('q', 'v', 'b', ST_GeomFromText('POINT(39 240)')),
212 ('x', 'k', 'v', ST_GeomFromText('POINT(246 207)')),
213 ('k', 'u', 'i', ST_GeomFromText('POINT(105 111)')),
214 ('w', 'z', 's', ST_GeomFromText('POINT(235 8)')),
215 ('d', 'd', 'd', ST_GeomFromText('POINT(105 4)')),
216 ('c', 'z', 'q', ST_GeomFromText('POINT(13 140)')),
217 ('m', 'k', 'i', ST_GeomFromText('POINT(208 120)')),
218 ('g', 'a', 'g', ST_GeomFromText('POINT(9 182)')),
219 ('z', 'j', 'r', ST_GeomFromText('POINT(149 153)')),
220 ('h', 'f', 'g', ST_GeomFromText('POINT(81 236)')),
221 ('m', 'e', 'q', ST_GeomFromText('POINT(209 215)')),
222 ('c', 'h', 'y', ST_GeomFromText('POINT(235 70)')),
223 ('i', 'e', 'g', ST_GeomFromText('POINT(138 26)')),
224 ('m', 't', 'u', ST_GeomFromText('POINT(119 237)')),
225 ('o', 'w', 's', ST_GeomFromText('POINT(193 166)')),
226 ('f', 'm', 'q', ST_GeomFromText('POINT(85 96)')),
227 ('x', 'l', 'x', ST_GeomFromText('POINT(58 115)')),
228 ('x', 'q', 'u', ST_GeomFromText('POINT(108 210)')),
229 ('b', 'h', 'i', ST_GeomFromText('POINT(250 139)')),
230 ('y', 'd', 'x', ST_GeomFromText('POINT(199 135)')),
231 ('w', 'h', 'p', ST_GeomFromText('POINT(247 233)')),
232 ('p', 'z', 't', ST_GeomFromText('POINT(148 249)')),
233 ('q', 'a', 'u', ST_GeomFromText('POINT(174 78)')),
234 ('v', 't', 'm', ST_GeomFromText('POINT(70 228)')),
235 ('t', 'n', 'f', ST_GeomFromText('POINT(123 2)')),
236 ('x', 't', 'b', ST_GeomFromText('POINT(35 50)')),
237 ('r', 'j', 'f', ST_GeomFromText('POINT(200 51)')),
238 ('s', 'q', 'o', ST_GeomFromText('POINT(23 184)')),
239 ('u', 'v', 'z', ST_GeomFromText('POINT(7 113)')),
240 ('v', 'u', 'l', ST_GeomFromText('POINT(145 190)')),
241 ('o', 'k', 'i', ST_GeomFromText('POINT(161 122)')),
242 ('l', 'y', 'e', ST_GeomFromText('POINT(17 232)')),
243 ('t', 'b', 'e', ST_GeomFromText('POINT(120 50)')),
244 ('e', 's', 'u', ST_GeomFromText('POINT(254 1)')),
245 ('d', 'd', 'u', ST_GeomFromText('POINT(167 140)')),
246 ('o', 'b', 'x', ST_GeomFromText('POINT(186 237)')),
247 ('m', 's', 's', ST_GeomFromText('POINT(172 149)')),
248 ('t', 'y', 'a', ST_GeomFromText('POINT(149 85)')),
249 ('x', 't', 'r', ST_GeomFromText('POINT(10 165)')),
250 ('g', 'c', 'e', ST_GeomFromText('POINT(95 165)')),
251 ('e', 'e', 'z', ST_GeomFromText('POINT(98 65)')),
252 ('f', 'v', 'i', ST_GeomFromText('POINT(149 144)')),
253 ('o', 'p', 'm', ST_GeomFromText('POINT(233 67)')),
254 ('t', 'u', 'b', ST_GeomFromText('POINT(109 215)')),
255 ('o', 'o', 'b', ST_GeomFromText('POINT(130 48)')),
256 ('e', 'm', 'h', ST_GeomFromText('POINT(88 189)')),
257 ('e', 'v', 'y', ST_GeomFromText('POINT(55 29)')),
258 ('e', 't', 'm', ST_GeomFromText('POINT(129 55)')),
259 ('p', 'p', 'i', ST_GeomFromText('POINT(126 222)')),
260 ('c', 'i', 'c', ST_GeomFromText('POINT(19 158)')),
261 ('c', 'b', 's', ST_GeomFromText('POINT(13 19)')),
262 ('u', 'y', 'a', ST_GeomFromText('POINT(114 5)')),
263 ('a', 'o', 'f', ST_GeomFromText('POINT(227 232)')),
264 ('t', 'c', 'z', ST_GeomFromText('POINT(63 62)')),
265 ('d', 'o', 'k', ST_GeomFromText('POINT(48 228)')),
266 ('x', 'c', 'e', ST_GeomFromText('POINT(204 2)')),
267 ('e', 'e', 'g', ST_GeomFromText('POINT(125 43)')),
268 ('o', 'r', 'f', ST_GeomFromText('POINT(171 140)'));
269 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
270 ('b', 'c', 'e', ST_GeomFromText('POINT(41 137)')),
271 ('p', 'y', 'k', ST_GeomFromText('POINT(50 22)')),
272 ('s', 'c', 'h', ST_GeomFromText('POINT(208 173)')),
273 ('x', 'u', 'l', ST_GeomFromText('POINT(199 175)')),
274 ('s', 'r', 'h', ST_GeomFromText('POINT(85 192)')),
275 ('j', 'k', 'u', ST_GeomFromText('POINT(18 25)')),
276 ('p', 'w', 'h', ST_GeomFromText('POINT(152 197)')),
277 ('e', 'd', 'c', ST_GeomFromText('POINT(229 3)')),
278 ('o', 'x', 'k', ST_GeomFromText('POINT(187 155)')),
279 ('o', 'b', 'k', ST_GeomFromText('POINT(208 150)')),
280 ('d', 'a', 'j', ST_GeomFromText('POINT(70 87)')),
281 ('f', 'e', 'k', ST_GeomFromText('POINT(156 96)')),
282 ('u', 'y', 'p', ST_GeomFromText('POINT(239 193)')),
283 ('n', 'v', 'p', ST_GeomFromText('POINT(223 98)')),
284 ('z', 'j', 'r', ST_GeomFromText('POINT(87 89)')),
285 ('h', 'x', 'x', ST_GeomFromText('POINT(92 0)')),
286 ('r', 'v', 'r', ST_GeomFromText('POINT(159 139)')),
287 ('v', 'g', 'g', ST_GeomFromText('POINT(16 229)')),
288 ('z', 'k', 'u', ST_GeomFromText('POINT(99 52)')),
289 ('p', 'p', 'o', ST_GeomFromText('POINT(105 125)')),
290 ('w', 'h', 'y', ST_GeomFromText('POINT(105 154)')),
291 ('v', 'y', 'z', ST_GeomFromText('POINT(134 238)')),
292 ('x', 'o', 'o', ST_GeomFromText('POINT(178 88)')),
293 ('z', 'w', 'd', ST_GeomFromText('POINT(123 60)')),
294 ('q', 'f', 'u', ST_GeomFromText('POINT(64 90)')),
295 ('s', 'n', 't', ST_GeomFromText('POINT(50 138)')),
296 ('v', 'p', 't', ST_GeomFromText('POINT(114 91)')),
297 ('a', 'o', 'n', ST_GeomFromText('POINT(78 43)')),
298 ('k', 'u', 'd', ST_GeomFromText('POINT(185 161)')),
299 ('w', 'd', 'n', ST_GeomFromText('POINT(25 92)')),
300 ('k', 'w', 'a', ST_GeomFromText('POINT(59 238)')),
301 ('t', 'c', 'f', ST_GeomFromText('POINT(65 87)')),
302 ('g', 's', 'p', ST_GeomFromText('POINT(238 126)')),
303 ('d', 'n', 'y', ST_GeomFromText('POINT(107 173)')),
304 ('l', 'a', 'w', ST_GeomFromText('POINT(125 152)')),
305 ('m', 'd', 'j', ST_GeomFromText('POINT(146 53)')),
306 ('q', 'm', 'c', ST_GeomFromText('POINT(217 187)')),
307 ('i', 'r', 'r', ST_GeomFromText('POINT(6 113)')),
308 ('e', 'j', 'b', ST_GeomFromText('POINT(37 83)')),
309 ('w', 'w', 'h', ST_GeomFromText('POINT(83 199)')),
310 ('k', 'b', 's', ST_GeomFromText('POINT(170 64)')),
311 ('s', 'b', 'c', ST_GeomFromText('POINT(163 130)')),
312 ('c', 'h', 'a', ST_GeomFromText('POINT(141 3)')),
313 ('k', 'j', 'u', ST_GeomFromText('POINT(143 76)')),
314 ('r', 'h', 'o', ST_GeomFromText('POINT(243 92)')),
315 ('i', 'd', 'b', ST_GeomFromText('POINT(205 13)')),
316 ('r', 'y', 'q', ST_GeomFromText('POINT(138 8)')),
317 ('m', 'o', 'i', ST_GeomFromText('POINT(36 45)')),
318 ('v', 'g', 'm', ST_GeomFromText('POINT(0 40)')),
319 ('f', 'e', 'i', ST_GeomFromText('POINT(76 6)')),
320 ('c', 'q', 'q', ST_GeomFromText('POINT(115 248)')),
321 ('x', 'c', 'i', ST_GeomFromText('POINT(29 74)')),
322 ('l', 's', 't', ST_GeomFromText('POINT(83 18)')),
323 ('t', 't', 'a', ST_GeomFromText('POINT(26 168)')),
324 ('u', 'n', 'x', ST_GeomFromText('POINT(200 110)')),
325 ('j', 'b', 'd', ST_GeomFromText('POINT(216 136)')),
326 ('s', 'p', 'w', ST_GeomFromText('POINT(38 156)')),
327 ('f', 'b', 'v', ST_GeomFromText('POINT(29 186)')),
328 ('v', 'e', 'r', ST_GeomFromText('POINT(149 40)')),
329 ('v', 't', 'm', ST_GeomFromText('POINT(184 24)')),
330 ('y', 'g', 'a', ST_GeomFromText('POINT(219 105)')),
331 ('s', 'f', 'i', ST_GeomFromText('POINT(114 130)')),
332 ('e', 'q', 'h', ST_GeomFromText('POINT(203 135)')),
333 ('h', 'g', 'b', ST_GeomFromText('POINT(9 208)')),
334 ('o', 'l', 'r', ST_GeomFromText('POINT(245 79)')),
335 ('s', 's', 'v', ST_GeomFromText('POINT(238 198)')),
336 ('w', 'w', 'z', ST_GeomFromText('POINT(209 232)')),
337 ('v', 'd', 'n', ST_GeomFromText('POINT(30 193)')),
338 ('q', 'w', 'k', ST_GeomFromText('POINT(133 18)')),
339 ('o', 'h', 'o', ST_GeomFromText('POINT(42 140)')),
340 ('f', 'f', 'h', ST_GeomFromText('POINT(145 1)')),
341 ('u', 's', 'r', ST_GeomFromText('POINT(70 62)')),
342 ('x', 'n', 'q', ST_GeomFromText('POINT(33 86)')),
343 ('u', 'p', 'v', ST_GeomFromText('POINT(232 220)')),
344 ('z', 'e', 'a', ST_GeomFromText('POINT(130 69)')),
345 ('r', 'u', 'z', ST_GeomFromText('POINT(243 241)')),
346 ('b', 'n', 't', ST_GeomFromText('POINT(120 12)')),
347 ('u', 'f', 's', ST_GeomFromText('POINT(190 212)')),
348 ('a', 'd', 'q', ST_GeomFromText('POINT(235 191)')),
349 ('f', 'q', 'm', ST_GeomFromText('POINT(176 2)')),
350 ('n', 'c', 's', ST_GeomFromText('POINT(218 163)')),
351 ('e', 'm', 'h', ST_GeomFromText('POINT(163 108)')),
352 ('c', 'f', 'l', ST_GeomFromText('POINT(220 115)')),
353 ('c', 'v', 'q', ST_GeomFromText('POINT(66 45)')),
354 ('w', 'v', 'x', ST_GeomFromText('POINT(251 220)')),
355 ('f', 'w', 'z', ST_GeomFromText('POINT(146 149)')),
356 ('h', 'n', 'h', ST_GeomFromText('POINT(148 128)')),
357 ('y', 'k', 'v', ST_GeomFromText('POINT(28 110)')),
358 ('c', 'x', 'q', ST_GeomFromText('POINT(13 13)')),
359 ('e', 'd', 's', ST_GeomFromText('POINT(91 190)')),
360 ('c', 'w', 'c', ST_GeomFromText('POINT(10 231)')),
361 ('u', 'j', 'n', ST_GeomFromText('POINT(250 21)')),
362 ('w', 'n', 'x', ST_GeomFromText('POINT(141 69)')),
363 ('f', 'p', 'y', ST_GeomFromText('POINT(228 246)')),
364 ('d', 'q', 'f', ST_GeomFromText('POINT(194 22)')),
365 ('d', 'z', 'l', ST_GeomFromText('POINT(233 181)')),
366 ('c', 'a', 'q', ST_GeomFromText('POINT(183 96)')),
367 ('m', 'i', 'd', ST_GeomFromText('POINT(117 226)')),
368 ('z', 'y', 'y', ST_GeomFromText('POINT(62 81)')),
369 ('g', 'v', 'm', ST_GeomFromText('POINT(66 158)'));
370 START TRANSACTION;
371 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
372 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
373 ROLLBACK;
374 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
375 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
376 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(0 1280)'));
377 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(45 1280)'));
378 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
379 DELETE FROM t1 WHERE id = 1280;
380 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
381 START TRANSACTION;
382 DELETE FROM t1 WHERE id = 1280;
383 ROLLBACK;
384 START TRANSACTION;
385 INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
386 ('m', 'u', 'p', ST_GeomFromText('POINT(1192 1181)'));
387 ROLLBACK;
388 SELECT COUNT(*) FROM t1;
389 COUNT(*)
390 353
391 UPDATE t1 SET spatial_point = ST_GeomFromText('POINT(123 456)') WHERE id < 2000;
392 SET @g1 = ST_GeomFromText('Polygon((123 456, 123 678, 456 678,456 456,123 456))');
393 DELETE FROM t1 WHERE MBRContains(@g1, t1.spatial_point);
394 SELECT COUNT(*) FROM t1;
395 COUNT(*)
396 353
397 DROP TABLE t1;
398 SET GLOBAL innodb_file_per_table=default;
399 SET GLOBAL innodb_file_per_table='on';
400 CREATE TABLE t1 (
401 id bigint(12) unsigned NOT NULL auto_increment,
402 c2 varchar(15) collate utf8_bin DEFAULT NULL,
403 c1 varchar(15) collate utf8_bin DEFAULT NULL,
404 c3 varchar(10) collate utf8_bin DEFAULT NULL,
405 spatial_point point NOT NULL SRID 0,
406 PRIMARY KEY(id),
407 SPATIAL KEY (spatial_point)
408 ) ROW_FORMAT=COMPRESSED ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
409 Warnings:
410 Warning 1681 Integer display width is deprecated and will be removed in a future release.
411 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
412 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
413 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
414 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
415 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
416 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
417 ('y', 's', 'j', ST_GeomFromText('POINT(167 74)')),
418 ('r', 'n', 'd', ST_GeomFromText('POINT(215 118)')),
419 ('g', 'n', 'e', ST_GeomFromText('POINT(203 98)')),
420 ('h', 'd', 'd', ST_GeomFromText('POINT(54 193)')),
421 ('r', 'x', 'y', ST_GeomFromText('POINT(47 69)')),
422 ('t', 'q', 'r', ST_GeomFromText('POINT(109 42)')),
423 ('a', 'z', 'd', ST_GeomFromText('POINT(0 154)')),
424 ('x', 'v', 'o', ST_GeomFromText('POINT(174 131)')),
425 ('b', 'r', 'a', ST_GeomFromText('POINT(114 253)')),
426 ('x', 'z', 'i', ST_GeomFromText('POINT(163 21)')),
427 ('w', 'p', 'i', ST_GeomFromText('POINT(42 102)')),
428 ('g', 'j', 'j', ST_GeomFromText('POINT(170 133)')),
429 ('m', 'g', 'n', ST_GeomFromText('POINT(28 22)')),
430 ('b', 'z', 'h', ST_GeomFromText('POINT(174 28)')),
431 ('q', 'k', 'f', ST_GeomFromText('POINT(233 73)')),
432 ('w', 'w', 'a', ST_GeomFromText('POINT(124 200)')),
433 ('t', 'j', 'w', ST_GeomFromText('POINT(252 101)')),
434 ('d', 'r', 'd', ST_GeomFromText('POINT(98 18)')),
435 ('w', 'o', 'y', ST_GeomFromText('POINT(165 31)')),
436 ('y', 'h', 't', ST_GeomFromText('POINT(14 220)')),
437 ('d', 'p', 'u', ST_GeomFromText('POINT(223 196)')),
438 ('g', 'y', 'g', ST_GeomFromText('POINT(207 96)')),
439 ('x', 'm', 'n', ST_GeomFromText('POINT(214 3)')),
440 ('g', 'v', 'e', ST_GeomFromText('POINT(140 205)')),
441 ('g', 'm', 'm', ST_GeomFromText('POINT(10 236)')),
442 ('i', 'r', 'j', ST_GeomFromText('POINT(137 228)')),
443 ('w', 's', 'p', ST_GeomFromText('POINT(115 6)')),
444 ('o', 'n', 'k', ST_GeomFromText('POINT(158 129)')),
445 ('j', 'h', 'l', ST_GeomFromText('POINT(129 72)')),
446 ('f', 'x', 'l', ST_GeomFromText('POINT(139 207)')),
447 ('u', 'd', 'n', ST_GeomFromText('POINT(125 109)')),
448 ('b', 'a', 'z', ST_GeomFromText('POINT(30 32)')),
449 ('m', 'h', 'o', ST_GeomFromText('POINT(251 251)')),
450 ('f', 'r', 'd', ST_GeomFromText('POINT(243 211)')),
451 ('b', 'd', 'r', ST_GeomFromText('POINT(232 80)')),
452 ('g', 'k', 'v', ST_GeomFromText('POINT(15 100)')),
453 ('i', 'f', 'c', ST_GeomFromText('POINT(109 66)')),
454 ('r', 't', 'j', ST_GeomFromText('POINT(178 6)')),
455 ('y', 'n', 'f', ST_GeomFromText('POINT(233 211)')),
456 ('f', 'y', 'm', ST_GeomFromText('POINT(99 16)')),
457 ('z', 'q', 'l', ST_GeomFromText('POINT(39 49)')),
458 ('j', 'c', 'r', ST_GeomFromText('POINT(75 187)')),
459 ('c', 'y', 'y', ST_GeomFromText('POINT(246 253)')),
460 ('w', 'u', 'd', ST_GeomFromText('POINT(56 190)')),
461 ('n', 'q', 'm', ST_GeomFromText('POINT(73 149)')),
462 ('d', 'y', 'a', ST_GeomFromText('POINT(134 6)')),
463 ('z', 's', 'w', ST_GeomFromText('POINT(216 225)')),
464 ('d', 'u', 'k', ST_GeomFromText('POINT(132 70)')),
465 ('f', 'v', 't', ST_GeomFromText('POINT(187 141)')),
466 ('r', 'r', 'a', ST_GeomFromText('POINT(152 39)')),
467 ('y', 'p', 'o', ST_GeomFromText('POINT(45 27)')),
468 ('p', 'n', 'm', ST_GeomFromText('POINT(228 148)')),
469 ('e', 'g', 'e', ST_GeomFromText('POINT(88 81)')),
470 ('m', 'a', 'h', ST_GeomFromText('POINT(35 29)')),
471 ('m', 'h', 'f', ST_GeomFromText('POINT(30 71)')),
472 ('h', 'k', 'i', ST_GeomFromText('POINT(244 78)')),
473 ('z', 'v', 'd', ST_GeomFromText('POINT(241 38)')),
474 ('q', 'l', 'j', ST_GeomFromText('POINT(13 71)')),
475 ('s', 'p', 'g', ST_GeomFromText('POINT(108 38)')),
476 ('q', 's', 'j', ST_GeomFromText('POINT(92 101)')),
477 ('l', 'h', 'g', ST_GeomFromText('POINT(120 78)')),
478 ('w', 't', 'b', ST_GeomFromText('POINT(193 109)')),
479 ('b', 's', 's', ST_GeomFromText('POINT(223 211)')),
480 ('w', 'w', 'y', ST_GeomFromText('POINT(122 42)')),
481 ('q', 'c', 'c', ST_GeomFromText('POINT(104 102)')),
482 ('w', 'g', 'n', ST_GeomFromText('POINT(213 120)')),
483 ('p', 'q', 'a', ST_GeomFromText('POINT(247 148)')),
484 ('c', 'z', 'e', ST_GeomFromText('POINT(18 106)')),
485 ('z', 'u', 'n', ST_GeomFromText('POINT(70 133)')),
486 ('j', 'n', 'x', ST_GeomFromText('POINT(232 13)')),
487 ('e', 'h', 'f', ST_GeomFromText('POINT(22 135)')),
488 ('w', 'l', 'f', ST_GeomFromText('POINT(9 180)')),
489 ('a', 'v', 'q', ST_GeomFromText('POINT(163 228)')),
490 ('i', 'z', 'o', ST_GeomFromText('POINT(180 100)')),
491 ('e', 'c', 'l', ST_GeomFromText('POINT(182 231)')),
492 ('c', 'k', 'o', ST_GeomFromText('POINT(19 60)')),
493 ('q', 'f', 'p', ST_GeomFromText('POINT(79 95)')),
494 ('m', 'd', 'r', ST_GeomFromText('POINT(3 127)')),
495 ('m', 'e', 't', ST_GeomFromText('POINT(136 154)')),
496 ('w', 'w', 'w', ST_GeomFromText('POINT(102 15)')),
497 ('l', 'n', 'q', ST_GeomFromText('POINT(71 196)')),
498 ('p', 'k', 'c', ST_GeomFromText('POINT(47 139)')),
499 ('j', 'o', 'r', ST_GeomFromText('POINT(177 128)')),
500 ('j', 'q', 'a', ST_GeomFromText('POINT(170 6)')),
501 ('b', 'a', 'o', ST_GeomFromText('POINT(63 211)')),
502 ('g', 's', 'o', ST_GeomFromText('POINT(144 251)')),
503 ('w', 'u', 'w', ST_GeomFromText('POINT(221 214)')),
504 ('g', 'a', 'm', ST_GeomFromText('POINT(14 102)')),
505 ('u', 'q', 'z', ST_GeomFromText('POINT(86 200)')),
506 ('k', 'a', 'm', ST_GeomFromText('POINT(144 222)')),
507 ('j', 'u', 'r', ST_GeomFromText('POINT(216 142)')),
508 ('q', 'k', 'v', ST_GeomFromText('POINT(121 236)')),
509 ('p', 'o', 'r', ST_GeomFromText('POINT(108 102)')),
510 ('b', 'd', 'x', ST_GeomFromText('POINT(127 198)')),
511 ('k', 's', 'a', ST_GeomFromText('POINT(2 150)')),
512 ('f', 'm', 'f', ST_GeomFromText('POINT(160 191)')),
513 ('q', 'y', 'x', ST_GeomFromText('POINT(98 111)')),
514 ('o', 'f', 'm', ST_GeomFromText('POINT(232 218)')),
515 ('c', 'w', 'j', ST_GeomFromText('POINT(156 165)')),
516 ('s', 'q', 'v', ST_GeomFromText('POINT(98 161)'));
517 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
518 ('f', 'y', 'p', ST_GeomFromText('POINT(109 235)')),
519 ('b', 'e', 'v', ST_GeomFromText('POINT(20 48)')),
520 ('i', 'u', 'f', ST_GeomFromText('POINT(15 55)')),
521 ('o', 'r', 'z', ST_GeomFromText('POINT(105 64)')),
522 ('a', 'p', 'a', ST_GeomFromText('POINT(142 236)')),
523 ('g', 'i', 'k', ST_GeomFromText('POINT(10 49)')),
524 ('x', 'z', 'x', ST_GeomFromText('POINT(192 200)')),
525 ('c', 'v', 'r', ST_GeomFromText('POINT(94 168)')),
526 ('y', 'z', 'e', ST_GeomFromText('POINT(141 51)')),
527 ('h', 'm', 'd', ST_GeomFromText('POINT(35 251)')),
528 ('v', 'm', 'q', ST_GeomFromText('POINT(44 90)')),
529 ('j', 'l', 'z', ST_GeomFromText('POINT(67 237)')),
530 ('i', 'v', 'a', ST_GeomFromText('POINT(75 14)')),
531 ('b', 'q', 't', ST_GeomFromText('POINT(153 33)')),
532 ('e', 'm', 'a', ST_GeomFromText('POINT(247 49)')),
533 ('l', 'y', 'g', ST_GeomFromText('POINT(56 203)')),
534 ('v', 'o', 'r', ST_GeomFromText('POINT(90 54)')),
535 ('r', 'n', 'd', ST_GeomFromText('POINT(135 83)')),
536 ('j', 't', 'u', ST_GeomFromText('POINT(174 239)')),
537 ('u', 'n', 'g', ST_GeomFromText('POINT(104 191)')),
538 ('p', 'q', 'y', ST_GeomFromText('POINT(63 171)')),
539 ('o', 'q', 'p', ST_GeomFromText('POINT(192 103)')),
540 ('f', 'x', 'e', ST_GeomFromText('POINT(244 30)')),
541 ('n', 'x', 'c', ST_GeomFromText('POINT(92 103)')),
542 ('r', 'q', 'z', ST_GeomFromText('POINT(166 20)')),
543 ('s', 'a', 'j', ST_GeomFromText('POINT(137 205)')),
544 ('z', 't', 't', ST_GeomFromText('POINT(99 134)')),
545 ('o', 'm', 'j', ST_GeomFromText('POINT(217 3)')),
546 ('n', 'h', 'j', ST_GeomFromText('POINT(211 17)')),
547 ('v', 'v', 'a', ST_GeomFromText('POINT(41 137)')),
548 ('q', 'o', 'j', ST_GeomFromText('POINT(5 92)')),
549 ('z', 'y', 'e', ST_GeomFromText('POINT(175 212)')),
550 ('j', 'z', 'h', ST_GeomFromText('POINT(224 194)')),
551 ('a', 'g', 'm', ST_GeomFromText('POINT(31 119)')),
552 ('p', 'c', 'f', ST_GeomFromText('POINT(17 221)')),
553 ('t', 'h', 'k', ST_GeomFromText('POINT(26 203)')),
554 ('u', 'w', 'p', ST_GeomFromText('POINT(47 185)')),
555 ('z', 'a', 'c', ST_GeomFromText('POINT(61 133)')),
556 ('u', 'k', 'a', ST_GeomFromText('POINT(210 115)')),
557 ('k', 'f', 'h', ST_GeomFromText('POINT(125 113)')),
558 ('t', 'v', 'y', ST_GeomFromText('POINT(12 239)')),
559 ('u', 'v', 'd', ST_GeomFromText('POINT(90 24)')),
560 ('m', 'y', 'w', ST_GeomFromText('POINT(25 243)')),
561 ('d', 'n', 'g', ST_GeomFromText('POINT(122 92)')),
562 ('z', 'm', 'f', ST_GeomFromText('POINT(235 110)')),
563 ('q', 'd', 'f', ST_GeomFromText('POINT(233 217)')),
564 ('a', 'v', 'u', ST_GeomFromText('POINT(69 59)')),
565 ('x', 'k', 'p', ST_GeomFromText('POINT(240 14)')),
566 ('i', 'v', 'r', ST_GeomFromText('POINT(154 42)')),
567 ('w', 'h', 'l', ST_GeomFromText('POINT(178 156)')),
568 ('d', 'h', 'n', ST_GeomFromText('POINT(65 157)')),
569 ('c', 'k', 'z', ST_GeomFromText('POINT(62 33)')),
570 ('e', 'l', 'w', ST_GeomFromText('POINT(162 1)')),
571 ('r', 'f', 'i', ST_GeomFromText('POINT(127 71)')),
572 ('q', 'm', 'c', ST_GeomFromText('POINT(63 118)')),
573 ('c', 'h', 'u', ST_GeomFromText('POINT(205 203)')),
574 ('d', 't', 'p', ST_GeomFromText('POINT(234 87)')),
575 ('s', 'g', 'h', ST_GeomFromText('POINT(149 34)')),
576 ('o', 'b', 'q', ST_GeomFromText('POINT(159 179)')),
577 ('k', 'u', 'f', ST_GeomFromText('POINT(202 254)')),
578 ('u', 'f', 'g', ST_GeomFromText('POINT(70 15)')),
579 ('x', 's', 'b', ST_GeomFromText('POINT(25 181)')),
580 ('s', 'c', 'g', ST_GeomFromText('POINT(252 17)')),
581 ('a', 'c', 'f', ST_GeomFromText('POINT(89 67)')),
582 ('r', 'e', 'q', ST_GeomFromText('POINT(55 54)')),
583 ('f', 'i', 'k', ST_GeomFromText('POINT(178 230)')),
584 ('p', 'e', 'l', ST_GeomFromText('POINT(198 28)')),
585 ('w', 'o', 'd', ST_GeomFromText('POINT(204 189)')),
586 ('c', 'a', 'g', ST_GeomFromText('POINT(230 178)')),
587 ('r', 'o', 'e', ST_GeomFromText('POINT(61 116)')),
588 ('w', 'a', 'a', ST_GeomFromText('POINT(178 237)')),
589 ('v', 'd', 'e', ST_GeomFromText('POINT(70 85)')),
590 ('k', 'c', 'e', ST_GeomFromText('POINT(147 118)')),
591 ('d', 'q', 't', ST_GeomFromText('POINT(218 77)')),
592 ('k', 'g', 'f', ST_GeomFromText('POINT(192 113)')),
593 ('w', 'n', 'e', ST_GeomFromText('POINT(92 124)')),
594 ('r', 'm', 'q', ST_GeomFromText('POINT(130 65)')),
595 ('o', 'r', 'r', ST_GeomFromText('POINT(174 233)')),
596 ('k', 'n', 't', ST_GeomFromText('POINT(175 147)')),
597 ('q', 'm', 'r', ST_GeomFromText('POINT(18 208)')),
598 ('l', 'd', 'i', ST_GeomFromText('POINT(13 104)')),
599 ('w', 'o', 'y', ST_GeomFromText('POINT(207 39)')),
600 ('p', 'u', 'o', ST_GeomFromText('POINT(114 31)')),
601 ('y', 'a', 'p', ST_GeomFromText('POINT(106 59)')),
602 ('a', 'x', 'z', ST_GeomFromText('POINT(17 57)')),
603 ('v', 'h', 'x', ST_GeomFromText('POINT(170 13)')),
604 ('t', 's', 'u', ST_GeomFromText('POINT(84 18)')),
605 ('z', 'z', 'f', ST_GeomFromText('POINT(250 197)')),
606 ('l', 'z', 't', ST_GeomFromText('POINT(59 80)')),
607 ('j', 'g', 's', ST_GeomFromText('POINT(54 26)')),
608 ('g', 'v', 'm', ST_GeomFromText('POINT(89 98)')),
609 ('q', 'v', 'b', ST_GeomFromText('POINT(39 240)')),
610 ('x', 'k', 'v', ST_GeomFromText('POINT(246 207)')),
611 ('k', 'u', 'i', ST_GeomFromText('POINT(105 111)')),
612 ('w', 'z', 's', ST_GeomFromText('POINT(235 8)')),
613 ('d', 'd', 'd', ST_GeomFromText('POINT(105 4)')),
614 ('c', 'z', 'q', ST_GeomFromText('POINT(13 140)')),
615 ('m', 'k', 'i', ST_GeomFromText('POINT(208 120)')),
616 ('g', 'a', 'g', ST_GeomFromText('POINT(9 182)')),
617 ('z', 'j', 'r', ST_GeomFromText('POINT(149 153)')),
618 ('h', 'f', 'g', ST_GeomFromText('POINT(81 236)')),
619 ('m', 'e', 'q', ST_GeomFromText('POINT(209 215)')),
620 ('c', 'h', 'y', ST_GeomFromText('POINT(235 70)')),
621 ('i', 'e', 'g', ST_GeomFromText('POINT(138 26)')),
622 ('m', 't', 'u', ST_GeomFromText('POINT(119 237)')),
623 ('o', 'w', 's', ST_GeomFromText('POINT(193 166)')),
624 ('f', 'm', 'q', ST_GeomFromText('POINT(85 96)')),
625 ('x', 'l', 'x', ST_GeomFromText('POINT(58 115)')),
626 ('x', 'q', 'u', ST_GeomFromText('POINT(108 210)')),
627 ('b', 'h', 'i', ST_GeomFromText('POINT(250 139)')),
628 ('y', 'd', 'x', ST_GeomFromText('POINT(199 135)')),
629 ('w', 'h', 'p', ST_GeomFromText('POINT(247 233)')),
630 ('p', 'z', 't', ST_GeomFromText('POINT(148 249)')),
631 ('q', 'a', 'u', ST_GeomFromText('POINT(174 78)')),
632 ('v', 't', 'm', ST_GeomFromText('POINT(70 228)')),
633 ('t', 'n', 'f', ST_GeomFromText('POINT(123 2)')),
634 ('x', 't', 'b', ST_GeomFromText('POINT(35 50)')),
635 ('r', 'j', 'f', ST_GeomFromText('POINT(200 51)')),
636 ('s', 'q', 'o', ST_GeomFromText('POINT(23 184)')),
637 ('u', 'v', 'z', ST_GeomFromText('POINT(7 113)')),
638 ('v', 'u', 'l', ST_GeomFromText('POINT(145 190)')),
639 ('o', 'k', 'i', ST_GeomFromText('POINT(161 122)')),
640 ('l', 'y', 'e', ST_GeomFromText('POINT(17 232)')),
641 ('t', 'b', 'e', ST_GeomFromText('POINT(120 50)')),
642 ('e', 's', 'u', ST_GeomFromText('POINT(254 1)')),
643 ('d', 'd', 'u', ST_GeomFromText('POINT(167 140)')),
644 ('o', 'b', 'x', ST_GeomFromText('POINT(186 237)')),
645 ('m', 's', 's', ST_GeomFromText('POINT(172 149)')),
646 ('t', 'y', 'a', ST_GeomFromText('POINT(149 85)')),
647 ('x', 't', 'r', ST_GeomFromText('POINT(10 165)')),
648 ('g', 'c', 'e', ST_GeomFromText('POINT(95 165)')),
649 ('e', 'e', 'z', ST_GeomFromText('POINT(98 65)')),
650 ('f', 'v', 'i', ST_GeomFromText('POINT(149 144)')),
651 ('o', 'p', 'm', ST_GeomFromText('POINT(233 67)')),
652 ('t', 'u', 'b', ST_GeomFromText('POINT(109 215)')),
653 ('o', 'o', 'b', ST_GeomFromText('POINT(130 48)')),
654 ('e', 'm', 'h', ST_GeomFromText('POINT(88 189)')),
655 ('e', 'v', 'y', ST_GeomFromText('POINT(55 29)')),
656 ('e', 't', 'm', ST_GeomFromText('POINT(129 55)')),
657 ('p', 'p', 'i', ST_GeomFromText('POINT(126 222)')),
658 ('c', 'i', 'c', ST_GeomFromText('POINT(19 158)')),
659 ('c', 'b', 's', ST_GeomFromText('POINT(13 19)')),
660 ('u', 'y', 'a', ST_GeomFromText('POINT(114 5)')),
661 ('a', 'o', 'f', ST_GeomFromText('POINT(227 232)')),
662 ('t', 'c', 'z', ST_GeomFromText('POINT(63 62)')),
663 ('d', 'o', 'k', ST_GeomFromText('POINT(48 228)')),
664 ('x', 'c', 'e', ST_GeomFromText('POINT(204 2)')),
665 ('e', 'e', 'g', ST_GeomFromText('POINT(125 43)')),
666 ('o', 'r', 'f', ST_GeomFromText('POINT(171 140)'));
667 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
668 ('b', 'c', 'e', ST_GeomFromText('POINT(41 137)')),
669 ('p', 'y', 'k', ST_GeomFromText('POINT(50 22)')),
670 ('s', 'c', 'h', ST_GeomFromText('POINT(208 173)')),
671 ('x', 'u', 'l', ST_GeomFromText('POINT(199 175)')),
672 ('s', 'r', 'h', ST_GeomFromText('POINT(85 192)')),
673 ('j', 'k', 'u', ST_GeomFromText('POINT(18 25)')),
674 ('p', 'w', 'h', ST_GeomFromText('POINT(152 197)')),
675 ('e', 'd', 'c', ST_GeomFromText('POINT(229 3)')),
676 ('o', 'x', 'k', ST_GeomFromText('POINT(187 155)')),
677 ('o', 'b', 'k', ST_GeomFromText('POINT(208 150)')),
678 ('d', 'a', 'j', ST_GeomFromText('POINT(70 87)')),
679 ('f', 'e', 'k', ST_GeomFromText('POINT(156 96)')),
680 ('u', 'y', 'p', ST_GeomFromText('POINT(239 193)')),
681 ('n', 'v', 'p', ST_GeomFromText('POINT(223 98)')),
682 ('z', 'j', 'r', ST_GeomFromText('POINT(87 89)')),
683 ('h', 'x', 'x', ST_GeomFromText('POINT(92 0)')),
684 ('r', 'v', 'r', ST_GeomFromText('POINT(159 139)')),
685 ('v', 'g', 'g', ST_GeomFromText('POINT(16 229)')),
686 ('z', 'k', 'u', ST_GeomFromText('POINT(99 52)')),
687 ('p', 'p', 'o', ST_GeomFromText('POINT(105 125)')),
688 ('w', 'h', 'y', ST_GeomFromText('POINT(105 154)')),
689 ('v', 'y', 'z', ST_GeomFromText('POINT(134 238)')),
690 ('x', 'o', 'o', ST_GeomFromText('POINT(178 88)')),
691 ('z', 'w', 'd', ST_GeomFromText('POINT(123 60)')),
692 ('q', 'f', 'u', ST_GeomFromText('POINT(64 90)')),
693 ('s', 'n', 't', ST_GeomFromText('POINT(50 138)')),
694 ('v', 'p', 't', ST_GeomFromText('POINT(114 91)')),
695 ('a', 'o', 'n', ST_GeomFromText('POINT(78 43)')),
696 ('k', 'u', 'd', ST_GeomFromText('POINT(185 161)')),
697 ('w', 'd', 'n', ST_GeomFromText('POINT(25 92)')),
698 ('k', 'w', 'a', ST_GeomFromText('POINT(59 238)')),
699 ('t', 'c', 'f', ST_GeomFromText('POINT(65 87)')),
700 ('g', 's', 'p', ST_GeomFromText('POINT(238 126)')),
701 ('d', 'n', 'y', ST_GeomFromText('POINT(107 173)')),
702 ('l', 'a', 'w', ST_GeomFromText('POINT(125 152)')),
703 ('m', 'd', 'j', ST_GeomFromText('POINT(146 53)')),
704 ('q', 'm', 'c', ST_GeomFromText('POINT(217 187)')),
705 ('i', 'r', 'r', ST_GeomFromText('POINT(6 113)')),
706 ('e', 'j', 'b', ST_GeomFromText('POINT(37 83)')),
707 ('w', 'w', 'h', ST_GeomFromText('POINT(83 199)')),
708 ('k', 'b', 's', ST_GeomFromText('POINT(170 64)')),
709 ('s', 'b', 'c', ST_GeomFromText('POINT(163 130)')),
710 ('c', 'h', 'a', ST_GeomFromText('POINT(141 3)')),
711 ('k', 'j', 'u', ST_GeomFromText('POINT(143 76)')),
712 ('r', 'h', 'o', ST_GeomFromText('POINT(243 92)')),
713 ('i', 'd', 'b', ST_GeomFromText('POINT(205 13)')),
714 ('r', 'y', 'q', ST_GeomFromText('POINT(138 8)')),
715 ('m', 'o', 'i', ST_GeomFromText('POINT(36 45)')),
716 ('v', 'g', 'm', ST_GeomFromText('POINT(0 40)')),
717 ('f', 'e', 'i', ST_GeomFromText('POINT(76 6)')),
718 ('c', 'q', 'q', ST_GeomFromText('POINT(115 248)')),
719 ('x', 'c', 'i', ST_GeomFromText('POINT(29 74)')),
720 ('l', 's', 't', ST_GeomFromText('POINT(83 18)')),
721 ('t', 't', 'a', ST_GeomFromText('POINT(26 168)')),
722 ('u', 'n', 'x', ST_GeomFromText('POINT(200 110)')),
723 ('j', 'b', 'd', ST_GeomFromText('POINT(216 136)')),
724 ('s', 'p', 'w', ST_GeomFromText('POINT(38 156)')),
725 ('f', 'b', 'v', ST_GeomFromText('POINT(29 186)')),
726 ('v', 'e', 'r', ST_GeomFromText('POINT(149 40)')),
727 ('v', 't', 'm', ST_GeomFromText('POINT(184 24)')),
728 ('y', 'g', 'a', ST_GeomFromText('POINT(219 105)')),
729 ('s', 'f', 'i', ST_GeomFromText('POINT(114 130)')),
730 ('e', 'q', 'h', ST_GeomFromText('POINT(203 135)')),
731 ('h', 'g', 'b', ST_GeomFromText('POINT(9 208)')),
732 ('o', 'l', 'r', ST_GeomFromText('POINT(245 79)')),
733 ('s', 's', 'v', ST_GeomFromText('POINT(238 198)')),
734 ('w', 'w', 'z', ST_GeomFromText('POINT(209 232)')),
735 ('v', 'd', 'n', ST_GeomFromText('POINT(30 193)')),
736 ('q', 'w', 'k', ST_GeomFromText('POINT(133 18)')),
737 ('o', 'h', 'o', ST_GeomFromText('POINT(42 140)')),
738 ('f', 'f', 'h', ST_GeomFromText('POINT(145 1)')),
739 ('u', 's', 'r', ST_GeomFromText('POINT(70 62)')),
740 ('x', 'n', 'q', ST_GeomFromText('POINT(33 86)')),
741 ('u', 'p', 'v', ST_GeomFromText('POINT(232 220)')),
742 ('z', 'e', 'a', ST_GeomFromText('POINT(130 69)')),
743 ('r', 'u', 'z', ST_GeomFromText('POINT(243 241)')),
744 ('b', 'n', 't', ST_GeomFromText('POINT(120 12)')),
745 ('u', 'f', 's', ST_GeomFromText('POINT(190 212)')),
746 ('a', 'd', 'q', ST_GeomFromText('POINT(235 191)')),
747 ('f', 'q', 'm', ST_GeomFromText('POINT(176 2)')),
748 ('n', 'c', 's', ST_GeomFromText('POINT(218 163)')),
749 ('e', 'm', 'h', ST_GeomFromText('POINT(163 108)')),
750 ('c', 'f', 'l', ST_GeomFromText('POINT(220 115)')),
751 ('c', 'v', 'q', ST_GeomFromText('POINT(66 45)')),
752 ('w', 'v', 'x', ST_GeomFromText('POINT(251 220)')),
753 ('f', 'w', 'z', ST_GeomFromText('POINT(146 149)')),
754 ('h', 'n', 'h', ST_GeomFromText('POINT(148 128)')),
755 ('y', 'k', 'v', ST_GeomFromText('POINT(28 110)')),
756 ('c', 'x', 'q', ST_GeomFromText('POINT(13 13)')),
757 ('e', 'd', 's', ST_GeomFromText('POINT(91 190)')),
758 ('c', 'w', 'c', ST_GeomFromText('POINT(10 231)')),
759 ('u', 'j', 'n', ST_GeomFromText('POINT(250 21)')),
760 ('w', 'n', 'x', ST_GeomFromText('POINT(141 69)')),
761 ('f', 'p', 'y', ST_GeomFromText('POINT(228 246)')),
762 ('d', 'q', 'f', ST_GeomFromText('POINT(194 22)')),
763 ('d', 'z', 'l', ST_GeomFromText('POINT(233 181)')),
764 ('c', 'a', 'q', ST_GeomFromText('POINT(183 96)')),
765 ('m', 'i', 'd', ST_GeomFromText('POINT(117 226)')),
766 ('z', 'y', 'y', ST_GeomFromText('POINT(62 81)')),
767 ('g', 'v', 'm', ST_GeomFromText('POINT(66 158)'));
768 START TRANSACTION;
769 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
770 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
771 ROLLBACK;
772 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
773 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
774 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(0 1280)'));
775 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(45 1280)'));
776 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
777 DELETE FROM t1 WHERE id = 1280;
778 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
779 START TRANSACTION;
780 DELETE FROM t1 WHERE id = 1280;
781 ROLLBACK;
782 START TRANSACTION;
783 INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
784 ('m', 'u', 'p', ST_GeomFromText('POINT(1192 1181)'));
785 ROLLBACK;
786 SELECT COUNT(*) FROM t1;
787 COUNT(*)
788 353
789 UPDATE t1 SET spatial_point = ST_GeomFromText('POINT(123 456)') WHERE id < 2000;
790 SET @g1 = ST_GeomFromText('Polygon((123 456, 123 678, 456 678,456 456,123 456))');
791 DELETE FROM t1 WHERE MBRContains(@g1, t1.spatial_point);
792 SELECT COUNT(*) FROM t1;
793 COUNT(*)
794 353
795 DROP TABLE t1;
796 SET GLOBAL innodb_file_per_table=default;
797 SET GLOBAL innodb_file_per_table='on';
798 CREATE TABLE t1 (
799 id bigint(12) unsigned NOT NULL auto_increment,
800 c2 varchar(15) collate utf8_bin DEFAULT NULL,
801 c1 varchar(15) collate utf8_bin DEFAULT NULL,
802 c3 varchar(10) collate utf8_bin DEFAULT NULL,
803 spatial_point point NOT NULL SRID 0,
804 PRIMARY KEY(id),
805 SPATIAL KEY (spatial_point)
806 ) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
807 Warnings:
808 Warning 1681 Integer display width is deprecated and will be removed in a future release.
809 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
810 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
811 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
812 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
813 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
814 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
815 ('y', 's', 'j', ST_GeomFromText('POINT(167 74)')),
816 ('r', 'n', 'd', ST_GeomFromText('POINT(215 118)')),
817 ('g', 'n', 'e', ST_GeomFromText('POINT(203 98)')),
818 ('h', 'd', 'd', ST_GeomFromText('POINT(54 193)')),
819 ('r', 'x', 'y', ST_GeomFromText('POINT(47 69)')),
820 ('t', 'q', 'r', ST_GeomFromText('POINT(109 42)')),
821 ('a', 'z', 'd', ST_GeomFromText('POINT(0 154)')),
822 ('x', 'v', 'o', ST_GeomFromText('POINT(174 131)')),
823 ('b', 'r', 'a', ST_GeomFromText('POINT(114 253)')),
824 ('x', 'z', 'i', ST_GeomFromText('POINT(163 21)')),
825 ('w', 'p', 'i', ST_GeomFromText('POINT(42 102)')),
826 ('g', 'j', 'j', ST_GeomFromText('POINT(170 133)')),
827 ('m', 'g', 'n', ST_GeomFromText('POINT(28 22)')),
828 ('b', 'z', 'h', ST_GeomFromText('POINT(174 28)')),
829 ('q', 'k', 'f', ST_GeomFromText('POINT(233 73)')),
830 ('w', 'w', 'a', ST_GeomFromText('POINT(124 200)')),
831 ('t', 'j', 'w', ST_GeomFromText('POINT(252 101)')),
832 ('d', 'r', 'd', ST_GeomFromText('POINT(98 18)')),
833 ('w', 'o', 'y', ST_GeomFromText('POINT(165 31)')),
834 ('y', 'h', 't', ST_GeomFromText('POINT(14 220)')),
835 ('d', 'p', 'u', ST_GeomFromText('POINT(223 196)')),
836 ('g', 'y', 'g', ST_GeomFromText('POINT(207 96)')),
837 ('x', 'm', 'n', ST_GeomFromText('POINT(214 3)')),
838 ('g', 'v', 'e', ST_GeomFromText('POINT(140 205)')),
839 ('g', 'm', 'm', ST_GeomFromText('POINT(10 236)')),
840 ('i', 'r', 'j', ST_GeomFromText('POINT(137 228)')),
841 ('w', 's', 'p', ST_GeomFromText('POINT(115 6)')),
842 ('o', 'n', 'k', ST_GeomFromText('POINT(158 129)')),
843 ('j', 'h', 'l', ST_GeomFromText('POINT(129 72)')),
844 ('f', 'x', 'l', ST_GeomFromText('POINT(139 207)')),
845 ('u', 'd', 'n', ST_GeomFromText('POINT(125 109)')),
846 ('b', 'a', 'z', ST_GeomFromText('POINT(30 32)')),
847 ('m', 'h', 'o', ST_GeomFromText('POINT(251 251)')),
848 ('f', 'r', 'd', ST_GeomFromText('POINT(243 211)')),
849 ('b', 'd', 'r', ST_GeomFromText('POINT(232 80)')),
850 ('g', 'k', 'v', ST_GeomFromText('POINT(15 100)')),
851 ('i', 'f', 'c', ST_GeomFromText('POINT(109 66)')),
852 ('r', 't', 'j', ST_GeomFromText('POINT(178 6)')),
853 ('y', 'n', 'f', ST_GeomFromText('POINT(233 211)')),
854 ('f', 'y', 'm', ST_GeomFromText('POINT(99 16)')),
855 ('z', 'q', 'l', ST_GeomFromText('POINT(39 49)')),
856 ('j', 'c', 'r', ST_GeomFromText('POINT(75 187)')),
857 ('c', 'y', 'y', ST_GeomFromText('POINT(246 253)')),
858 ('w', 'u', 'd', ST_GeomFromText('POINT(56 190)')),
859 ('n', 'q', 'm', ST_GeomFromText('POINT(73 149)')),
860 ('d', 'y', 'a', ST_GeomFromText('POINT(134 6)')),
861 ('z', 's', 'w', ST_GeomFromText('POINT(216 225)')),
862 ('d', 'u', 'k', ST_GeomFromText('POINT(132 70)')),
863 ('f', 'v', 't', ST_GeomFromText('POINT(187 141)')),
864 ('r', 'r', 'a', ST_GeomFromText('POINT(152 39)')),
865 ('y', 'p', 'o', ST_GeomFromText('POINT(45 27)')),
866 ('p', 'n', 'm', ST_GeomFromText('POINT(228 148)')),
867 ('e', 'g', 'e', ST_GeomFromText('POINT(88 81)')),
868 ('m', 'a', 'h', ST_GeomFromText('POINT(35 29)')),
869 ('m', 'h', 'f', ST_GeomFromText('POINT(30 71)')),
870 ('h', 'k', 'i', ST_GeomFromText('POINT(244 78)')),
871 ('z', 'v', 'd', ST_GeomFromText('POINT(241 38)')),
872 ('q', 'l', 'j', ST_GeomFromText('POINT(13 71)')),
873 ('s', 'p', 'g', ST_GeomFromText('POINT(108 38)')),
874 ('q', 's', 'j', ST_GeomFromText('POINT(92 101)')),
875 ('l', 'h', 'g', ST_GeomFromText('POINT(120 78)')),
876 ('w', 't', 'b', ST_GeomFromText('POINT(193 109)')),
877 ('b', 's', 's', ST_GeomFromText('POINT(223 211)')),
878 ('w', 'w', 'y', ST_GeomFromText('POINT(122 42)')),
879 ('q', 'c', 'c', ST_GeomFromText('POINT(104 102)')),
880 ('w', 'g', 'n', ST_GeomFromText('POINT(213 120)')),
881 ('p', 'q', 'a', ST_GeomFromText('POINT(247 148)')),
882 ('c', 'z', 'e', ST_GeomFromText('POINT(18 106)')),
883 ('z', 'u', 'n', ST_GeomFromText('POINT(70 133)')),
884 ('j', 'n', 'x', ST_GeomFromText('POINT(232 13)')),
885 ('e', 'h', 'f', ST_GeomFromText('POINT(22 135)')),
886 ('w', 'l', 'f', ST_GeomFromText('POINT(9 180)')),
887 ('a', 'v', 'q', ST_GeomFromText('POINT(163 228)')),
888 ('i', 'z', 'o', ST_GeomFromText('POINT(180 100)')),
889 ('e', 'c', 'l', ST_GeomFromText('POINT(182 231)')),
890 ('c', 'k', 'o', ST_GeomFromText('POINT(19 60)')),
891 ('q', 'f', 'p', ST_GeomFromText('POINT(79 95)')),
892 ('m', 'd', 'r', ST_GeomFromText('POINT(3 127)')),
893 ('m', 'e', 't', ST_GeomFromText('POINT(136 154)')),
894 ('w', 'w', 'w', ST_GeomFromText('POINT(102 15)')),
895 ('l', 'n', 'q', ST_GeomFromText('POINT(71 196)')),
896 ('p', 'k', 'c', ST_GeomFromText('POINT(47 139)')),
897 ('j', 'o', 'r', ST_GeomFromText('POINT(177 128)')),
898 ('j', 'q', 'a', ST_GeomFromText('POINT(170 6)')),
899 ('b', 'a', 'o', ST_GeomFromText('POINT(63 211)')),
900 ('g', 's', 'o', ST_GeomFromText('POINT(144 251)')),
901 ('w', 'u', 'w', ST_GeomFromText('POINT(221 214)')),
902 ('g', 'a', 'm', ST_GeomFromText('POINT(14 102)')),
903 ('u', 'q', 'z', ST_GeomFromText('POINT(86 200)')),
904 ('k', 'a', 'm', ST_GeomFromText('POINT(144 222)')),
905 ('j', 'u', 'r', ST_GeomFromText('POINT(216 142)')),
906 ('q', 'k', 'v', ST_GeomFromText('POINT(121 236)')),
907 ('p', 'o', 'r', ST_GeomFromText('POINT(108 102)')),
908 ('b', 'd', 'x', ST_GeomFromText('POINT(127 198)')),
909 ('k', 's', 'a', ST_GeomFromText('POINT(2 150)')),
910 ('f', 'm', 'f', ST_GeomFromText('POINT(160 191)')),
911 ('q', 'y', 'x', ST_GeomFromText('POINT(98 111)')),
912 ('o', 'f', 'm', ST_GeomFromText('POINT(232 218)')),
913 ('c', 'w', 'j', ST_GeomFromText('POINT(156 165)')),
914 ('s', 'q', 'v', ST_GeomFromText('POINT(98 161)'));
915 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
916 ('f', 'y', 'p', ST_GeomFromText('POINT(109 235)')),
917 ('b', 'e', 'v', ST_GeomFromText('POINT(20 48)')),
918 ('i', 'u', 'f', ST_GeomFromText('POINT(15 55)')),
919 ('o', 'r', 'z', ST_GeomFromText('POINT(105 64)')),
920 ('a', 'p', 'a', ST_GeomFromText('POINT(142 236)')),
921 ('g', 'i', 'k', ST_GeomFromText('POINT(10 49)')),
922 ('x', 'z', 'x', ST_GeomFromText('POINT(192 200)')),
923 ('c', 'v', 'r', ST_GeomFromText('POINT(94 168)')),
924 ('y', 'z', 'e', ST_GeomFromText('POINT(141 51)')),
925 ('h', 'm', 'd', ST_GeomFromText('POINT(35 251)')),
926 ('v', 'm', 'q', ST_GeomFromText('POINT(44 90)')),
927 ('j', 'l', 'z', ST_GeomFromText('POINT(67 237)')),
928 ('i', 'v', 'a', ST_GeomFromText('POINT(75 14)')),
929 ('b', 'q', 't', ST_GeomFromText('POINT(153 33)')),
930 ('e', 'm', 'a', ST_GeomFromText('POINT(247 49)')),
931 ('l', 'y', 'g', ST_GeomFromText('POINT(56 203)')),
932 ('v', 'o', 'r', ST_GeomFromText('POINT(90 54)')),
933 ('r', 'n', 'd', ST_GeomFromText('POINT(135 83)')),
934 ('j', 't', 'u', ST_GeomFromText('POINT(174 239)')),
935 ('u', 'n', 'g', ST_GeomFromText('POINT(104 191)')),
936 ('p', 'q', 'y', ST_GeomFromText('POINT(63 171)')),
937 ('o', 'q', 'p', ST_GeomFromText('POINT(192 103)')),
938 ('f', 'x', 'e', ST_GeomFromText('POINT(244 30)')),
939 ('n', 'x', 'c', ST_GeomFromText('POINT(92 103)')),
940 ('r', 'q', 'z', ST_GeomFromText('POINT(166 20)')),
941 ('s', 'a', 'j', ST_GeomFromText('POINT(137 205)')),
942 ('z', 't', 't', ST_GeomFromText('POINT(99 134)')),
943 ('o', 'm', 'j', ST_GeomFromText('POINT(217 3)')),
944 ('n', 'h', 'j', ST_GeomFromText('POINT(211 17)')),
945 ('v', 'v', 'a', ST_GeomFromText('POINT(41 137)')),
946 ('q', 'o', 'j', ST_GeomFromText('POINT(5 92)')),
947 ('z', 'y', 'e', ST_GeomFromText('POINT(175 212)')),
948 ('j', 'z', 'h', ST_GeomFromText('POINT(224 194)')),
949 ('a', 'g', 'm', ST_GeomFromText('POINT(31 119)')),
950 ('p', 'c', 'f', ST_GeomFromText('POINT(17 221)')),
951 ('t', 'h', 'k', ST_GeomFromText('POINT(26 203)')),
952 ('u', 'w', 'p', ST_GeomFromText('POINT(47 185)')),
953 ('z', 'a', 'c', ST_GeomFromText('POINT(61 133)')),
954 ('u', 'k', 'a', ST_GeomFromText('POINT(210 115)')),
955 ('k', 'f', 'h', ST_GeomFromText('POINT(125 113)')),
956 ('t', 'v', 'y', ST_GeomFromText('POINT(12 239)')),
957 ('u', 'v', 'd', ST_GeomFromText('POINT(90 24)')),
958 ('m', 'y', 'w', ST_GeomFromText('POINT(25 243)')),
959 ('d', 'n', 'g', ST_GeomFromText('POINT(122 92)')),
960 ('z', 'm', 'f', ST_GeomFromText('POINT(235 110)')),
961 ('q', 'd', 'f', ST_GeomFromText('POINT(233 217)')),
962 ('a', 'v', 'u', ST_GeomFromText('POINT(69 59)')),
963 ('x', 'k', 'p', ST_GeomFromText('POINT(240 14)')),
964 ('i', 'v', 'r', ST_GeomFromText('POINT(154 42)')),
965 ('w', 'h', 'l', ST_GeomFromText('POINT(178 156)')),
966 ('d', 'h', 'n', ST_GeomFromText('POINT(65 157)')),
967 ('c', 'k', 'z', ST_GeomFromText('POINT(62 33)')),
968 ('e', 'l', 'w', ST_GeomFromText('POINT(162 1)')),
969 ('r', 'f', 'i', ST_GeomFromText('POINT(127 71)')),
970 ('q', 'm', 'c', ST_GeomFromText('POINT(63 118)')),
971 ('c', 'h', 'u', ST_GeomFromText('POINT(205 203)')),
972 ('d', 't', 'p', ST_GeomFromText('POINT(234 87)')),
973 ('s', 'g', 'h', ST_GeomFromText('POINT(149 34)')),
974 ('o', 'b', 'q', ST_GeomFromText('POINT(159 179)')),
975 ('k', 'u', 'f', ST_GeomFromText('POINT(202 254)')),
976 ('u', 'f', 'g', ST_GeomFromText('POINT(70 15)')),
977 ('x', 's', 'b', ST_GeomFromText('POINT(25 181)')),
978 ('s', 'c', 'g', ST_GeomFromText('POINT(252 17)')),
979 ('a', 'c', 'f', ST_GeomFromText('POINT(89 67)')),
980 ('r', 'e', 'q', ST_GeomFromText('POINT(55 54)')),
981 ('f', 'i', 'k', ST_GeomFromText('POINT(178 230)')),
982 ('p', 'e', 'l', ST_GeomFromText('POINT(198 28)')),
983 ('w', 'o', 'd', ST_GeomFromText('POINT(204 189)')),
984 ('c', 'a', 'g', ST_GeomFromText('POINT(230 178)')),
985 ('r', 'o', 'e', ST_GeomFromText('POINT(61 116)')),
986 ('w', 'a', 'a', ST_GeomFromText('POINT(178 237)')),
987 ('v', 'd', 'e', ST_GeomFromText('POINT(70 85)')),
988 ('k', 'c', 'e', ST_GeomFromText('POINT(147 118)')),
989 ('d', 'q', 't', ST_GeomFromText('POINT(218 77)')),
990 ('k', 'g', 'f', ST_GeomFromText('POINT(192 113)')),
991 ('w', 'n', 'e', ST_GeomFromText('POINT(92 124)')),
992 ('r', 'm', 'q', ST_GeomFromText('POINT(130 65)')),
993 ('o', 'r', 'r', ST_GeomFromText('POINT(174 233)')),
994 ('k', 'n', 't', ST_GeomFromText('POINT(175 147)')),
995 ('q', 'm', 'r', ST_GeomFromText('POINT(18 208)')),
996 ('l', 'd', 'i', ST_GeomFromText('POINT(13 104)')),
997 ('w', 'o', 'y', ST_GeomFromText('POINT(207 39)')),
998 ('p', 'u', 'o', ST_GeomFromText('POINT(114 31)')),
999 ('y', 'a', 'p', ST_GeomFromText('POINT(106 59)')),
1000 ('a', 'x', 'z', ST_GeomFromText('POINT(17 57)')),
1001 ('v', 'h', 'x', ST_GeomFromText('POINT(170 13)')),
1002 ('t', 's', 'u', ST_GeomFromText('POINT(84 18)')),
1003 ('z', 'z', 'f', ST_GeomFromText('POINT(250 197)')),
1004 ('l', 'z', 't', ST_GeomFromText('POINT(59 80)')),
1005 ('j', 'g', 's', ST_GeomFromText('POINT(54 26)')),
1006 ('g', 'v', 'm', ST_GeomFromText('POINT(89 98)')),
1007 ('q', 'v', 'b', ST_GeomFromText('POINT(39 240)')),
1008 ('x', 'k', 'v', ST_GeomFromText('POINT(246 207)')),
1009 ('k', 'u', 'i', ST_GeomFromText('POINT(105 111)')),
1010 ('w', 'z', 's', ST_GeomFromText('POINT(235 8)')),
1011 ('d', 'd', 'd', ST_GeomFromText('POINT(105 4)')),
1012 ('c', 'z', 'q', ST_GeomFromText('POINT(13 140)')),
1013 ('m', 'k', 'i', ST_GeomFromText('POINT(208 120)')),
1014 ('g', 'a', 'g', ST_GeomFromText('POINT(9 182)')),
1015 ('z', 'j', 'r', ST_GeomFromText('POINT(149 153)')),
1016 ('h', 'f', 'g', ST_GeomFromText('POINT(81 236)')),
1017 ('m', 'e', 'q', ST_GeomFromText('POINT(209 215)')),
1018 ('c', 'h', 'y', ST_GeomFromText('POINT(235 70)')),
1019 ('i', 'e', 'g', ST_GeomFromText('POINT(138 26)')),
1020 ('m', 't', 'u', ST_GeomFromText('POINT(119 237)')),
1021 ('o', 'w', 's', ST_GeomFromText('POINT(193 166)')),
1022 ('f', 'm', 'q', ST_GeomFromText('POINT(85 96)')),
1023 ('x', 'l', 'x', ST_GeomFromText('POINT(58 115)')),
1024 ('x', 'q', 'u', ST_GeomFromText('POINT(108 210)')),
1025 ('b', 'h', 'i', ST_GeomFromText('POINT(250 139)')),
1026 ('y', 'd', 'x', ST_GeomFromText('POINT(199 135)')),
1027 ('w', 'h', 'p', ST_GeomFromText('POINT(247 233)')),
1028 ('p', 'z', 't', ST_GeomFromText('POINT(148 249)')),
1029 ('q', 'a', 'u', ST_GeomFromText('POINT(174 78)')),
1030 ('v', 't', 'm', ST_GeomFromText('POINT(70 228)')),
1031 ('t', 'n', 'f', ST_GeomFromText('POINT(123 2)')),
1032 ('x', 't', 'b', ST_GeomFromText('POINT(35 50)')),
1033 ('r', 'j', 'f', ST_GeomFromText('POINT(200 51)')),
1034 ('s', 'q', 'o', ST_GeomFromText('POINT(23 184)')),
1035 ('u', 'v', 'z', ST_GeomFromText('POINT(7 113)')),
1036 ('v', 'u', 'l', ST_GeomFromText('POINT(145 190)')),
1037 ('o', 'k', 'i', ST_GeomFromText('POINT(161 122)')),
1038 ('l', 'y', 'e', ST_GeomFromText('POINT(17 232)')),
1039 ('t', 'b', 'e', ST_GeomFromText('POINT(120 50)')),
1040 ('e', 's', 'u', ST_GeomFromText('POINT(254 1)')),
1041 ('d', 'd', 'u', ST_GeomFromText('POINT(167 140)')),
1042 ('o', 'b', 'x', ST_GeomFromText('POINT(186 237)')),
1043 ('m', 's', 's', ST_GeomFromText('POINT(172 149)')),
1044 ('t', 'y', 'a', ST_GeomFromText('POINT(149 85)')),
1045 ('x', 't', 'r', ST_GeomFromText('POINT(10 165)')),
1046 ('g', 'c', 'e', ST_GeomFromText('POINT(95 165)')),
1047 ('e', 'e', 'z', ST_GeomFromText('POINT(98 65)')),
1048 ('f', 'v', 'i', ST_GeomFromText('POINT(149 144)')),
1049 ('o', 'p', 'm', ST_GeomFromText('POINT(233 67)')),
1050 ('t', 'u', 'b', ST_GeomFromText('POINT(109 215)')),
1051 ('o', 'o', 'b', ST_GeomFromText('POINT(130 48)')),
1052 ('e', 'm', 'h', ST_GeomFromText('POINT(88 189)')),
1053 ('e', 'v', 'y', ST_GeomFromText('POINT(55 29)')),
1054 ('e', 't', 'm', ST_GeomFromText('POINT(129 55)')),
1055 ('p', 'p', 'i', ST_GeomFromText('POINT(126 222)')),
1056 ('c', 'i', 'c', ST_GeomFromText('POINT(19 158)')),
1057 ('c', 'b', 's', ST_GeomFromText('POINT(13 19)')),
1058 ('u', 'y', 'a', ST_GeomFromText('POINT(114 5)')),
1059 ('a', 'o', 'f', ST_GeomFromText('POINT(227 232)')),
1060 ('t', 'c', 'z', ST_GeomFromText('POINT(63 62)')),
1061 ('d', 'o', 'k', ST_GeomFromText('POINT(48 228)')),
1062 ('x', 'c', 'e', ST_GeomFromText('POINT(204 2)')),
1063 ('e', 'e', 'g', ST_GeomFromText('POINT(125 43)')),
1064 ('o', 'r', 'f', ST_GeomFromText('POINT(171 140)'));
1065 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1066 ('b', 'c', 'e', ST_GeomFromText('POINT(41 137)')),
1067 ('p', 'y', 'k', ST_GeomFromText('POINT(50 22)')),
1068 ('s', 'c', 'h', ST_GeomFromText('POINT(208 173)')),
1069 ('x', 'u', 'l', ST_GeomFromText('POINT(199 175)')),
1070 ('s', 'r', 'h', ST_GeomFromText('POINT(85 192)')),
1071 ('j', 'k', 'u', ST_GeomFromText('POINT(18 25)')),
1072 ('p', 'w', 'h', ST_GeomFromText('POINT(152 197)')),
1073 ('e', 'd', 'c', ST_GeomFromText('POINT(229 3)')),
1074 ('o', 'x', 'k', ST_GeomFromText('POINT(187 155)')),
1075 ('o', 'b', 'k', ST_GeomFromText('POINT(208 150)')),
1076 ('d', 'a', 'j', ST_GeomFromText('POINT(70 87)')),
1077 ('f', 'e', 'k', ST_GeomFromText('POINT(156 96)')),
1078 ('u', 'y', 'p', ST_GeomFromText('POINT(239 193)')),
1079 ('n', 'v', 'p', ST_GeomFromText('POINT(223 98)')),
1080 ('z', 'j', 'r', ST_GeomFromText('POINT(87 89)')),
1081 ('h', 'x', 'x', ST_GeomFromText('POINT(92 0)')),
1082 ('r', 'v', 'r', ST_GeomFromText('POINT(159 139)')),
1083 ('v', 'g', 'g', ST_GeomFromText('POINT(16 229)')),
1084 ('z', 'k', 'u', ST_GeomFromText('POINT(99 52)')),
1085 ('p', 'p', 'o', ST_GeomFromText('POINT(105 125)')),
1086 ('w', 'h', 'y', ST_GeomFromText('POINT(105 154)')),
1087 ('v', 'y', 'z', ST_GeomFromText('POINT(134 238)')),
1088 ('x', 'o', 'o', ST_GeomFromText('POINT(178 88)')),
1089 ('z', 'w', 'd', ST_GeomFromText('POINT(123 60)')),
1090 ('q', 'f', 'u', ST_GeomFromText('POINT(64 90)')),
1091 ('s', 'n', 't', ST_GeomFromText('POINT(50 138)')),
1092 ('v', 'p', 't', ST_GeomFromText('POINT(114 91)')),
1093 ('a', 'o', 'n', ST_GeomFromText('POINT(78 43)')),
1094 ('k', 'u', 'd', ST_GeomFromText('POINT(185 161)')),
1095 ('w', 'd', 'n', ST_GeomFromText('POINT(25 92)')),
1096 ('k', 'w', 'a', ST_GeomFromText('POINT(59 238)')),
1097 ('t', 'c', 'f', ST_GeomFromText('POINT(65 87)')),
1098 ('g', 's', 'p', ST_GeomFromText('POINT(238 126)')),
1099 ('d', 'n', 'y', ST_GeomFromText('POINT(107 173)')),
1100 ('l', 'a', 'w', ST_GeomFromText('POINT(125 152)')),
1101 ('m', 'd', 'j', ST_GeomFromText('POINT(146 53)')),
1102 ('q', 'm', 'c', ST_GeomFromText('POINT(217 187)')),
1103 ('i', 'r', 'r', ST_GeomFromText('POINT(6 113)')),
1104 ('e', 'j', 'b', ST_GeomFromText('POINT(37 83)')),
1105 ('w', 'w', 'h', ST_GeomFromText('POINT(83 199)')),
1106 ('k', 'b', 's', ST_GeomFromText('POINT(170 64)')),
1107 ('s', 'b', 'c', ST_GeomFromText('POINT(163 130)')),
1108 ('c', 'h', 'a', ST_GeomFromText('POINT(141 3)')),
1109 ('k', 'j', 'u', ST_GeomFromText('POINT(143 76)')),
1110 ('r', 'h', 'o', ST_GeomFromText('POINT(243 92)')),
1111 ('i', 'd', 'b', ST_GeomFromText('POINT(205 13)')),
1112 ('r', 'y', 'q', ST_GeomFromText('POINT(138 8)')),
1113 ('m', 'o', 'i', ST_GeomFromText('POINT(36 45)')),
1114 ('v', 'g', 'm', ST_GeomFromText('POINT(0 40)')),
1115 ('f', 'e', 'i', ST_GeomFromText('POINT(76 6)')),
1116 ('c', 'q', 'q', ST_GeomFromText('POINT(115 248)')),
1117 ('x', 'c', 'i', ST_GeomFromText('POINT(29 74)')),
1118 ('l', 's', 't', ST_GeomFromText('POINT(83 18)')),
1119 ('t', 't', 'a', ST_GeomFromText('POINT(26 168)')),
1120 ('u', 'n', 'x', ST_GeomFromText('POINT(200 110)')),
1121 ('j', 'b', 'd', ST_GeomFromText('POINT(216 136)')),
1122 ('s', 'p', 'w', ST_GeomFromText('POINT(38 156)')),
1123 ('f', 'b', 'v', ST_GeomFromText('POINT(29 186)')),
1124 ('v', 'e', 'r', ST_GeomFromText('POINT(149 40)')),
1125 ('v', 't', 'm', ST_GeomFromText('POINT(184 24)')),
1126 ('y', 'g', 'a', ST_GeomFromText('POINT(219 105)')),
1127 ('s', 'f', 'i', ST_GeomFromText('POINT(114 130)')),
1128 ('e', 'q', 'h', ST_GeomFromText('POINT(203 135)')),
1129 ('h', 'g', 'b', ST_GeomFromText('POINT(9 208)')),
1130 ('o', 'l', 'r', ST_GeomFromText('POINT(245 79)')),
1131 ('s', 's', 'v', ST_GeomFromText('POINT(238 198)')),
1132 ('w', 'w', 'z', ST_GeomFromText('POINT(209 232)')),
1133 ('v', 'd', 'n', ST_GeomFromText('POINT(30 193)')),
1134 ('q', 'w', 'k', ST_GeomFromText('POINT(133 18)')),
1135 ('o', 'h', 'o', ST_GeomFromText('POINT(42 140)')),
1136 ('f', 'f', 'h', ST_GeomFromText('POINT(145 1)')),
1137 ('u', 's', 'r', ST_GeomFromText('POINT(70 62)')),
1138 ('x', 'n', 'q', ST_GeomFromText('POINT(33 86)')),
1139 ('u', 'p', 'v', ST_GeomFromText('POINT(232 220)')),
1140 ('z', 'e', 'a', ST_GeomFromText('POINT(130 69)')),
1141 ('r', 'u', 'z', ST_GeomFromText('POINT(243 241)')),
1142 ('b', 'n', 't', ST_GeomFromText('POINT(120 12)')),
1143 ('u', 'f', 's', ST_GeomFromText('POINT(190 212)')),
1144 ('a', 'd', 'q', ST_GeomFromText('POINT(235 191)')),
1145 ('f', 'q', 'm', ST_GeomFromText('POINT(176 2)')),
1146 ('n', 'c', 's', ST_GeomFromText('POINT(218 163)')),
1147 ('e', 'm', 'h', ST_GeomFromText('POINT(163 108)')),
1148 ('c', 'f', 'l', ST_GeomFromText('POINT(220 115)')),
1149 ('c', 'v', 'q', ST_GeomFromText('POINT(66 45)')),
1150 ('w', 'v', 'x', ST_GeomFromText('POINT(251 220)')),
1151 ('f', 'w', 'z', ST_GeomFromText('POINT(146 149)')),
1152 ('h', 'n', 'h', ST_GeomFromText('POINT(148 128)')),
1153 ('y', 'k', 'v', ST_GeomFromText('POINT(28 110)')),
1154 ('c', 'x', 'q', ST_GeomFromText('POINT(13 13)')),
1155 ('e', 'd', 's', ST_GeomFromText('POINT(91 190)')),
1156 ('c', 'w', 'c', ST_GeomFromText('POINT(10 231)')),
1157 ('u', 'j', 'n', ST_GeomFromText('POINT(250 21)')),
1158 ('w', 'n', 'x', ST_GeomFromText('POINT(141 69)')),
1159 ('f', 'p', 'y', ST_GeomFromText('POINT(228 246)')),
1160 ('d', 'q', 'f', ST_GeomFromText('POINT(194 22)')),
1161 ('d', 'z', 'l', ST_GeomFromText('POINT(233 181)')),
1162 ('c', 'a', 'q', ST_GeomFromText('POINT(183 96)')),
1163 ('m', 'i', 'd', ST_GeomFromText('POINT(117 226)')),
1164 ('z', 'y', 'y', ST_GeomFromText('POINT(62 81)')),
1165 ('g', 'v', 'm', ST_GeomFromText('POINT(66 158)'));
1166 START TRANSACTION;
1167 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1168 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
1169 ROLLBACK;
1170 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1171 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
1172 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(0 1280)'));
1173 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(45 1280)'));
1174 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
1175 DELETE FROM t1 WHERE id = 1280;
1176 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
1177 START TRANSACTION;
1178 DELETE FROM t1 WHERE id = 1280;
1179 ROLLBACK;
1180 START TRANSACTION;
1181 INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
1182 ('m', 'u', 'p', ST_GeomFromText('POINT(1192 1181)'));
1183 ROLLBACK;
1184 SELECT COUNT(*) FROM t1;
1185 COUNT(*)
1186 353
1187 UPDATE t1 SET spatial_point = ST_GeomFromText('POINT(123 456)') WHERE id < 2000;
1188 SET @g1 = ST_GeomFromText('Polygon((123 456, 123 678, 456 678,456 456,123 456))');
1189 DELETE FROM t1 WHERE MBRContains(@g1, t1.spatial_point);
1190 SELECT COUNT(*) FROM t1;
1191 COUNT(*)
1192 353
1193 DROP TABLE t1;
1194 SET GLOBAL innodb_file_per_table=default;
1195 SET GLOBAL innodb_file_per_table='off';
1196 CREATE TABLE t1 (
1197 id bigint(12) unsigned NOT NULL auto_increment,
1198 c2 varchar(15) collate utf8_bin DEFAULT NULL,
1199 c1 varchar(15) collate utf8_bin DEFAULT NULL,
1200 c3 varchar(10) collate utf8_bin DEFAULT NULL,
1201 spatial_point point NOT NULL SRID 0,
1202 PRIMARY KEY(id),
1203 SPATIAL KEY (spatial_point)
1204 ) ROW_FORMAT=COMPACT ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1205 Warnings:
1206 Warning 1681 Integer display width is deprecated and will be removed in a future release.
1207 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1208 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1209 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1210 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1211 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1212 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1213 ('y', 's', 'j', ST_GeomFromText('POINT(167 74)')),
1214 ('r', 'n', 'd', ST_GeomFromText('POINT(215 118)')),
1215 ('g', 'n', 'e', ST_GeomFromText('POINT(203 98)')),
1216 ('h', 'd', 'd', ST_GeomFromText('POINT(54 193)')),
1217 ('r', 'x', 'y', ST_GeomFromText('POINT(47 69)')),
1218 ('t', 'q', 'r', ST_GeomFromText('POINT(109 42)')),
1219 ('a', 'z', 'd', ST_GeomFromText('POINT(0 154)')),
1220 ('x', 'v', 'o', ST_GeomFromText('POINT(174 131)')),
1221 ('b', 'r', 'a', ST_GeomFromText('POINT(114 253)')),
1222 ('x', 'z', 'i', ST_GeomFromText('POINT(163 21)')),
1223 ('w', 'p', 'i', ST_GeomFromText('POINT(42 102)')),
1224 ('g', 'j', 'j', ST_GeomFromText('POINT(170 133)')),
1225 ('m', 'g', 'n', ST_GeomFromText('POINT(28 22)')),
1226 ('b', 'z', 'h', ST_GeomFromText('POINT(174 28)')),
1227 ('q', 'k', 'f', ST_GeomFromText('POINT(233 73)')),
1228 ('w', 'w', 'a', ST_GeomFromText('POINT(124 200)')),
1229 ('t', 'j', 'w', ST_GeomFromText('POINT(252 101)')),
1230 ('d', 'r', 'd', ST_GeomFromText('POINT(98 18)')),
1231 ('w', 'o', 'y', ST_GeomFromText('POINT(165 31)')),
1232 ('y', 'h', 't', ST_GeomFromText('POINT(14 220)')),
1233 ('d', 'p', 'u', ST_GeomFromText('POINT(223 196)')),
1234 ('g', 'y', 'g', ST_GeomFromText('POINT(207 96)')),
1235 ('x', 'm', 'n', ST_GeomFromText('POINT(214 3)')),
1236 ('g', 'v', 'e', ST_GeomFromText('POINT(140 205)')),
1237 ('g', 'm', 'm', ST_GeomFromText('POINT(10 236)')),
1238 ('i', 'r', 'j', ST_GeomFromText('POINT(137 228)')),
1239 ('w', 's', 'p', ST_GeomFromText('POINT(115 6)')),
1240 ('o', 'n', 'k', ST_GeomFromText('POINT(158 129)')),
1241 ('j', 'h', 'l', ST_GeomFromText('POINT(129 72)')),
1242 ('f', 'x', 'l', ST_GeomFromText('POINT(139 207)')),
1243 ('u', 'd', 'n', ST_GeomFromText('POINT(125 109)')),
1244 ('b', 'a', 'z', ST_GeomFromText('POINT(30 32)')),
1245 ('m', 'h', 'o', ST_GeomFromText('POINT(251 251)')),
1246 ('f', 'r', 'd', ST_GeomFromText('POINT(243 211)')),
1247 ('b', 'd', 'r', ST_GeomFromText('POINT(232 80)')),
1248 ('g', 'k', 'v', ST_GeomFromText('POINT(15 100)')),
1249 ('i', 'f', 'c', ST_GeomFromText('POINT(109 66)')),
1250 ('r', 't', 'j', ST_GeomFromText('POINT(178 6)')),
1251 ('y', 'n', 'f', ST_GeomFromText('POINT(233 211)')),
1252 ('f', 'y', 'm', ST_GeomFromText('POINT(99 16)')),
1253 ('z', 'q', 'l', ST_GeomFromText('POINT(39 49)')),
1254 ('j', 'c', 'r', ST_GeomFromText('POINT(75 187)')),
1255 ('c', 'y', 'y', ST_GeomFromText('POINT(246 253)')),
1256 ('w', 'u', 'd', ST_GeomFromText('POINT(56 190)')),
1257 ('n', 'q', 'm', ST_GeomFromText('POINT(73 149)')),
1258 ('d', 'y', 'a', ST_GeomFromText('POINT(134 6)')),
1259 ('z', 's', 'w', ST_GeomFromText('POINT(216 225)')),
1260 ('d', 'u', 'k', ST_GeomFromText('POINT(132 70)')),
1261 ('f', 'v', 't', ST_GeomFromText('POINT(187 141)')),
1262 ('r', 'r', 'a', ST_GeomFromText('POINT(152 39)')),
1263 ('y', 'p', 'o', ST_GeomFromText('POINT(45 27)')),
1264 ('p', 'n', 'm', ST_GeomFromText('POINT(228 148)')),
1265 ('e', 'g', 'e', ST_GeomFromText('POINT(88 81)')),
1266 ('m', 'a', 'h', ST_GeomFromText('POINT(35 29)')),
1267 ('m', 'h', 'f', ST_GeomFromText('POINT(30 71)')),
1268 ('h', 'k', 'i', ST_GeomFromText('POINT(244 78)')),
1269 ('z', 'v', 'd', ST_GeomFromText('POINT(241 38)')),
1270 ('q', 'l', 'j', ST_GeomFromText('POINT(13 71)')),
1271 ('s', 'p', 'g', ST_GeomFromText('POINT(108 38)')),
1272 ('q', 's', 'j', ST_GeomFromText('POINT(92 101)')),
1273 ('l', 'h', 'g', ST_GeomFromText('POINT(120 78)')),
1274 ('w', 't', 'b', ST_GeomFromText('POINT(193 109)')),
1275 ('b', 's', 's', ST_GeomFromText('POINT(223 211)')),
1276 ('w', 'w', 'y', ST_GeomFromText('POINT(122 42)')),
1277 ('q', 'c', 'c', ST_GeomFromText('POINT(104 102)')),
1278 ('w', 'g', 'n', ST_GeomFromText('POINT(213 120)')),
1279 ('p', 'q', 'a', ST_GeomFromText('POINT(247 148)')),
1280 ('c', 'z', 'e', ST_GeomFromText('POINT(18 106)')),
1281 ('z', 'u', 'n', ST_GeomFromText('POINT(70 133)')),
1282 ('j', 'n', 'x', ST_GeomFromText('POINT(232 13)')),
1283 ('e', 'h', 'f', ST_GeomFromText('POINT(22 135)')),
1284 ('w', 'l', 'f', ST_GeomFromText('POINT(9 180)')),
1285 ('a', 'v', 'q', ST_GeomFromText('POINT(163 228)')),
1286 ('i', 'z', 'o', ST_GeomFromText('POINT(180 100)')),
1287 ('e', 'c', 'l', ST_GeomFromText('POINT(182 231)')),
1288 ('c', 'k', 'o', ST_GeomFromText('POINT(19 60)')),
1289 ('q', 'f', 'p', ST_GeomFromText('POINT(79 95)')),
1290 ('m', 'd', 'r', ST_GeomFromText('POINT(3 127)')),
1291 ('m', 'e', 't', ST_GeomFromText('POINT(136 154)')),
1292 ('w', 'w', 'w', ST_GeomFromText('POINT(102 15)')),
1293 ('l', 'n', 'q', ST_GeomFromText('POINT(71 196)')),
1294 ('p', 'k', 'c', ST_GeomFromText('POINT(47 139)')),
1295 ('j', 'o', 'r', ST_GeomFromText('POINT(177 128)')),
1296 ('j', 'q', 'a', ST_GeomFromText('POINT(170 6)')),
1297 ('b', 'a', 'o', ST_GeomFromText('POINT(63 211)')),
1298 ('g', 's', 'o', ST_GeomFromText('POINT(144 251)')),
1299 ('w', 'u', 'w', ST_GeomFromText('POINT(221 214)')),
1300 ('g', 'a', 'm', ST_GeomFromText('POINT(14 102)')),
1301 ('u', 'q', 'z', ST_GeomFromText('POINT(86 200)')),
1302 ('k', 'a', 'm', ST_GeomFromText('POINT(144 222)')),
1303 ('j', 'u', 'r', ST_GeomFromText('POINT(216 142)')),
1304 ('q', 'k', 'v', ST_GeomFromText('POINT(121 236)')),
1305 ('p', 'o', 'r', ST_GeomFromText('POINT(108 102)')),
1306 ('b', 'd', 'x', ST_GeomFromText('POINT(127 198)')),
1307 ('k', 's', 'a', ST_GeomFromText('POINT(2 150)')),
1308 ('f', 'm', 'f', ST_GeomFromText('POINT(160 191)')),
1309 ('q', 'y', 'x', ST_GeomFromText('POINT(98 111)')),
1310 ('o', 'f', 'm', ST_GeomFromText('POINT(232 218)')),
1311 ('c', 'w', 'j', ST_GeomFromText('POINT(156 165)')),
1312 ('s', 'q', 'v', ST_GeomFromText('POINT(98 161)'));
1313 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1314 ('f', 'y', 'p', ST_GeomFromText('POINT(109 235)')),
1315 ('b', 'e', 'v', ST_GeomFromText('POINT(20 48)')),
1316 ('i', 'u', 'f', ST_GeomFromText('POINT(15 55)')),
1317 ('o', 'r', 'z', ST_GeomFromText('POINT(105 64)')),
1318 ('a', 'p', 'a', ST_GeomFromText('POINT(142 236)')),
1319 ('g', 'i', 'k', ST_GeomFromText('POINT(10 49)')),
1320 ('x', 'z', 'x', ST_GeomFromText('POINT(192 200)')),
1321 ('c', 'v', 'r', ST_GeomFromText('POINT(94 168)')),
1322 ('y', 'z', 'e', ST_GeomFromText('POINT(141 51)')),
1323 ('h', 'm', 'd', ST_GeomFromText('POINT(35 251)')),
1324 ('v', 'm', 'q', ST_GeomFromText('POINT(44 90)')),
1325 ('j', 'l', 'z', ST_GeomFromText('POINT(67 237)')),
1326 ('i', 'v', 'a', ST_GeomFromText('POINT(75 14)')),
1327 ('b', 'q', 't', ST_GeomFromText('POINT(153 33)')),
1328 ('e', 'm', 'a', ST_GeomFromText('POINT(247 49)')),
1329 ('l', 'y', 'g', ST_GeomFromText('POINT(56 203)')),
1330 ('v', 'o', 'r', ST_GeomFromText('POINT(90 54)')),
1331 ('r', 'n', 'd', ST_GeomFromText('POINT(135 83)')),
1332 ('j', 't', 'u', ST_GeomFromText('POINT(174 239)')),
1333 ('u', 'n', 'g', ST_GeomFromText('POINT(104 191)')),
1334 ('p', 'q', 'y', ST_GeomFromText('POINT(63 171)')),
1335 ('o', 'q', 'p', ST_GeomFromText('POINT(192 103)')),
1336 ('f', 'x', 'e', ST_GeomFromText('POINT(244 30)')),
1337 ('n', 'x', 'c', ST_GeomFromText('POINT(92 103)')),
1338 ('r', 'q', 'z', ST_GeomFromText('POINT(166 20)')),
1339 ('s', 'a', 'j', ST_GeomFromText('POINT(137 205)')),
1340 ('z', 't', 't', ST_GeomFromText('POINT(99 134)')),
1341 ('o', 'm', 'j', ST_GeomFromText('POINT(217 3)')),
1342 ('n', 'h', 'j', ST_GeomFromText('POINT(211 17)')),
1343 ('v', 'v', 'a', ST_GeomFromText('POINT(41 137)')),
1344 ('q', 'o', 'j', ST_GeomFromText('POINT(5 92)')),
1345 ('z', 'y', 'e', ST_GeomFromText('POINT(175 212)')),
1346 ('j', 'z', 'h', ST_GeomFromText('POINT(224 194)')),
1347 ('a', 'g', 'm', ST_GeomFromText('POINT(31 119)')),
1348 ('p', 'c', 'f', ST_GeomFromText('POINT(17 221)')),
1349 ('t', 'h', 'k', ST_GeomFromText('POINT(26 203)')),
1350 ('u', 'w', 'p', ST_GeomFromText('POINT(47 185)')),
1351 ('z', 'a', 'c', ST_GeomFromText('POINT(61 133)')),
1352 ('u', 'k', 'a', ST_GeomFromText('POINT(210 115)')),
1353 ('k', 'f', 'h', ST_GeomFromText('POINT(125 113)')),
1354 ('t', 'v', 'y', ST_GeomFromText('POINT(12 239)')),
1355 ('u', 'v', 'd', ST_GeomFromText('POINT(90 24)')),
1356 ('m', 'y', 'w', ST_GeomFromText('POINT(25 243)')),
1357 ('d', 'n', 'g', ST_GeomFromText('POINT(122 92)')),
1358 ('z', 'm', 'f', ST_GeomFromText('POINT(235 110)')),
1359 ('q', 'd', 'f', ST_GeomFromText('POINT(233 217)')),
1360 ('a', 'v', 'u', ST_GeomFromText('POINT(69 59)')),
1361 ('x', 'k', 'p', ST_GeomFromText('POINT(240 14)')),
1362 ('i', 'v', 'r', ST_GeomFromText('POINT(154 42)')),
1363 ('w', 'h', 'l', ST_GeomFromText('POINT(178 156)')),
1364 ('d', 'h', 'n', ST_GeomFromText('POINT(65 157)')),
1365 ('c', 'k', 'z', ST_GeomFromText('POINT(62 33)')),
1366 ('e', 'l', 'w', ST_GeomFromText('POINT(162 1)')),
1367 ('r', 'f', 'i', ST_GeomFromText('POINT(127 71)')),
1368 ('q', 'm', 'c', ST_GeomFromText('POINT(63 118)')),
1369 ('c', 'h', 'u', ST_GeomFromText('POINT(205 203)')),
1370 ('d', 't', 'p', ST_GeomFromText('POINT(234 87)')),
1371 ('s', 'g', 'h', ST_GeomFromText('POINT(149 34)')),
1372 ('o', 'b', 'q', ST_GeomFromText('POINT(159 179)')),
1373 ('k', 'u', 'f', ST_GeomFromText('POINT(202 254)')),
1374 ('u', 'f', 'g', ST_GeomFromText('POINT(70 15)')),
1375 ('x', 's', 'b', ST_GeomFromText('POINT(25 181)')),
1376 ('s', 'c', 'g', ST_GeomFromText('POINT(252 17)')),
1377 ('a', 'c', 'f', ST_GeomFromText('POINT(89 67)')),
1378 ('r', 'e', 'q', ST_GeomFromText('POINT(55 54)')),
1379 ('f', 'i', 'k', ST_GeomFromText('POINT(178 230)')),
1380 ('p', 'e', 'l', ST_GeomFromText('POINT(198 28)')),
1381 ('w', 'o', 'd', ST_GeomFromText('POINT(204 189)')),
1382 ('c', 'a', 'g', ST_GeomFromText('POINT(230 178)')),
1383 ('r', 'o', 'e', ST_GeomFromText('POINT(61 116)')),
1384 ('w', 'a', 'a', ST_GeomFromText('POINT(178 237)')),
1385 ('v', 'd', 'e', ST_GeomFromText('POINT(70 85)')),
1386 ('k', 'c', 'e', ST_GeomFromText('POINT(147 118)')),
1387 ('d', 'q', 't', ST_GeomFromText('POINT(218 77)')),
1388 ('k', 'g', 'f', ST_GeomFromText('POINT(192 113)')),
1389 ('w', 'n', 'e', ST_GeomFromText('POINT(92 124)')),
1390 ('r', 'm', 'q', ST_GeomFromText('POINT(130 65)')),
1391 ('o', 'r', 'r', ST_GeomFromText('POINT(174 233)')),
1392 ('k', 'n', 't', ST_GeomFromText('POINT(175 147)')),
1393 ('q', 'm', 'r', ST_GeomFromText('POINT(18 208)')),
1394 ('l', 'd', 'i', ST_GeomFromText('POINT(13 104)')),
1395 ('w', 'o', 'y', ST_GeomFromText('POINT(207 39)')),
1396 ('p', 'u', 'o', ST_GeomFromText('POINT(114 31)')),
1397 ('y', 'a', 'p', ST_GeomFromText('POINT(106 59)')),
1398 ('a', 'x', 'z', ST_GeomFromText('POINT(17 57)')),
1399 ('v', 'h', 'x', ST_GeomFromText('POINT(170 13)')),
1400 ('t', 's', 'u', ST_GeomFromText('POINT(84 18)')),
1401 ('z', 'z', 'f', ST_GeomFromText('POINT(250 197)')),
1402 ('l', 'z', 't', ST_GeomFromText('POINT(59 80)')),
1403 ('j', 'g', 's', ST_GeomFromText('POINT(54 26)')),
1404 ('g', 'v', 'm', ST_GeomFromText('POINT(89 98)')),
1405 ('q', 'v', 'b', ST_GeomFromText('POINT(39 240)')),
1406 ('x', 'k', 'v', ST_GeomFromText('POINT(246 207)')),
1407 ('k', 'u', 'i', ST_GeomFromText('POINT(105 111)')),
1408 ('w', 'z', 's', ST_GeomFromText('POINT(235 8)')),
1409 ('d', 'd', 'd', ST_GeomFromText('POINT(105 4)')),
1410 ('c', 'z', 'q', ST_GeomFromText('POINT(13 140)')),
1411 ('m', 'k', 'i', ST_GeomFromText('POINT(208 120)')),
1412 ('g', 'a', 'g', ST_GeomFromText('POINT(9 182)')),
1413 ('z', 'j', 'r', ST_GeomFromText('POINT(149 153)')),
1414 ('h', 'f', 'g', ST_GeomFromText('POINT(81 236)')),
1415 ('m', 'e', 'q', ST_GeomFromText('POINT(209 215)')),
1416 ('c', 'h', 'y', ST_GeomFromText('POINT(235 70)')),
1417 ('i', 'e', 'g', ST_GeomFromText('POINT(138 26)')),
1418 ('m', 't', 'u', ST_GeomFromText('POINT(119 237)')),
1419 ('o', 'w', 's', ST_GeomFromText('POINT(193 166)')),
1420 ('f', 'm', 'q', ST_GeomFromText('POINT(85 96)')),
1421 ('x', 'l', 'x', ST_GeomFromText('POINT(58 115)')),
1422 ('x', 'q', 'u', ST_GeomFromText('POINT(108 210)')),
1423 ('b', 'h', 'i', ST_GeomFromText('POINT(250 139)')),
1424 ('y', 'd', 'x', ST_GeomFromText('POINT(199 135)')),
1425 ('w', 'h', 'p', ST_GeomFromText('POINT(247 233)')),
1426 ('p', 'z', 't', ST_GeomFromText('POINT(148 249)')),
1427 ('q', 'a', 'u', ST_GeomFromText('POINT(174 78)')),
1428 ('v', 't', 'm', ST_GeomFromText('POINT(70 228)')),
1429 ('t', 'n', 'f', ST_GeomFromText('POINT(123 2)')),
1430 ('x', 't', 'b', ST_GeomFromText('POINT(35 50)')),
1431 ('r', 'j', 'f', ST_GeomFromText('POINT(200 51)')),
1432 ('s', 'q', 'o', ST_GeomFromText('POINT(23 184)')),
1433 ('u', 'v', 'z', ST_GeomFromText('POINT(7 113)')),
1434 ('v', 'u', 'l', ST_GeomFromText('POINT(145 190)')),
1435 ('o', 'k', 'i', ST_GeomFromText('POINT(161 122)')),
1436 ('l', 'y', 'e', ST_GeomFromText('POINT(17 232)')),
1437 ('t', 'b', 'e', ST_GeomFromText('POINT(120 50)')),
1438 ('e', 's', 'u', ST_GeomFromText('POINT(254 1)')),
1439 ('d', 'd', 'u', ST_GeomFromText('POINT(167 140)')),
1440 ('o', 'b', 'x', ST_GeomFromText('POINT(186 237)')),
1441 ('m', 's', 's', ST_GeomFromText('POINT(172 149)')),
1442 ('t', 'y', 'a', ST_GeomFromText('POINT(149 85)')),
1443 ('x', 't', 'r', ST_GeomFromText('POINT(10 165)')),
1444 ('g', 'c', 'e', ST_GeomFromText('POINT(95 165)')),
1445 ('e', 'e', 'z', ST_GeomFromText('POINT(98 65)')),
1446 ('f', 'v', 'i', ST_GeomFromText('POINT(149 144)')),
1447 ('o', 'p', 'm', ST_GeomFromText('POINT(233 67)')),
1448 ('t', 'u', 'b', ST_GeomFromText('POINT(109 215)')),
1449 ('o', 'o', 'b', ST_GeomFromText('POINT(130 48)')),
1450 ('e', 'm', 'h', ST_GeomFromText('POINT(88 189)')),
1451 ('e', 'v', 'y', ST_GeomFromText('POINT(55 29)')),
1452 ('e', 't', 'm', ST_GeomFromText('POINT(129 55)')),
1453 ('p', 'p', 'i', ST_GeomFromText('POINT(126 222)')),
1454 ('c', 'i', 'c', ST_GeomFromText('POINT(19 158)')),
1455 ('c', 'b', 's', ST_GeomFromText('POINT(13 19)')),
1456 ('u', 'y', 'a', ST_GeomFromText('POINT(114 5)')),
1457 ('a', 'o', 'f', ST_GeomFromText('POINT(227 232)')),
1458 ('t', 'c', 'z', ST_GeomFromText('POINT(63 62)')),
1459 ('d', 'o', 'k', ST_GeomFromText('POINT(48 228)')),
1460 ('x', 'c', 'e', ST_GeomFromText('POINT(204 2)')),
1461 ('e', 'e', 'g', ST_GeomFromText('POINT(125 43)')),
1462 ('o', 'r', 'f', ST_GeomFromText('POINT(171 140)'));
1463 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1464 ('b', 'c', 'e', ST_GeomFromText('POINT(41 137)')),
1465 ('p', 'y', 'k', ST_GeomFromText('POINT(50 22)')),
1466 ('s', 'c', 'h', ST_GeomFromText('POINT(208 173)')),
1467 ('x', 'u', 'l', ST_GeomFromText('POINT(199 175)')),
1468 ('s', 'r', 'h', ST_GeomFromText('POINT(85 192)')),
1469 ('j', 'k', 'u', ST_GeomFromText('POINT(18 25)')),
1470 ('p', 'w', 'h', ST_GeomFromText('POINT(152 197)')),
1471 ('e', 'd', 'c', ST_GeomFromText('POINT(229 3)')),
1472 ('o', 'x', 'k', ST_GeomFromText('POINT(187 155)')),
1473 ('o', 'b', 'k', ST_GeomFromText('POINT(208 150)')),
1474 ('d', 'a', 'j', ST_GeomFromText('POINT(70 87)')),
1475 ('f', 'e', 'k', ST_GeomFromText('POINT(156 96)')),
1476 ('u', 'y', 'p', ST_GeomFromText('POINT(239 193)')),
1477 ('n', 'v', 'p', ST_GeomFromText('POINT(223 98)')),
1478 ('z', 'j', 'r', ST_GeomFromText('POINT(87 89)')),
1479 ('h', 'x', 'x', ST_GeomFromText('POINT(92 0)')),
1480 ('r', 'v', 'r', ST_GeomFromText('POINT(159 139)')),
1481 ('v', 'g', 'g', ST_GeomFromText('POINT(16 229)')),
1482 ('z', 'k', 'u', ST_GeomFromText('POINT(99 52)')),
1483 ('p', 'p', 'o', ST_GeomFromText('POINT(105 125)')),
1484 ('w', 'h', 'y', ST_GeomFromText('POINT(105 154)')),
1485 ('v', 'y', 'z', ST_GeomFromText('POINT(134 238)')),
1486 ('x', 'o', 'o', ST_GeomFromText('POINT(178 88)')),
1487 ('z', 'w', 'd', ST_GeomFromText('POINT(123 60)')),
1488 ('q', 'f', 'u', ST_GeomFromText('POINT(64 90)')),
1489 ('s', 'n', 't', ST_GeomFromText('POINT(50 138)')),
1490 ('v', 'p', 't', ST_GeomFromText('POINT(114 91)')),
1491 ('a', 'o', 'n', ST_GeomFromText('POINT(78 43)')),
1492 ('k', 'u', 'd', ST_GeomFromText('POINT(185 161)')),
1493 ('w', 'd', 'n', ST_GeomFromText('POINT(25 92)')),
1494 ('k', 'w', 'a', ST_GeomFromText('POINT(59 238)')),
1495 ('t', 'c', 'f', ST_GeomFromText('POINT(65 87)')),
1496 ('g', 's', 'p', ST_GeomFromText('POINT(238 126)')),
1497 ('d', 'n', 'y', ST_GeomFromText('POINT(107 173)')),
1498 ('l', 'a', 'w', ST_GeomFromText('POINT(125 152)')),
1499 ('m', 'd', 'j', ST_GeomFromText('POINT(146 53)')),
1500 ('q', 'm', 'c', ST_GeomFromText('POINT(217 187)')),
1501 ('i', 'r', 'r', ST_GeomFromText('POINT(6 113)')),
1502 ('e', 'j', 'b', ST_GeomFromText('POINT(37 83)')),
1503 ('w', 'w', 'h', ST_GeomFromText('POINT(83 199)')),
1504 ('k', 'b', 's', ST_GeomFromText('POINT(170 64)')),
1505 ('s', 'b', 'c', ST_GeomFromText('POINT(163 130)')),
1506 ('c', 'h', 'a', ST_GeomFromText('POINT(141 3)')),
1507 ('k', 'j', 'u', ST_GeomFromText('POINT(143 76)')),
1508 ('r', 'h', 'o', ST_GeomFromText('POINT(243 92)')),
1509 ('i', 'd', 'b', ST_GeomFromText('POINT(205 13)')),
1510 ('r', 'y', 'q', ST_GeomFromText('POINT(138 8)')),
1511 ('m', 'o', 'i', ST_GeomFromText('POINT(36 45)')),
1512 ('v', 'g', 'm', ST_GeomFromText('POINT(0 40)')),
1513 ('f', 'e', 'i', ST_GeomFromText('POINT(76 6)')),
1514 ('c', 'q', 'q', ST_GeomFromText('POINT(115 248)')),
1515 ('x', 'c', 'i', ST_GeomFromText('POINT(29 74)')),
1516 ('l', 's', 't', ST_GeomFromText('POINT(83 18)')),
1517 ('t', 't', 'a', ST_GeomFromText('POINT(26 168)')),
1518 ('u', 'n', 'x', ST_GeomFromText('POINT(200 110)')),
1519 ('j', 'b', 'd', ST_GeomFromText('POINT(216 136)')),
1520 ('s', 'p', 'w', ST_GeomFromText('POINT(38 156)')),
1521 ('f', 'b', 'v', ST_GeomFromText('POINT(29 186)')),
1522 ('v', 'e', 'r', ST_GeomFromText('POINT(149 40)')),
1523 ('v', 't', 'm', ST_GeomFromText('POINT(184 24)')),
1524 ('y', 'g', 'a', ST_GeomFromText('POINT(219 105)')),
1525 ('s', 'f', 'i', ST_GeomFromText('POINT(114 130)')),
1526 ('e', 'q', 'h', ST_GeomFromText('POINT(203 135)')),
1527 ('h', 'g', 'b', ST_GeomFromText('POINT(9 208)')),
1528 ('o', 'l', 'r', ST_GeomFromText('POINT(245 79)')),
1529 ('s', 's', 'v', ST_GeomFromText('POINT(238 198)')),
1530 ('w', 'w', 'z', ST_GeomFromText('POINT(209 232)')),
1531 ('v', 'd', 'n', ST_GeomFromText('POINT(30 193)')),
1532 ('q', 'w', 'k', ST_GeomFromText('POINT(133 18)')),
1533 ('o', 'h', 'o', ST_GeomFromText('POINT(42 140)')),
1534 ('f', 'f', 'h', ST_GeomFromText('POINT(145 1)')),
1535 ('u', 's', 'r', ST_GeomFromText('POINT(70 62)')),
1536 ('x', 'n', 'q', ST_GeomFromText('POINT(33 86)')),
1537 ('u', 'p', 'v', ST_GeomFromText('POINT(232 220)')),
1538 ('z', 'e', 'a', ST_GeomFromText('POINT(130 69)')),
1539 ('r', 'u', 'z', ST_GeomFromText('POINT(243 241)')),
1540 ('b', 'n', 't', ST_GeomFromText('POINT(120 12)')),
1541 ('u', 'f', 's', ST_GeomFromText('POINT(190 212)')),
1542 ('a', 'd', 'q', ST_GeomFromText('POINT(235 191)')),
1543 ('f', 'q', 'm', ST_GeomFromText('POINT(176 2)')),
1544 ('n', 'c', 's', ST_GeomFromText('POINT(218 163)')),
1545 ('e', 'm', 'h', ST_GeomFromText('POINT(163 108)')),
1546 ('c', 'f', 'l', ST_GeomFromText('POINT(220 115)')),
1547 ('c', 'v', 'q', ST_GeomFromText('POINT(66 45)')),
1548 ('w', 'v', 'x', ST_GeomFromText('POINT(251 220)')),
1549 ('f', 'w', 'z', ST_GeomFromText('POINT(146 149)')),
1550 ('h', 'n', 'h', ST_GeomFromText('POINT(148 128)')),
1551 ('y', 'k', 'v', ST_GeomFromText('POINT(28 110)')),
1552 ('c', 'x', 'q', ST_GeomFromText('POINT(13 13)')),
1553 ('e', 'd', 's', ST_GeomFromText('POINT(91 190)')),
1554 ('c', 'w', 'c', ST_GeomFromText('POINT(10 231)')),
1555 ('u', 'j', 'n', ST_GeomFromText('POINT(250 21)')),
1556 ('w', 'n', 'x', ST_GeomFromText('POINT(141 69)')),
1557 ('f', 'p', 'y', ST_GeomFromText('POINT(228 246)')),
1558 ('d', 'q', 'f', ST_GeomFromText('POINT(194 22)')),
1559 ('d', 'z', 'l', ST_GeomFromText('POINT(233 181)')),
1560 ('c', 'a', 'q', ST_GeomFromText('POINT(183 96)')),
1561 ('m', 'i', 'd', ST_GeomFromText('POINT(117 226)')),
1562 ('z', 'y', 'y', ST_GeomFromText('POINT(62 81)')),
1563 ('g', 'v', 'm', ST_GeomFromText('POINT(66 158)'));
1564 START TRANSACTION;
1565 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1566 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
1567 ROLLBACK;
1568 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES
1569 ('f', 'x', 'p', ST_GeomFromText('POINT(92 181)'));
1570 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(0 1280)'));
1571 INSERT INTO t1 (c2, c1, c3, spatial_poINT) VALUES ('n', 'x', 'p', ST_GeomFromText('POINT(45 1280)'));
1572 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
1573 DELETE FROM t1 WHERE id = 1280;
1574 INSERT INTO t1 VALUES (1280, 'n', 'x', 'p', ST_GeomFromText('POINT(44 253)'));
1575 START TRANSACTION;
1576 DELETE FROM t1 WHERE id = 1280;
1577 ROLLBACK;
1578 START TRANSACTION;
1579 INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
1580 ('m', 'u', 'p', ST_GeomFromText('POINT(1192 1181)'));
1581 ROLLBACK;
1582 SELECT COUNT(*) FROM t1;
1583 COUNT(*)
1584 353
1585 UPDATE t1 SET spatial_point = ST_GeomFromText('POINT(123 456)') WHERE id < 2000;
1586 SET @g1 = ST_GeomFromText('Polygon((123 456, 123 678, 456 678,456 456,123 456))');
1587 DELETE FROM t1 WHERE MBRContains(@g1, t1.spatial_point);
1588 SELECT COUNT(*) FROM t1;
1589 COUNT(*)
1590 353
1591 DROP TABLE t1;
1592 SET GLOBAL innodb_file_per_table=default;