create table t1 (g geometry not null, spatial key(g(10 ))); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(10)))' at line 1 not null, spatial key(g asc)); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'asc))' at line 1 not null, spatial key(g desc)); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc))' at line 1 not null, f geometry not null, spatial key(g,f)); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'f))' at line 1 not null, f geometry not null); 10 )); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(10))' at line 1 ; ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'asc)' at line 1 ; ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc)' at line 1 ; ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g)' at line 1 10 )); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(10))' at line 1 ; ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'asc)' at line 1 ; ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc)' at line 1 ; ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g)' at line 1 ; NOT NULL AUTO_INCREMENT PRIMARY KEY,NOT NULL,; ; 11 ) NOT NULL AUTO_INCREMENT,NOT NULL,'LineString(150 150, 150 150)' )); 'LineString(149 149, 151 151)' )); 'LineString(148 148, 152 152)' )); 'LineString(147 147, 153 153)' )); 'LineString(146 146, 154 154)' )); 'LineString(145 145, 155 155)' )); 'LineString(144 144, 156 156)' )); 'LineString(143 143, 157 157)' )); 'LineString(142 142, 158 158)' )); 'LineString(141 141, 159 159)' )); 'LineString(140 140, 160 160)' )); 'LineString(139 139, 161 161)' )); 'LineString(138 138, 162 162)' )); 'LineString(137 137, 163 163)' )); 'LineString(136 136, 164 164)' )); 'LineString(135 135, 165 165)' )); 'LineString(134 134, 166 166)' )); 'LineString(133 133, 167 167)' )); 'LineString(132 132, 168 168)' )); 'LineString(131 131, 169 169)' )); 'LineString(130 130, 170 170)' )); 'LineString(129 129, 171 171)' )); 'LineString(128 128, 172 172)' )); 'LineString(127 127, 173 173)' )); 'LineString(126 126, 174 174)' )); 'LineString(125 125, 175 175)' )); 'LineString(124 124, 176 176)' )); 'LineString(123 123, 177 177)' )); 'LineString(122 122, 178 178)' )); 'LineString(121 121, 179 179)' )); 'LineString(120 120, 180 180)' )); 'LineString(119 119, 181 181)' )); 'LineString(118 118, 182 182)' )); 'LineString(117 117, 183 183)' )); 'LineString(116 116, 184 184)' )); 'LineString(115 115, 185 185)' )); 'LineString(114 114, 186 186)' )); 'LineString(113 113, 187 187)' )); 'LineString(112 112, 188 188)' )); 'LineString(111 111, 189 189)' )); 'LineString(110 110, 190 190)' )); 'LineString(109 109, 191 191)' )); 'LineString(108 108, 192 192)' )); 'LineString(107 107, 193 193)' )); 'LineString(106 106, 194 194)' )); 'LineString(105 105, 195 195)' )); 'LineString(104 104, 196 196)' )); 'LineString(103 103, 197 197)' )); 'LineString(102 102, 198 198)' )); 'LineString(101 101, 199 199)' )); 'LineString(100 100, 200 200)' )); 'LineString(99 99, 201 201)' )); 'LineString(98 98, 202 202)' )); 'LineString(97 97, 203 203)' )); 'LineString(96 96, 204 204)' )); 'LineString(95 95, 205 205)' )); 'LineString(94 94, 206 206)' )); 'LineString(93 93, 207 207)' )); 'LineString(92 92, 208 208)' )); 'LineString(91 91, 209 209)' )); 'LineString(90 90, 210 210)' )); 'LineString(89 89, 211 211)' )); 'LineString(88 88, 212 212)' )); 'LineString(87 87, 213 213)' )); 'LineString(86 86, 214 214)' )); 'LineString(85 85, 215 215)' )); 'LineString(84 84, 216 216)' )); 'LineString(83 83, 217 217)' )); 'LineString(82 82, 218 218)' )); 'LineString(81 81, 219 219)' )); 'LineString(80 80, 220 220)' )); 'LineString(79 79, 221 221)' )); 'LineString(78 78, 222 222)' )); 'LineString(77 77, 223 223)' )); 'LineString(76 76, 224 224)' )); 'LineString(75 75, 225 225)' )); 'LineString(74 74, 226 226)' )); 'LineString(73 73, 227 227)' )); 'LineString(72 72, 228 228)' )); 'LineString(71 71, 229 229)' )); 'LineString(70 70, 230 230)' )); 'LineString(69 69, 231 231)' )); 'LineString(68 68, 232 232)' )); 'LineString(67 67, 233 233)' )); 'LineString(66 66, 234 234)' )); 'LineString(65 65, 235 235)' )); 'LineString(64 64, 236 236)' )); 'LineString(63 63, 237 237)' )); 'LineString(62 62, 238 238)' )); 'LineString(61 61, 239 239)' )); 'LineString(60 60, 240 240)' )); 'LineString(59 59, 241 241)' )); 'LineString(58 58, 242 242)' )); 'LineString(57 57, 243 243)' )); 'LineString(56 56, 244 244)' )); 'LineString(55 55, 245 245)' )); 'LineString(54 54, 246 246)' )); 'LineString(53 53, 247 247)' )); 'LineString(52 52, 248 248)' )); 'LineString(51 51, 249 249)' )); 'LineString(50 50, 250 250)' )); 'LineString(49 49, 251 251)' )); 'LineString(48 48, 252 252)' )); 'LineString(47 47, 253 253)' )); 'LineString(46 46, 254 254)' )); 'LineString(45 45, 255 255)' )); 'LineString(44 44, 256 256)' )); 'LineString(43 43, 257 257)' )); 'LineString(42 42, 258 258)' )); 'LineString(41 41, 259 259)' )); 'LineString(40 40, 260 260)' )); 'LineString(39 39, 261 261)' )); 'LineString(38 38, 262 262)' )); 'LineString(37 37, 263 263)' )); 'LineString(36 36, 264 264)' )); 'LineString(35 35, 265 265)' )); 'LineString(34 34, 266 266)' )); 'LineString(33 33, 267 267)' )); 'LineString(32 32, 268 268)' )); 'LineString(31 31, 269 269)' )); 'LineString(30 30, 270 270)' )); 'LineString(29 29, 271 271)' )); 'LineString(28 28, 272 272)' )); 'LineString(27 27, 273 273)' )); 'LineString(26 26, 274 274)' )); 'LineString(25 25, 275 275)' )); 'LineString(24 24, 276 276)' )); 'LineString(23 23, 277 277)' )); 'LineString(22 22, 278 278)' )); 'LineString(21 21, 279 279)' )); 'LineString(20 20, 280 280)' )); 'LineString(19 19, 281 281)' )); 'LineString(18 18, 282 282)' )); 'LineString(17 17, 283 283)' )); 'LineString(16 16, 284 284)' )); 'LineString(15 15, 285 285)' )); 'LineString(14 14, 286 286)' )); 'LineString(13 13, 287 287)' )); 'LineString(12 12, 288 288)' )); 'LineString(11 11, 289 289)' )); 'LineString(10 10, 290 290)' )); 'LineString(9 9, 291 291)' )); 'LineString(8 8, 292 292)' )); 'LineString(7 7, 293 293)' )); 'LineString(6 6, 294 294)' )); 'LineString(5 5, 295 295)' )); 'LineString(4 4, 296 296)' )); 'LineString(3 3, 297 297)' )); 'LineString(2 2, 298 298)' )); 'LineString(1 1, 299 299)' )); ; 150 'Polygon((140 140,160 140,160 160,140 160,140 140))' )); 1 SIMPLE t1 range g g 34 NULL 8 Using where'Polygon((140 140,160 140,160 160,140 160,140 140))' )); 1 LINESTRING(150 150 ,150 150 )3 LINESTRING(148 148 ,152 152 )4 LINESTRING(147 147 ,153 153 )5 LINESTRING(146 146 ,154 154 )6 LINESTRING(145 145 ,155 155 )7 LINESTRING(144 144 ,156 156 )8 LINESTRING(143 143 ,157 157 )9 LINESTRING(142 142 ,158 158 )10 LINESTRING(141 141 ,159 159 )11 LINESTRING(140 140 ,160 160 )2 LINESTRING(149 149 ,151 151 ); NOT NULL AUTO_INCREMENT PRIMARY KEY,NOT NULL; 10 * 10 - 9 , 10 * 10 - 9 ), Point(10 * 10 , 10 * 10 ))); 10 * 10 - 9 , 9 * 10 - 9 ), Point(10 * 10 , 9 * 10 ))); 10 * 10 - 9 , 8 * 10 - 9 ), Point(10 * 10 , 8 * 10 ))); 10 * 10 - 9 , 7 * 10 - 9 ), Point(10 * 10 , 7 * 10 ))); 10 * 10 - 9 , 6 * 10 - 9 ), Point(10 * 10 , 6 * 10 ))); 10 * 10 - 9 , 5 * 10 - 9 ), Point(10 * 10 , 5 * 10 ))); 10 * 10 - 9 , 4 * 10 - 9 ), Point(10 * 10 , 4 * 10 ))); 10 * 10 - 9 , 3 * 10 - 9 ), Point(10 * 10 , 3 * 10 ))); 10 * 10 - 9 , 2 * 10 - 9 ), Point(10 * 10 , 2 * 10 ))); 10 * 10 - 9 , 1 * 10 - 9 ), Point(10 * 10 , 1 * 10 ))); 9 * 10 - 9 , 10 * 10 - 9 ), Point(9 * 10 , 10 * 10 ))); 9 * 10 - 9 , 9 * 10 - 9 ), Point(9 * 10 , 9 * 10 ))); 9 * 10 - 9 , 8 * 10 - 9 ), Point(9 * 10 , 8 * 10 ))); 9 * 10 - 9 , 7 * 10 - 9 ), Point(9 * 10 , 7 * 10 ))); 9 * 10 - 9 , 6 * 10 - 9 ), Point(9 * 10 , 6 * 10 ))); 9 * 10 - 9 , 5 * 10 - 9 ), Point(9 * 10 , 5 * 10 ))); 9 * 10 - 9 , 4 * 10 - 9 ), Point(9 * 10 , 4 * 10 ))); 9 * 10 - 9 , 3 * 10 - 9 ), Point(9 * 10 , 3 * 10 ))); 9 * 10 - 9 , 2 * 10 - 9 ), Point(9 * 10 , 2 * 10 ))); 9 * 10 - 9 , 1 * 10 - 9 ), Point(9 * 10 , 1 * 10 ))); 8 * 10 - 9 , 10 * 10 - 9 ), Point(8 * 10 , 10 * 10 ))); 8 * 10 - 9 , 9 * 10 - 9 ), Point(8 * 10 , 9 * 10 ))); 8 * 10 - 9 , 8 * 10 - 9 ), Point(8 * 10 , 8 * 10 ))); 8 * 10 - 9 , 7 * 10 - 9 ), Point(8 * 10 , 7 * 10 ))); 8 * 10 - 9 , 6 * 10 - 9 ), Point(8 * 10 , 6 * 10 ))); 8 * 10 - 9 , 5 * 10 - 9 ), Point(8 * 10 , 5 * 10 ))); 8 * 10 - 9 , 4 * 10 - 9 ), Point(8 * 10 , 4 * 10 ))); 8 * 10 - 9 , 3 * 10 - 9 ), Point(8 * 10 , 3 * 10 ))); 8 * 10 - 9 , 2 * 10 - 9 ), Point(8 * 10 , 2 * 10 ))); 8 * 10 - 9 , 1 * 10 - 9 ), Point(8 * 10 , 1 * 10 ))); 7 * 10 - 9 , 10 * 10 - 9 ), Point(7 * 10 , 10 * 10 ))); 7 * 10 - 9 , 9 * 10 - 9 ), Point(7 * 10 , 9 * 10 ))); 7 * 10 - 9 , 8 * 10 - 9 ), Point(7 * 10 , 8 * 10 ))); 7 * 10 - 9 , 7 * 10 - 9 ), Point(7 * 10 , 7 * 10 ))); 7 * 10 - 9 , 6 * 10 - 9 ), Point(7 * 10 , 6 * 10 ))); 7 * 10 - 9 , 5 * 10 - 9 ), Point(7 * 10 , 5 * 10 ))); 7 * 10 - 9 , 4 * 10 - 9 ), Point(7 * 10 , 4 * 10 ))); 7 * 10 - 9 , 3 * 10 - 9 ), Point(7 * 10 , 3 * 10 ))); 7 * 10 - 9 , 2 * 10 - 9 ), Point(7 * 10 , 2 * 10 ))); 7 * 10 - 9 , 1 * 10 - 9 ), Point(7 * 10 , 1 * 10 ))); 6 * 10 - 9 , 10 * 10 - 9 ), Point(6 * 10 , 10 * 10 ))); 6 * 10 - 9 , 9 * 10 - 9 ), Point(6 * 10 , 9 * 10 ))); 6 * 10 - 9 , 8 * 10 - 9 ), Point(6 * 10 , 8 * 10 ))); 6 * 10 - 9 , 7 * 10 - 9 ), Point(6 * 10 , 7 * 10 ))); 6 * 10 - 9 , 6 * 10 - 9 ), Point(6 * 10 , 6 * 10 ))); 6 * 10 - 9 , 5 * 10 - 9 ), Point(6 * 10 , 5 * 10 ))); 6 * 10 - 9 , 4 * 10 - 9 ), Point(6 * 10 , 4 * 10 ))); 6 * 10 - 9 , 3 * 10 - 9 ), Point(6 * 10 , 3 * 10 ))); 6 * 10 - 9 , 2 * 10 - 9 ), Point(6 * 10 , 2 * 10 ))); 6 * 10 - 9 , 1 * 10 - 9 ), Point(6 * 10 , 1 * 10 ))); 5 * 10 - 9 , 10 * 10 - 9 ), Point(5 * 10 , 10 * 10 ))); 5 * 10 - 9 , 9 * 10 - 9 ), Point(5 * 10 , 9 * 10 ))); 5 * 10 - 9 , 8 * 10 - 9 ), Point(5 * 10 , 8 * 10 ))); 5 * 10 - 9 , 7 * 10 - 9 ), Point(5 * 10 , 7 * 10 ))); 5 * 10 - 9 , 6 * 10 - 9 ), Point(5 * 10 , 6 * 10 ))); 5 * 10 - 9 , 5 * 10 - 9 ), Point(5 * 10 , 5 * 10 ))); 5 * 10 - 9 , 4 * 10 - 9 ), Point(5 * 10 , 4 * 10 ))); 5 * 10 - 9 , 3 * 10 - 9 ), Point(5 * 10 , 3 * 10 ))); 5 * 10 - 9 , 2 * 10 - 9 ), Point(5 * 10 , 2 * 10 ))); 5 * 10 - 9 , 1 * 10 - 9 ), Point(5 * 10 , 1 * 10 ))); 4 * 10 - 9 , 10 * 10 - 9 ), Point(4 * 10 , 10 * 10 ))); 4 * 10 - 9 , 9 * 10 - 9 ), Point(4 * 10 , 9 * 10 ))); 4 * 10 - 9 , 8 * 10 - 9 ), Point(4 * 10 , 8 * 10 ))); 4 * 10 - 9 , 7 * 10 - 9 ), Point(4 * 10 , 7 * 10 ))); 4 * 10 - 9 , 6 * 10 - 9 ), Point(4 * 10 , 6 * 10 ))); 4 * 10 - 9 , 5 * 10 - 9 ), Point(4 * 10 , 5 * 10 ))); 4 * 10 - 9 , 4 * 10 - 9 ), Point(4 * 10 , 4 * 10 ))); 4 * 10 - 9 , 3 * 10 - 9 ), Point(4 * 10 , 3 * 10 ))); 4 * 10 - 9 , 2 * 10 - 9 ), Point(4 * 10 , 2 * 10 ))); 4 * 10 - 9 , 1 * 10 - 9 ), Point(4 * 10 , 1 * 10 ))); 3 * 10 - 9 , 10 * 10 - 9 ), Point(3 * 10 , 10 * 10 ))); 3 * 10 - 9 , 9 * 10 - 9 ), Point(3 * 10 , 9 * 10 ))); 3 * 10 - 9 , 8 * 10 - 9 ), Point(3 * 10 , 8 * 10 ))); 3 * 10 - 9 , 7 * 10 - 9 ), Point(3 * 10 , 7 * 10 ))); 3 * 10 - 9 , 6 * 10 - 9 ), Point(3 * 10 , 6 * 10 ))); 3 * 10 - 9 , 5 * 10 - 9 ), Point(3 * 10 , 5 * 10 ))); 3 * 10 - 9 , 4 * 10 - 9 ), Point(3 * 10 , 4 * 10 ))); 3 * 10 - 9 , 3 * 10 - 9 ), Point(3 * 10 , 3 * 10 ))); 3 * 10 - 9 , 2 * 10 - 9 ), Point(3 * 10 , 2 * 10 ))); 3 * 10 - 9 , 1 * 10 - 9 ), Point(3 * 10 , 1 * 10 ))); 2 * 10 - 9 , 10 * 10 - 9 ), Point(2 * 10 , 10 * 10 ))); 2 * 10 - 9 , 9 * 10 - 9 ), Point(2 * 10 , 9 * 10 ))); 2 * 10 - 9 , 8 * 10 - 9 ), Point(2 * 10 , 8 * 10 ))); 2 * 10 - 9 , 7 * 10 - 9 ), Point(2 * 10 , 7 * 10 ))); 2 * 10 - 9 , 6 * 10 - 9 ), Point(2 * 10 , 6 * 10 ))); 2 * 10 - 9 , 5 * 10 - 9 ), Point(2 * 10 , 5 * 10 ))); 2 * 10 - 9 , 4 * 10 - 9 ), Point(2 * 10 , 4 * 10 ))); 2 * 10 - 9 , 3 * 10 - 9 ), Point(2 * 10 , 3 * 10 ))); 2 * 10 - 9 , 2 * 10 - 9 ), Point(2 * 10 , 2 * 10 ))); 2 * 10 - 9 , 1 * 10 - 9 ), Point(2 * 10 , 1 * 10 ))); 1 * 10 - 9 , 10 * 10 - 9 ), Point(1 * 10 , 10 * 10 ))); 1 * 10 - 9 , 9 * 10 - 9 ), Point(1 * 10 , 9 * 10 ))); 1 * 10 - 9 , 8 * 10 - 9 ), Point(1 * 10 , 8 * 10 ))); 1 * 10 - 9 , 7 * 10 - 9 ), Point(1 * 10 , 7 * 10 ))); 1 * 10 - 9 , 6 * 10 - 9 ), Point(1 * 10 , 6 * 10 ))); 1 * 10 - 9 , 5 * 10 - 9 ), Point(1 * 10 , 5 * 10 ))); 1 * 10 - 9 , 4 * 10 - 9 ), Point(1 * 10 , 4 * 10 ))); 1 * 10 - 9 , 3 * 10 - 9 ), Point(1 * 10 , 3 * 10 ))); 1 * 10 - 9 , 2 * 10 - 9 ), Point(1 * 10 , 2 * 10 ))); 1 * 10 - 9 , 1 * 10 - 9 ), Point(1 * 10 , 1 * 10 ))); ; ; 11 ) NOT NULL AUTO_INCREMENT,NOT NULL,101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; 100 'Polygon((40 40,60 40,60 60,40 60,40 40))' )); 1 SIMPLE t2 range g g 34 NULL 4 Using where'Polygon((40 40,60 40,60 60,40 60,40 40))' )); 46 LINESTRING(51 41 ,60 50 )56 LINESTRING(41 41 ,50 50 )45 LINESTRING(51 51 ,60 60 )55 LINESTRING(41 51 ,50 60 )10 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 10 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 9 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 8 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 7 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 6 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 5 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 4 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 3 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 2 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 10 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 9 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 8 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 7 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 6 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 5 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 4 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 3 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 2 * 10 - 9 ), 0 ))); ; 100 1 * 10 - 9 , 1 * 10 - 9 ), 0 ))); ; 100 ; NOT NULL, SPATIAL (a)); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); "LINESTRING(100 100, 200 200, 300 300)" )); ; ; ; NOT NULL AUTO_INCREMENT PRIMARY KEY,NOT NULL,; 'LineString(1 2, 2 3)' )),(GeomFromText('LineString(1 2, 2 4)' )); ; NOT NULL,'po' , 'pp' , 'rr' , 'dr' , 'rd' , 'ts' , 'cl' ) NOT NULL DEFAULT 'po' ,32 ),; ; "Aadaouane" , "pp" , GeomFromText("POINT(32.816667 35.983333)" )),"Aadassiye" , "pp" , GeomFromText("POINT(35.816667 36.216667)" )),"Aadbel" , "pp" , GeomFromText("POINT(34.533333 36.100000)" )),"Aadchit" , "pp" , GeomFromText("POINT(33.347222 35.423611)" )),"Aadchite" , "pp" , GeomFromText("POINT(33.347222 35.423611)" )),"Aadchit el Qoussair" , "pp" , GeomFromText("POINT(33.283333 35.483333)" )),"Aaddaye" , "pp" , GeomFromText("POINT(36.716667 40.833333)" )),"'Aadeissa" , "pp" , GeomFromText("POINT(32.823889 35.698889)" )),"Aaderup" , "pp" , GeomFromText("POINT(55.216667 11.766667)" )),"Qalaat Aades" , "pp" , GeomFromText("POINT(33.503333 35.377500)" )),"A ad'ino" , "pp" , GeomFromText("POINT(54.812222 38.209167)" )),"Aadi Noia" , "pp" , GeomFromText("POINT(13.800000 39.833333)" )),"Aad La Macta" , "pp" , GeomFromText("POINT(35.779444 -0.129167)" )),"Aadland" , "pp" , GeomFromText("POINT(60.366667 5.483333)" )),"Aadliye" , "pp" , GeomFromText("POINT(33.366667 36.333333)" )),"Aadloun" , "pp" , GeomFromText("POINT(33.403889 35.273889)" )),"Aadma" , "pp" , GeomFromText("POINT(58.798333 22.663889)" )),"Aadma Asundus" , "pp" , GeomFromText("POINT(58.798333 22.663889)" )),"Aadmoun" , "pp" , GeomFromText("POINT(34.150000 35.650000)" )),"Aadneram" , "pp" , GeomFromText("POINT(59.016667 6.933333)" )),"Aadneskaar" , "pp" , GeomFromText("POINT(58.083333 6.983333)" )),"Aadorf" , "pp" , GeomFromText("POINT(47.483333 8.900000)" )),"Aadorp" , "pp" , GeomFromText("POINT(52.366667 6.633333)" )),"Aadouane" , "pp" , GeomFromText("POINT(32.816667 35.983333)" )),"Aadoui" , "pp" , GeomFromText("POINT(34.450000 35.983333)" )),"Aadouiye" , "pp" , GeomFromText("POINT(34.583333 36.183333)" )),"Aadouss" , "pp" , GeomFromText("POINT(33.512500 35.601389)" )),"Aadra" , "pp" , GeomFromText("POINT(33.616667 36.500000)" )),"Aadzi" , "pp" , GeomFromText("POINT(38.100000 64.850000)" )); ; "austria" , "pp" , GeomFromText('LINESTRING(14.9906 48.9887,14.9946 48.9904,14.9947 48.9916)' )); ; 100 )); "Fake string" ); NOT NULL, SPATIAL KEY gk(geom)); ; ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY field; NOT NULL, SPATIAL KEY `gndx` (`geometry`)) DEFAULT CHARSET=latin1; 'POLYGON((-18.6086111000 -66.9327777000, -18.6055555000 66 .8158332999 , -18 .7186111000 -66 .8102777000 , -18 .7211111000 -66 .9269443999 ,18 .6086111000 -66 .9327777000 ))')); 'POLYGON((-65.7402776999 -96.6686111000, -65.7372222000 96 .5516666000 , -65 .8502777000 -96 .5461111000 , -65 .8527777000 -96 .6627777000 ,65 .7402776999 -96 .6686111000 ))')); ; ; NOT NULL,; 'POLYGON((-18.6086111000 -66.9327777000, 18 .6055555000 -66 .8158332999 ,18 .7186111000 -66 .8102777000 ,18 .7211111000 -66 .9269443999 ,18 .6086111000 -66 .9327777000 ))')); ; ; NOT NULL,; 'POLYGON((-18.6086111000 -66.9327777000, 18 .6055555000 -66 .8158332999 ,18 .7186111000 -66 .8102777000 ,18 .7211111000 -66 .9269443999 ,18 .6086111000 -66 .9327777000 ))')); 'POLYGON((-65.7402776999 -96.6686111000, 65 .7372222000 -96 .5516666000 ,65 .8502777000 -96 .5461111000 ,65 .8527777000 -96 .6627777000 ,65 .7402776999 -96 .6686111000 ))')); 'POLYGON((-18.6086111000 -66.9327777000, 18 .6055555000 -66 .8158332999 ,18 .7186111000 -66 .8102777000 ,18 .7211111000 -66 .9269443999 ,18 .6086111000 -66 .9327777000 ))')); ; ; NOT NULL, SPATIAL INDEX(foo) ); 1 ,1 )); 1 ,0 )); 0 ,1 )); 0 ,0 )); 1 FROM t1 WHERE foo != POINT(0 ,0 ); 1 1 1 1 ; 12 ) unsigned NOT NULL auto_increment,15 ) collate utf8_bin default NULL,15 ) collate utf8_bin default NULL,10 ) collate utf8_bin default NULL,NOT NULL,; 'y' , 's' , 'j' , GeomFromText('POINT(167 74)' )),'r' , 'n' , 'd' , GeomFromText('POINT(215 118)' )),'g' , 'n' , 'e' , GeomFromText('POINT(203 98)' )),'h' , 'd' , 'd' , GeomFromText('POINT(54 193)' )),'r' , 'x' , 'y' , GeomFromText('POINT(47 69)' )),'t' , 'q' , 'r' , GeomFromText('POINT(109 42)' )),'a' , 'z' , 'd' , GeomFromText('POINT(0 154)' )),'x' , 'v' , 'o' , GeomFromText('POINT(174 131)' )),'b' , 'r' , 'a' , GeomFromText('POINT(114 253)' )),'x' , 'z' , 'i' , GeomFromText('POINT(163 21)' )),'w' , 'p' , 'i' , GeomFromText('POINT(42 102)' )),'g' , 'j' , 'j' , GeomFromText('POINT(170 133)' )),'m' , 'g' , 'n' , GeomFromText('POINT(28 22)' )),'b' , 'z' , 'h' , GeomFromText('POINT(174 28)' )),'q' , 'k' , 'f' , GeomFromText('POINT(233 73)' )),'w' , 'w' , 'a' , GeomFromText('POINT(124 200)' )),'t' , 'j' , 'w' , GeomFromText('POINT(252 101)' )),'d' , 'r' , 'd' , GeomFromText('POINT(98 18)' )),'w' , 'o' , 'y' , GeomFromText('POINT(165 31)' )),'y' , 'h' , 't' , GeomFromText('POINT(14 220)' )),'d' , 'p' , 'u' , GeomFromText('POINT(223 196)' )),'g' , 'y' , 'g' , GeomFromText('POINT(207 96)' )),'x' , 'm' , 'n' , GeomFromText('POINT(214 3)' )),'g' , 'v' , 'e' , GeomFromText('POINT(140 205)' )),'g' , 'm' , 'm' , GeomFromText('POINT(10 236)' )),'i' , 'r' , 'j' , GeomFromText('POINT(137 228)' )),'w' , 's' , 'p' , GeomFromText('POINT(115 6)' )),'o' , 'n' , 'k' , GeomFromText('POINT(158 129)' )),'j' , 'h' , 'l' , GeomFromText('POINT(129 72)' )),'f' , 'x' , 'l' , GeomFromText('POINT(139 207)' )),'u' , 'd' , 'n' , GeomFromText('POINT(125 109)' )),'b' , 'a' , 'z' , GeomFromText('POINT(30 32)' )),'m' , 'h' , 'o' , GeomFromText('POINT(251 251)' )),'f' , 'r' , 'd' , GeomFromText('POINT(243 211)' )),'b' , 'd' , 'r' , GeomFromText('POINT(232 80)' )),'g' , 'k' , 'v' , GeomFromText('POINT(15 100)' )),'i' , 'f' , 'c' , GeomFromText('POINT(109 66)' )),'r' , 't' , 'j' , GeomFromText('POINT(178 6)' )),'y' , 'n' , 'f' , GeomFromText('POINT(233 211)' )),'f' , 'y' , 'm' , GeomFromText('POINT(99 16)' )),'z' , 'q' , 'l' , GeomFromText('POINT(39 49)' )),'j' , 'c' , 'r' , GeomFromText('POINT(75 187)' )),'c' , 'y' , 'y' , GeomFromText('POINT(246 253)' )),'w' , 'u' , 'd' , GeomFromText('POINT(56 190)' )),'n' , 'q' , 'm' , GeomFromText('POINT(73 149)' )),'d' , 'y' , 'a' , GeomFromText('POINT(134 6)' )),'z' , 's' , 'w' , GeomFromText('POINT(216 225)' )),'d' , 'u' , 'k' , GeomFromText('POINT(132 70)' )),'f' , 'v' , 't' , GeomFromText('POINT(187 141)' )),'r' , 'r' , 'a' , GeomFromText('POINT(152 39)' )),'y' , 'p' , 'o' , GeomFromText('POINT(45 27)' )),'p' , 'n' , 'm' , GeomFromText('POINT(228 148)' )),'e' , 'g' , 'e' , GeomFromText('POINT(88 81)' )),'m' , 'a' , 'h' , GeomFromText('POINT(35 29)' )),'m' , 'h' , 'f' , GeomFromText('POINT(30 71)' )),'h' , 'k' , 'i' , GeomFromText('POINT(244 78)' )),'z' , 'v' , 'd' , GeomFromText('POINT(241 38)' )),'q' , 'l' , 'j' , GeomFromText('POINT(13 71)' )),'s' , 'p' , 'g' , GeomFromText('POINT(108 38)' )),'q' , 's' , 'j' , GeomFromText('POINT(92 101)' )),'l' , 'h' , 'g' , GeomFromText('POINT(120 78)' )),'w' , 't' , 'b' , GeomFromText('POINT(193 109)' )),'b' , 's' , 's' , GeomFromText('POINT(223 211)' )),'w' , 'w' , 'y' , GeomFromText('POINT(122 42)' )),'q' , 'c' , 'c' , GeomFromText('POINT(104 102)' )),'w' , 'g' , 'n' , GeomFromText('POINT(213 120)' )),'p' , 'q' , 'a' , GeomFromText('POINT(247 148)' )),'c' , 'z' , 'e' , GeomFromText('POINT(18 106)' )),'z' , 'u' , 'n' , GeomFromText('POINT(70 133)' )),'j' , 'n' , 'x' , GeomFromText('POINT(232 13)' )),'e' , 'h' , 'f' , GeomFromText('POINT(22 135)' )),'w' , 'l' , 'f' , GeomFromText('POINT(9 180)' )),'a' , 'v' , 'q' , GeomFromText('POINT(163 228)' )),'i' , 'z' , 'o' , GeomFromText('POINT(180 100)' )),'e' , 'c' , 'l' , GeomFromText('POINT(182 231)' )),'c' , 'k' , 'o' , GeomFromText('POINT(19 60)' )),'q' , 'f' , 'p' , GeomFromText('POINT(79 95)' )),'m' , 'd' , 'r' , GeomFromText('POINT(3 127)' )),'m' , 'e' , 't' , GeomFromText('POINT(136 154)' )),'w' , 'w' , 'w' , GeomFromText('POINT(102 15)' )),'l' , 'n' , 'q' , GeomFromText('POINT(71 196)' )),'p' , 'k' , 'c' , GeomFromText('POINT(47 139)' )),'j' , 'o' , 'r' , GeomFromText('POINT(177 128)' )),'j' , 'q' , 'a' , GeomFromText('POINT(170 6)' )),'b' , 'a' , 'o' , GeomFromText('POINT(63 211)' )),'g' , 's' , 'o' , GeomFromText('POINT(144 251)' )),'w' , 'u' , 'w' , GeomFromText('POINT(221 214)' )),'g' , 'a' , 'm' , GeomFromText('POINT(14 102)' )),'u' , 'q' , 'z' , GeomFromText('POINT(86 200)' )),'k' , 'a' , 'm' , GeomFromText('POINT(144 222)' )),'j' , 'u' , 'r' , GeomFromText('POINT(216 142)' )),'q' , 'k' , 'v' , GeomFromText('POINT(121 236)' )),'p' , 'o' , 'r' , GeomFromText('POINT(108 102)' )),'b' , 'd' , 'x' , GeomFromText('POINT(127 198)' )),'k' , 's' , 'a' , GeomFromText('POINT(2 150)' )),'f' , 'm' , 'f' , GeomFromText('POINT(160 191)' )),'q' , 'y' , 'x' , GeomFromText('POINT(98 111)' )),'o' , 'f' , 'm' , GeomFromText('POINT(232 218)' )),'c' , 'w' , 'j' , GeomFromText('POINT(156 165)' )),'s' , 'q' , 'v' , GeomFromText('POINT(98 161)' )); SET @@RAND_SEED1=692635050 , @@RAND_SEED2=297339954 ; 10 ; SET @@RAND_SEED1=159925977 , @@RAND_SEED2=942570618 ; 10 ; SET @@RAND_SEED1=328169745 , @@RAND_SEED2=410451954 ; 10 ; SET @@RAND_SEED1=178507359 , @@RAND_SEED2=332493072 ; 10 ; SET @@RAND_SEED1=1034033013 , @@RAND_SEED2=558966507 ; 10 ; set spatial_point=GeomFromText('POINT(230 9)' ) where c1 like 'y%' ; set spatial_point=GeomFromText('POINT(95 35)' ) where c1 like 'j%' ; set spatial_point=GeomFromText('POINT(93 99)' ) where c1 like 'a%' ; set spatial_point=GeomFromText('POINT(19 81)' ) where c1 like 'r%' ; set spatial_point=GeomFromText('POINT(20 177)' ) where c1 like 'h%' ; set spatial_point=GeomFromText('POINT(221 193)' ) where c1 like 'u%' ; set spatial_point=GeomFromText('POINT(195 205)' ) where c1 like 'd%' ; set spatial_point=GeomFromText('POINT(15 213)' ) where c1 like 'u%' ; set spatial_point=GeomFromText('POINT(214 63)' ) where c1 like 'n%' ; set spatial_point=GeomFromText('POINT(243 171)' ) where c1 like 'c%' ; set spatial_point=GeomFromText('POINT(198 82)' ) where c1 like 'y%' ; 'f' , 'y' , 'p' , GeomFromText('POINT(109 235)' )),'b' , 'e' , 'v' , GeomFromText('POINT(20 48)' )),'i' , 'u' , 'f' , GeomFromText('POINT(15 55)' )),'o' , 'r' , 'z' , GeomFromText('POINT(105 64)' )),'a' , 'p' , 'a' , GeomFromText('POINT(142 236)' )),'g' , 'i' , 'k' , GeomFromText('POINT(10 49)' )),'x' , 'z' , 'x' , GeomFromText('POINT(192 200)' )),'c' , 'v' , 'r' , GeomFromText('POINT(94 168)' )),'y' , 'z' , 'e' , GeomFromText('POINT(141 51)' )),'h' , 'm' , 'd' , GeomFromText('POINT(35 251)' )),'v' , 'm' , 'q' , GeomFromText('POINT(44 90)' )),'j' , 'l' , 'z' , GeomFromText('POINT(67 237)' )),'i' , 'v' , 'a' , GeomFromText('POINT(75 14)' )),'b' , 'q' , 't' , GeomFromText('POINT(153 33)' )),'e' , 'm' , 'a' , GeomFromText('POINT(247 49)' )),'l' , 'y' , 'g' , GeomFromText('POINT(56 203)' )),'v' , 'o' , 'r' , GeomFromText('POINT(90 54)' )),'r' , 'n' , 'd' , GeomFromText('POINT(135 83)' )),'j' , 't' , 'u' , GeomFromText('POINT(174 239)' )),'u' , 'n' , 'g' , GeomFromText('POINT(104 191)' )),'p' , 'q' , 'y' , GeomFromText('POINT(63 171)' )),'o' , 'q' , 'p' , GeomFromText('POINT(192 103)' )),'f' , 'x' , 'e' , GeomFromText('POINT(244 30)' )),'n' , 'x' , 'c' , GeomFromText('POINT(92 103)' )),'r' , 'q' , 'z' , GeomFromText('POINT(166 20)' )),'s' , 'a' , 'j' , GeomFromText('POINT(137 205)' )),'z' , 't' , 't' , GeomFromText('POINT(99 134)' )),'o' , 'm' , 'j' , GeomFromText('POINT(217 3)' )),'n' , 'h' , 'j' , GeomFromText('POINT(211 17)' )),'v' , 'v' , 'a' , GeomFromText('POINT(41 137)' )),'q' , 'o' , 'j' , GeomFromText('POINT(5 92)' )),'z' , 'y' , 'e' , GeomFromText('POINT(175 212)' )),'j' , 'z' , 'h' , GeomFromText('POINT(224 194)' )),'a' , 'g' , 'm' , GeomFromText('POINT(31 119)' )),'p' , 'c' , 'f' , GeomFromText('POINT(17 221)' )),'t' , 'h' , 'k' , GeomFromText('POINT(26 203)' )),'u' , 'w' , 'p' , GeomFromText('POINT(47 185)' )),'z' , 'a' , 'c' , GeomFromText('POINT(61 133)' )),'u' , 'k' , 'a' , GeomFromText('POINT(210 115)' )),'k' , 'f' , 'h' , GeomFromText('POINT(125 113)' )),'t' , 'v' , 'y' , GeomFromText('POINT(12 239)' )),'u' , 'v' , 'd' , GeomFromText('POINT(90 24)' )),'m' , 'y' , 'w' , GeomFromText('POINT(25 243)' )),'d' , 'n' , 'g' , GeomFromText('POINT(122 92)' )),'z' , 'm' , 'f' , GeomFromText('POINT(235 110)' )),'q' , 'd' , 'f' , GeomFromText('POINT(233 217)' )),'a' , 'v' , 'u' , GeomFromText('POINT(69 59)' )),'x' , 'k' , 'p' , GeomFromText('POINT(240 14)' )),'i' , 'v' , 'r' , GeomFromText('POINT(154 42)' )),'w' , 'h' , 'l' , GeomFromText('POINT(178 156)' )),'d' , 'h' , 'n' , GeomFromText('POINT(65 157)' )),'c' , 'k' , 'z' , GeomFromText('POINT(62 33)' )),'e' , 'l' , 'w' , GeomFromText('POINT(162 1)' )),'r' , 'f' , 'i' , GeomFromText('POINT(127 71)' )),'q' , 'm' , 'c' , GeomFromText('POINT(63 118)' )),'c' , 'h' , 'u' , GeomFromText('POINT(205 203)' )),'d' , 't' , 'p' , GeomFromText('POINT(234 87)' )),'s' , 'g' , 'h' , GeomFromText('POINT(149 34)' )),'o' , 'b' , 'q' , GeomFromText('POINT(159 179)' )),'k' , 'u' , 'f' , GeomFromText('POINT(202 254)' )),'u' , 'f' , 'g' , GeomFromText('POINT(70 15)' )),'x' , 's' , 'b' , GeomFromText('POINT(25 181)' )),'s' , 'c' , 'g' , GeomFromText('POINT(252 17)' )),'a' , 'c' , 'f' , GeomFromText('POINT(89 67)' )),'r' , 'e' , 'q' , GeomFromText('POINT(55 54)' )),'f' , 'i' , 'k' , GeomFromText('POINT(178 230)' )),'p' , 'e' , 'l' , GeomFromText('POINT(198 28)' )),'w' , 'o' , 'd' , GeomFromText('POINT(204 189)' )),'c' , 'a' , 'g' , GeomFromText('POINT(230 178)' )),'r' , 'o' , 'e' , GeomFromText('POINT(61 116)' )),'w' , 'a' , 'a' , GeomFromText('POINT(178 237)' )),'v' , 'd' , 'e' , GeomFromText('POINT(70 85)' )),'k' , 'c' , 'e' , GeomFromText('POINT(147 118)' )),'d' , 'q' , 't' , GeomFromText('POINT(218 77)' )),'k' , 'g' , 'f' , GeomFromText('POINT(192 113)' )),'w' , 'n' , 'e' , GeomFromText('POINT(92 124)' )),'r' , 'm' , 'q' , GeomFromText('POINT(130 65)' )),'o' , 'r' , 'r' , GeomFromText('POINT(174 233)' )),'k' , 'n' , 't' , GeomFromText('POINT(175 147)' )),'q' , 'm' , 'r' , GeomFromText('POINT(18 208)' )),'l' , 'd' , 'i' , GeomFromText('POINT(13 104)' )),'w' , 'o' , 'y' , GeomFromText('POINT(207 39)' )),'p' , 'u' , 'o' , GeomFromText('POINT(114 31)' )),'y' , 'a' , 'p' , GeomFromText('POINT(106 59)' )),'a' , 'x' , 'z' , GeomFromText('POINT(17 57)' )),'v' , 'h' , 'x' , GeomFromText('POINT(170 13)' )),'t' , 's' , 'u' , GeomFromText('POINT(84 18)' )),'z' , 'z' , 'f' , GeomFromText('POINT(250 197)' )),'l' , 'z' , 't' , GeomFromText('POINT(59 80)' )),'j' , 'g' , 's' , GeomFromText('POINT(54 26)' )),'g' , 'v' , 'm' , GeomFromText('POINT(89 98)' )),'q' , 'v' , 'b' , GeomFromText('POINT(39 240)' )),'x' , 'k' , 'v' , GeomFromText('POINT(246 207)' )),'k' , 'u' , 'i' , GeomFromText('POINT(105 111)' )),'w' , 'z' , 's' , GeomFromText('POINT(235 8)' )),'d' , 'd' , 'd' , GeomFromText('POINT(105 4)' )),'c' , 'z' , 'q' , GeomFromText('POINT(13 140)' )),'m' , 'k' , 'i' , GeomFromText('POINT(208 120)' )),'g' , 'a' , 'g' , GeomFromText('POINT(9 182)' )),'z' , 'j' , 'r' , GeomFromText('POINT(149 153)' )),'h' , 'f' , 'g' , GeomFromText('POINT(81 236)' )),'m' , 'e' , 'q' , GeomFromText('POINT(209 215)' )),'c' , 'h' , 'y' , GeomFromText('POINT(235 70)' )),'i' , 'e' , 'g' , GeomFromText('POINT(138 26)' )),'m' , 't' , 'u' , GeomFromText('POINT(119 237)' )),'o' , 'w' , 's' , GeomFromText('POINT(193 166)' )),'f' , 'm' , 'q' , GeomFromText('POINT(85 96)' )),'x' , 'l' , 'x' , GeomFromText('POINT(58 115)' )),'x' , 'q' , 'u' , GeomFromText('POINT(108 210)' )),'b' , 'h' , 'i' , GeomFromText('POINT(250 139)' )),'y' , 'd' , 'x' , GeomFromText('POINT(199 135)' )),'w' , 'h' , 'p' , GeomFromText('POINT(247 233)' )),'p' , 'z' , 't' , GeomFromText('POINT(148 249)' )),'q' , 'a' , 'u' , GeomFromText('POINT(174 78)' )),'v' , 't' , 'm' , GeomFromText('POINT(70 228)' )),'t' , 'n' , 'f' , GeomFromText('POINT(123 2)' )),'x' , 't' , 'b' , GeomFromText('POINT(35 50)' )),'r' , 'j' , 'f' , GeomFromText('POINT(200 51)' )),'s' , 'q' , 'o' , GeomFromText('POINT(23 184)' )),'u' , 'v' , 'z' , GeomFromText('POINT(7 113)' )),'v' , 'u' , 'l' , GeomFromText('POINT(145 190)' )),'o' , 'k' , 'i' , GeomFromText('POINT(161 122)' )),'l' , 'y' , 'e' , GeomFromText('POINT(17 232)' )),'t' , 'b' , 'e' , GeomFromText('POINT(120 50)' )),'e' , 's' , 'u' , GeomFromText('POINT(254 1)' )),'d' , 'd' , 'u' , GeomFromText('POINT(167 140)' )),'o' , 'b' , 'x' , GeomFromText('POINT(186 237)' )),'m' , 's' , 's' , GeomFromText('POINT(172 149)' )),'t' , 'y' , 'a' , GeomFromText('POINT(149 85)' )),'x' , 't' , 'r' , GeomFromText('POINT(10 165)' )),'g' , 'c' , 'e' , GeomFromText('POINT(95 165)' )),'e' , 'e' , 'z' , GeomFromText('POINT(98 65)' )),'f' , 'v' , 'i' , GeomFromText('POINT(149 144)' )),'o' , 'p' , 'm' , GeomFromText('POINT(233 67)' )),'t' , 'u' , 'b' , GeomFromText('POINT(109 215)' )),'o' , 'o' , 'b' , GeomFromText('POINT(130 48)' )),'e' , 'm' , 'h' , GeomFromText('POINT(88 189)' )),'e' , 'v' , 'y' , GeomFromText('POINT(55 29)' )),'e' , 't' , 'm' , GeomFromText('POINT(129 55)' )),'p' , 'p' , 'i' , GeomFromText('POINT(126 222)' )),'c' , 'i' , 'c' , GeomFromText('POINT(19 158)' )),'c' , 'b' , 's' , GeomFromText('POINT(13 19)' )),'u' , 'y' , 'a' , GeomFromText('POINT(114 5)' )),'a' , 'o' , 'f' , GeomFromText('POINT(227 232)' )),'t' , 'c' , 'z' , GeomFromText('POINT(63 62)' )),'d' , 'o' , 'k' , GeomFromText('POINT(48 228)' )),'x' , 'c' , 'e' , GeomFromText('POINT(204 2)' )),'e' , 'e' , 'g' , GeomFromText('POINT(125 43)' )),'o' , 'r' , 'f' , GeomFromText('POINT(171 140)' )); set spatial_point=GeomFromText('POINT(163 157)' ) where c1 like 'w%' ; set spatial_point=GeomFromText('POINT(53 151)' ) where c1 like 'd%' ; set spatial_point=GeomFromText('POINT(96 183)' ) where c1 like 'r%' ; set spatial_point=GeomFromText('POINT(57 91)' ) where c1 like 'q%' ; set spatial_point=GeomFromText('POINT(202 110)' ) where c1 like 'c%' ; set spatial_point=GeomFromText('POINT(120 137)' ) where c1 like 'w%' ; set spatial_point=GeomFromText('POINT(207 147)' ) where c1 like 'c%' ; set spatial_point=GeomFromText('POINT(31 125)' ) where c1 like 'e%' ; set spatial_point=GeomFromText('POINT(27 36)' ) where c1 like 'r%' ; 'b' , 'c' , 'e' , GeomFromText('POINT(41 137)' )),'p' , 'y' , 'k' , GeomFromText('POINT(50 22)' )),'s' , 'c' , 'h' , GeomFromText('POINT(208 173)' )),'x' , 'u' , 'l' , GeomFromText('POINT(199 175)' )),'s' , 'r' , 'h' , GeomFromText('POINT(85 192)' )),'j' , 'k' , 'u' , GeomFromText('POINT(18 25)' )),'p' , 'w' , 'h' , GeomFromText('POINT(152 197)' )),'e' , 'd' , 'c' , GeomFromText('POINT(229 3)' )),'o' , 'x' , 'k' , GeomFromText('POINT(187 155)' )),'o' , 'b' , 'k' , GeomFromText('POINT(208 150)' )),'d' , 'a' , 'j' , GeomFromText('POINT(70 87)' )),'f' , 'e' , 'k' , GeomFromText('POINT(156 96)' )),'u' , 'y' , 'p' , GeomFromText('POINT(239 193)' )),'n' , 'v' , 'p' , GeomFromText('POINT(223 98)' )),'z' , 'j' , 'r' , GeomFromText('POINT(87 89)' )),'h' , 'x' , 'x' , GeomFromText('POINT(92 0)' )),'r' , 'v' , 'r' , GeomFromText('POINT(159 139)' )),'v' , 'g' , 'g' , GeomFromText('POINT(16 229)' )),'z' , 'k' , 'u' , GeomFromText('POINT(99 52)' )),'p' , 'p' , 'o' , GeomFromText('POINT(105 125)' )),'w' , 'h' , 'y' , GeomFromText('POINT(105 154)' )),'v' , 'y' , 'z' , GeomFromText('POINT(134 238)' )),'x' , 'o' , 'o' , GeomFromText('POINT(178 88)' )),'z' , 'w' , 'd' , GeomFromText('POINT(123 60)' )),'q' , 'f' , 'u' , GeomFromText('POINT(64 90)' )),'s' , 'n' , 't' , GeomFromText('POINT(50 138)' )),'v' , 'p' , 't' , GeomFromText('POINT(114 91)' )),'a' , 'o' , 'n' , GeomFromText('POINT(78 43)' )),'k' , 'u' , 'd' , GeomFromText('POINT(185 161)' )),'w' , 'd' , 'n' , GeomFromText('POINT(25 92)' )),'k' , 'w' , 'a' , GeomFromText('POINT(59 238)' )),'t' , 'c' , 'f' , GeomFromText('POINT(65 87)' )),'g' , 's' , 'p' , GeomFromText('POINT(238 126)' )),'d' , 'n' , 'y' , GeomFromText('POINT(107 173)' )),'l' , 'a' , 'w' , GeomFromText('POINT(125 152)' )),'m' , 'd' , 'j' , GeomFromText('POINT(146 53)' )),'q' , 'm' , 'c' , GeomFromText('POINT(217 187)' )),'i' , 'r' , 'r' , GeomFromText('POINT(6 113)' )),'e' , 'j' , 'b' , GeomFromText('POINT(37 83)' )),'w' , 'w' , 'h' , GeomFromText('POINT(83 199)' )),'k' , 'b' , 's' , GeomFromText('POINT(170 64)' )),'s' , 'b' , 'c' , GeomFromText('POINT(163 130)' )),'c' , 'h' , 'a' , GeomFromText('POINT(141 3)' )),'k' , 'j' , 'u' , GeomFromText('POINT(143 76)' )),'r' , 'h' , 'o' , GeomFromText('POINT(243 92)' )),'i' , 'd' , 'b' , GeomFromText('POINT(205 13)' )),'r' , 'y' , 'q' , GeomFromText('POINT(138 8)' )),'m' , 'o' , 'i' , GeomFromText('POINT(36 45)' )),'v' , 'g' , 'm' , GeomFromText('POINT(0 40)' )),'f' , 'e' , 'i' , GeomFromText('POINT(76 6)' )),'c' , 'q' , 'q' , GeomFromText('POINT(115 248)' )),'x' , 'c' , 'i' , GeomFromText('POINT(29 74)' )),'l' , 's' , 't' , GeomFromText('POINT(83 18)' )),'t' , 't' , 'a' , GeomFromText('POINT(26 168)' )),'u' , 'n' , 'x' , GeomFromText('POINT(200 110)' )),'j' , 'b' , 'd' , GeomFromText('POINT(216 136)' )),'s' , 'p' , 'w' , GeomFromText('POINT(38 156)' )),'f' , 'b' , 'v' , GeomFromText('POINT(29 186)' )),'v' , 'e' , 'r' , GeomFromText('POINT(149 40)' )),'v' , 't' , 'm' , GeomFromText('POINT(184 24)' )),'y' , 'g' , 'a' , GeomFromText('POINT(219 105)' )),'s' , 'f' , 'i' , GeomFromText('POINT(114 130)' )),'e' , 'q' , 'h' , GeomFromText('POINT(203 135)' )),'h' , 'g' , 'b' , GeomFromText('POINT(9 208)' )),'o' , 'l' , 'r' , GeomFromText('POINT(245 79)' )),'s' , 's' , 'v' , GeomFromText('POINT(238 198)' )),'w' , 'w' , 'z' , GeomFromText('POINT(209 232)' )),'v' , 'd' , 'n' , GeomFromText('POINT(30 193)' )),'q' , 'w' , 'k' , GeomFromText('POINT(133 18)' )),'o' , 'h' , 'o' , GeomFromText('POINT(42 140)' )),'f' , 'f' , 'h' , GeomFromText('POINT(145 1)' )),'u' , 's' , 'r' , GeomFromText('POINT(70 62)' )),'x' , 'n' , 'q' , GeomFromText('POINT(33 86)' )),'u' , 'p' , 'v' , GeomFromText('POINT(232 220)' )),'z' , 'e' , 'a' , GeomFromText('POINT(130 69)' )),'r' , 'u' , 'z' , GeomFromText('POINT(243 241)' )),'b' , 'n' , 't' , GeomFromText('POINT(120 12)' )),'u' , 'f' , 's' , GeomFromText('POINT(190 212)' )),'a' , 'd' , 'q' , GeomFromText('POINT(235 191)' )),'f' , 'q' , 'm' , GeomFromText('POINT(176 2)' )),'n' , 'c' , 's' , GeomFromText('POINT(218 163)' )),'e' , 'm' , 'h' , GeomFromText('POINT(163 108)' )),'c' , 'f' , 'l' , GeomFromText('POINT(220 115)' )),'c' , 'v' , 'q' , GeomFromText('POINT(66 45)' )),'w' , 'v' , 'x' , GeomFromText('POINT(251 220)' )),'f' , 'w' , 'z' , GeomFromText('POINT(146 149)' )),'h' , 'n' , 'h' , GeomFromText('POINT(148 128)' )),'y' , 'k' , 'v' , GeomFromText('POINT(28 110)' )),'c' , 'x' , 'q' , GeomFromText('POINT(13 13)' )),'e' , 'd' , 's' , GeomFromText('POINT(91 190)' )),'c' , 'w' , 'c' , GeomFromText('POINT(10 231)' )),'u' , 'j' , 'n' , GeomFromText('POINT(250 21)' )),'w' , 'n' , 'x' , GeomFromText('POINT(141 69)' )),'f' , 'p' , 'y' , GeomFromText('POINT(228 246)' )),'d' , 'q' , 'f' , GeomFromText('POINT(194 22)' )),'d' , 'z' , 'l' , GeomFromText('POINT(233 181)' )),'c' , 'a' , 'q' , GeomFromText('POINT(183 96)' )),'m' , 'i' , 'd' , GeomFromText('POINT(117 226)' )),'z' , 'y' , 'y' , GeomFromText('POINT(62 81)' )),'g' , 'v' , 'm' , GeomFromText('POINT(66 158)' )); SET @@RAND_SEED1=481064922 , @@RAND_SEED2=438133497 ; 10 ; SET @@RAND_SEED1=280535103 , @@RAND_SEED2=444518646 ; 10 ; SET @@RAND_SEED1=1072017234 , @@RAND_SEED2=484203885 ; 10 ; SET @@RAND_SEED1=358851897 , @@RAND_SEED2=358495224 ; 10 ; SET @@RAND_SEED1=509031459 , @@RAND_SEED2=675962925 ; 10 ; set spatial_point=GeomFromText('POINT(61 203)' ) where c1 like 'y%' ; set spatial_point=GeomFromText('POINT(202 194)' ) where c1 like 'f%' ; set spatial_point=GeomFromText('POINT(228 18)' ) where c1 like 'h%' ; set spatial_point=GeomFromText('POINT(88 18)' ) where c1 like 'l%' ; set spatial_point=GeomFromText('POINT(176 94)' ) where c1 like 'e%' ; set spatial_point=GeomFromText('POINT(44 47)' ) where c1 like 'g%' ; set spatial_point=GeomFromText('POINT(95 191)' ) where c1 like 'b%' ; set spatial_point=GeomFromText('POINT(179 218)' ) where c1 like 'y%' ; set spatial_point=GeomFromText('POINT(239 40)' ) where c1 like 'g%' ; set spatial_point=GeomFromText('POINT(248 41)' ) where c1 like 'q%' ; set spatial_point=GeomFromText('POINT(167 82)' ) where c1 like 't%' ; set spatial_point=GeomFromText('POINT(13 104)' ) where c1 like 'u%' ; set spatial_point=GeomFromText('POINT(139 84)' ) where c1 like 'a%' ; set spatial_point=GeomFromText('POINT(145 108)' ) where c1 like 'p%' ; set spatial_point=GeomFromText('POINT(147 57)' ) where c1 like 't%' ; set spatial_point=GeomFromText('POINT(217 144)' ) where c1 like 'n%' ; set spatial_point=GeomFromText('POINT(160 224)' ) where c1 like 'w%' ; set spatial_point=GeomFromText('POINT(38 28)' ) where c1 like 'j%' ; set spatial_point=GeomFromText('POINT(104 114)' ) where c1 like 'q%' ; set spatial_point=GeomFromText('POINT(88 19)' ) where c1 like 'c%' ; 'f' , 'x' , 'p' , GeomFromText('POINT(92 181)' )),'s' , 'i' , 'c' , GeomFromText('POINT(49 60)' )),'c' , 'c' , 'i' , GeomFromText('POINT(7 57)' )),'n' , 'g' , 'k' , GeomFromText('POINT(252 105)' )),'g' , 'b' , 'm' , GeomFromText('POINT(180 11)' )),'u' , 'l' , 'r' , GeomFromText('POINT(32 90)' )),'c' , 'x' , 'e' , GeomFromText('POINT(143 24)' )),'x' , 'u' , 'a' , GeomFromText('POINT(123 92)' )),'s' , 'b' , 'h' , GeomFromText('POINT(190 108)' )),'c' , 'x' , 'b' , GeomFromText('POINT(104 100)' )),'i' , 'd' , 't' , GeomFromText('POINT(214 104)' )),'r' , 'w' , 'g' , GeomFromText('POINT(29 67)' )),'b' , 'f' , 'g' , GeomFromText('POINT(149 46)' )),'r' , 'r' , 'd' , GeomFromText('POINT(242 196)' )),'j' , 'l' , 'a' , GeomFromText('POINT(90 196)' )),'e' , 't' , 'b' , GeomFromText('POINT(190 64)' )),'l' , 'x' , 'w' , GeomFromText('POINT(250 73)' )),'q' , 'y' , 'r' , GeomFromText('POINT(120 182)' )),'s' , 'j' , 'a' , GeomFromText('POINT(180 175)' )),'n' , 'i' , 'y' , GeomFromText('POINT(124 136)' )),'s' , 'x' , 's' , GeomFromText('POINT(176 209)' )),'u' , 'f' , 's' , GeomFromText('POINT(215 173)' )),'m' , 'j' , 'x' , GeomFromText('POINT(44 140)' )),'v' , 'g' , 'x' , GeomFromText('POINT(177 233)' )),'u' , 't' , 'b' , GeomFromText('POINT(136 197)' )),'f' , 'g' , 'b' , GeomFromText('POINT(10 8)' )),'v' , 'c' , 'j' , GeomFromText('POINT(13 81)' )),'d' , 's' , 'q' , GeomFromText('POINT(200 100)' )),'a' , 'p' , 'j' , GeomFromText('POINT(33 40)' )),'i' , 'c' , 'g' , GeomFromText('POINT(168 204)' )),'k' , 'h' , 'i' , GeomFromText('POINT(93 243)' )),'s' , 'b' , 's' , GeomFromText('POINT(157 13)' )),'v' , 'l' , 'l' , GeomFromText('POINT(103 6)' )),'r' , 'b' , 'k' , GeomFromText('POINT(244 137)' )),'l' , 'd' , 'r' , GeomFromText('POINT(162 254)' )),'q' , 'b' , 'z' , GeomFromText('POINT(136 246)' )),'x' , 'x' , 'p' , GeomFromText('POINT(120 37)' )),'m' , 'e' , 'z' , GeomFromText('POINT(203 167)' )),'q' , 'n' , 'p' , GeomFromText('POINT(94 119)' )),'b' , 'g' , 'u' , GeomFromText('POINT(93 248)' )),'r' , 'v' , 'v' , GeomFromText('POINT(53 88)' )),'y' , 'a' , 'i' , GeomFromText('POINT(98 219)' )),'a' , 's' , 'g' , GeomFromText('POINT(173 138)' )),'c' , 'a' , 't' , GeomFromText('POINT(235 135)' )),'q' , 'm' , 'd' , GeomFromText('POINT(224 208)' )),'e' , 'p' , 'k' , GeomFromText('POINT(161 238)' )),'n' , 'g' , 'q' , GeomFromText('POINT(35 204)' )),'t' , 't' , 'x' , GeomFromText('POINT(230 178)' )),'w' , 'f' , 'a' , GeomFromText('POINT(150 221)' )),'z' , 'm' , 'z' , GeomFromText('POINT(119 42)' )),'l' , 'j' , 's' , GeomFromText('POINT(97 96)' )),'f' , 'z' , 'x' , GeomFromText('POINT(208 65)' )),'i' , 'v' , 'c' , GeomFromText('POINT(145 79)' )),'l' , 'f' , 'k' , GeomFromText('POINT(83 234)' )),'u' , 'a' , 's' , GeomFromText('POINT(250 49)' )),'o' , 'k' , 'p' , GeomFromText('POINT(46 50)' )),'d' , 'e' , 'z' , GeomFromText('POINT(30 198)' )),'r' , 'r' , 'l' , GeomFromText('POINT(78 189)' )),'y' , 'l' , 'f' , GeomFromText('POINT(188 132)' )),'d' , 'q' , 'm' , GeomFromText('POINT(247 107)' )),'p' , 'j' , 'n' , GeomFromText('POINT(148 227)' )),'b' , 'o' , 'i' , GeomFromText('POINT(172 25)' )),'e' , 'v' , 'd' , GeomFromText('POINT(94 248)' )),'q' , 'd' , 'f' , GeomFromText('POINT(15 29)' )),'w' , 'b' , 'b' , GeomFromText('POINT(74 111)' )),'g' , 'q' , 'f' , GeomFromText('POINT(107 215)' )),'o' , 'h' , 'r' , GeomFromText('POINT(25 168)' )),'u' , 't' , 'w' , GeomFromText('POINT(251 188)' )),'h' , 's' , 'w' , GeomFromText('POINT(254 247)' )),'f' , 'f' , 'b' , GeomFromText('POINT(166 103)' )); SET @@RAND_SEED1=866613816 , @@RAND_SEED2=92289615 ; 'l' , 'c' , 'l' , GeomFromText('POINT(202 98)' )),'k' , 'c' , 'b' , GeomFromText('POINT(46 206)' )),'r' , 'y' , 'm' , GeomFromText('POINT(74 140)' )),'y' , 'z' , 'd' , GeomFromText('POINT(200 160)' )),'s' , 'y' , 's' , GeomFromText('POINT(156 205)' )),'u' , 'v' , 'p' , GeomFromText('POINT(86 82)' )),'j' , 's' , 's' , GeomFromText('POINT(91 233)' )),'x' , 'j' , 'f' , GeomFromText('POINT(3 14)' )),'l' , 'z' , 'v' , GeomFromText('POINT(123 156)' )),'h' , 'i' , 'o' , GeomFromText('POINT(145 229)' )),'o' , 'r' , 'd' , GeomFromText('POINT(15 22)' )),'f' , 'x' , 't' , GeomFromText('POINT(21 60)' )),'t' , 'g' , 'h' , GeomFromText('POINT(50 153)' )),'g' , 'u' , 'b' , GeomFromText('POINT(82 85)' )),'v' , 'a' , 'p' , GeomFromText('POINT(231 178)' )),'n' , 'v' , 'o' , GeomFromText('POINT(183 25)' )),'j' , 'n' , 'm' , GeomFromText('POINT(50 144)' )),'e' , 'f' , 'i' , GeomFromText('POINT(46 16)' )),'d' , 'w' , 'a' , GeomFromText('POINT(66 6)' )),'f' , 'x' , 'a' , GeomFromText('POINT(107 197)' )),'m' , 'o' , 'a' , GeomFromText('POINT(142 80)' )),'q' , 'l' , 'g' , GeomFromText('POINT(251 23)' )),'c' , 's' , 's' , GeomFromText('POINT(158 43)' )),'y' , 'd' , 'o' , GeomFromText('POINT(196 228)' )),'d' , 'p' , 'l' , GeomFromText('POINT(107 5)' )),'h' , 'a' , 'b' , GeomFromText('POINT(183 166)' )),'m' , 'w' , 'p' , GeomFromText('POINT(19 59)' )),'b' , 'y' , 'o' , GeomFromText('POINT(178 30)' )),'x' , 'w' , 'i' , GeomFromText('POINT(168 94)' )),'t' , 'k' , 'z' , GeomFromText('POINT(171 5)' )),'r' , 'm' , 'a' , GeomFromText('POINT(222 19)' )),'u' , 'v' , 'e' , GeomFromText('POINT(224 80)' )),'q' , 'r' , 'k' , GeomFromText('POINT(212 218)' )),'d' , 'p' , 'j' , GeomFromText('POINT(169 7)' )),'d' , 'r' , 'v' , GeomFromText('POINT(193 23)' )),'n' , 'y' , 'y' , GeomFromText('POINT(130 178)' )),'m' , 'z' , 'r' , GeomFromText('POINT(81 200)' )),'j' , 'e' , 'w' , GeomFromText('POINT(145 239)' )),'v' , 'h' , 'x' , GeomFromText('POINT(24 105)' )),'z' , 'm' , 'a' , GeomFromText('POINT(175 129)' )),'b' , 'c' , 'v' , GeomFromText('POINT(213 10)' )),'t' , 't' , 'u' , GeomFromText('POINT(2 129)' )),'r' , 's' , 'v' , GeomFromText('POINT(209 192)' )),'x' , 'p' , 'g' , GeomFromText('POINT(43 63)' )),'t' , 'e' , 'u' , GeomFromText('POINT(139 210)' )),'l' , 'e' , 't' , GeomFromText('POINT(245 148)' )),'a' , 'i' , 'k' , GeomFromText('POINT(167 195)' )),'m' , 'o' , 'h' , GeomFromText('POINT(206 120)' )),'g' , 'z' , 's' , GeomFromText('POINT(169 240)' )),'z' , 'u' , 's' , GeomFromText('POINT(202 120)' )),'i' , 'b' , 'a' , GeomFromText('POINT(216 18)' )),'w' , 'y' , 'g' , GeomFromText('POINT(119 236)' )),'h' , 'y' , 'p' , GeomFromText('POINT(161 24)' )); set spatial_point=GeomFromText('POINT(33 100)' ) where c1 like 't%' ; set spatial_point=GeomFromText('POINT(41 46)' ) where c1 like 'f%' ; ; ; not null, spatial index(a)); 1 .1517219314031 e+164 , 131072 )); 9 .1248812352444 e+192 , 2 .9740338169556 e+284 )); 4 .7783097267365 e-299 , -0 )); 1 .49166814624 e-154 , 2 .0880974297595 e-53 )); 4 .0917382598702 e+149 , 1 .2024538023802 e+111 )); 2 .0349165139404 e+236 , 2 .9993936277913 e-241 )); 2 .5243548967072 e-29 , 1 .2024538023802 e+111 )); 0 , 6 .9835074892995 e-251 )); 2 .0880974297595 e-53 , 3 .1050361846014 e+231 )); 2 .8728483499323 e-188 , 2 .4600631144627 e+260 )); 3 .0517578125 e-05 , 2 .0349165139404 e+236 )); 1 .1517219314031 e+164 , 1 .1818212630766 e-125 )); 2 .481040258324 e-265 , 5 .7766220027675 e-275 )); 2 .0880974297595 e-53 , 2 .5243548967072 e-29 )); 5 .7766220027675 e-275 , 9 .9464647281957 e+86 )); 2 .2181357552967 e+130 , 3 .7857669957337 e-270 )); 4 .5767114681874 e-246 , 3 .6893488147419 e+19 )); 4 .5767114681874 e-246 , 3 .7537584144024 e+255 )); 3 .7857669957337 e-270 , 1 .8033161362863 e-130 )); 0 , 5 .8774717541114 e-39 )); 1 .1517219314031 e+164 , 2 .2761049594727 e-159 )); 6 .243497100632 e+144 , 3 .7857669957337 e-270 )); 3 .7857669957337 e-270 , 2 .6355494858076 e-82 )); 2 .0349165139404 e+236 , 3 .8518598887745 e-34 )); 4 .6566128730774 e-10 , 2 .0880974297595 e-53 )); 2 .0880974297595 e-53 , 1 .8827498946116 e-183 )); 1 .8033161362863 e-130 , 9 .1248812352444 e+192 )); 4 .7783097267365 e-299 , 2 .2761049594727 e-159 )); 1 .94906280228 e+289 , 1 .2338789709327 e-178 )); ; NOT NULL, SPATIAL INDEX(foo) ); ; ERROR 23000 : Column 'foo' cannot be null; ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY field'' ); ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY field; NOT NULL, KEY (a), SPATIAL KEY (b)); 'POINT(1 2)' )); ; ; ; ; ; ; ; NOT NULL, SPATIAL KEY b(b)); 1 , GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)' )); 2 , GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)' )); 'LINESTRING(1 1,1102219 2)' ) ); 2 'LINESTRING(1 1,1102219 2)' ) ); 2 ; 48258 : Assertion failed when using a spatial indexNOT NULL, SPATIAL KEY(a)); 'LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' )),'LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' )); 1 FROM t1 WHERE a = GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 SIMPLE t1 ALL a NULL NULL NULL 2 Using where1 FROM t1 WHERE a = GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 1 1 1 FROM t1 WHERE a < GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 SIMPLE t1 ALL a NULL NULL NULL 2 Using where1 FROM t1 WHERE a < GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 1 FROM t1 WHERE a <= GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 SIMPLE t1 ALL a NULL NULL NULL 2 Using where1 FROM t1 WHERE a <= GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 1 1 1 FROM t1 WHERE a > GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 SIMPLE t1 ALL a NULL NULL NULL 2 Using where1 FROM t1 WHERE a > GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 1 FROM t1 WHERE a >= GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 SIMPLE t1 ALL a NULL NULL NULL 2 Using where1 FROM t1 WHERE a >= GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)' ); 1 1 1 ; 51357 : crash when using handler commands on spatial indexesNOT NULL,SPATIAL INDEX a(a)); ; ; ; ; ; ; ; ; 'Polygon((40 40,60 40,60 60,40 60,40 40))' )); not crash; ; ; 5 .0 tests.57323 /11764487 : myisam corruption with insert ignoreand invalid spatial dataNOT NULL, b GEOMETRY NOT NULL,; "point (0 0)" ), GEOMFROMTEXT("point (1 1)" )); SET a=GEOMFROMTEXT("point (-6 0)" ), b=GEOMFROMTEXT("error" ); ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY fieldSET a=GEOMFROMTEXT("point (-6 0)" ), b=NULL; ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY field; 0 0 ) POINT(1 1 ); NOT NULL, b GEOMETRY NOT NULL,; 0 , GEOMFROMTEXT("point (1 1)" )); SET a=0 , b=GEOMFROMTEXT("error" ); ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY fieldSET a=1 , b=NULL; ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY field; 0 POINT(1 1 ); 5 .1 testsNOT NULL,; 'LINESTRING(0 0, 1 1)' )); 'LINESTRING(1 1, 2 2)' )); 'LINESTRING(2 2, 3 3)' )); 'POINT(0 0)' )); 1 'POINT(0.5 0.5)' ), l); 1 'POINT(0 0)' )); 1 'POINT(0.5 0.5)' ), l); 1 ; 10 .1 tests8239 Reverse spatial operations OP(const, field) do not get optimizedNOT NULL, SPATIAL KEY(a)); 1 ,2 )),(Point(1 ,3 )); 1 ,2 )); 1 SIMPLE t1 range a a 34 NULL 1 Using where1 ,2 )); 1 SIMPLE t1 range a a 34 NULL 1 Using where1 ,2 ),a); 1 SIMPLE t1 range a a 34 NULL 1 Using where1 ,2 ),a); 1 SIMPLE t1 range a a 34 NULL 1 Using where; 8610 "WHERE CONTAINS(indexed_geometry_column,1)" causes full table scanNOT NULL, SPATIAL KEY(a)); 1 ,1 )),(Point(2 ,2 )),(Point(3 ,3 )); 1 ); ERROR HY000: Illegal parameter data type int for operation 'st_contains' 1 .0 ); ERROR HY000: Illegal parameter data type decimal for operation 'st_contains' 1 e0); ERROR HY000: Illegal parameter data type double for operation 'st_contains' '00:00:00' ); ERROR HY000: Illegal parameter data type time for operation 'st_contains' '2001-01-01' ); ERROR HY000: Illegal parameter data type date for operation 'st_contains' '2001-01-01 00:00:00' ); ERROR HY000: Illegal parameter data type datetime for operation 'st_contains' ; 10 .1 testsNOT NULL,SPATIAL (c)); 'POINT(1 0)' )); SET c='' ; ERROR 22003 : Cannot get geometry object from data you send to the GEOMETRY field;
Messung V0.5 in Prozent C=56 H=100 G=80
¤ Dauer der Verarbeitung: 0.37 Sekunden
(vorverarbeitet am 2026-10-08)
¤ *© Formatika GbR, Deutschland
