| 1 |
set default_storage_engine=aria; |
| 2 |
DROP TABLE IF EXISTS t1, t2; |
| 3 |
CREATE TABLE t1 ( |
| 4 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 5 |
g GEOMETRY NOT NULL, |
| 6 |
SPATIAL KEY(g) |
| 7 |
) transactional=1 row_format=page; |
| 8 |
SHOW CREATE TABLE t1; |
| 9 |
Table Create Table |
| 10 |
t1 CREATE TABLE `t1` ( |
| 11 |
`fid` int(11) NOT NULL AUTO_INCREMENT, |
| 12 |
`g` geometry NOT NULL, |
| 13 |
PRIMARY KEY (`fid`), |
| 14 |
SPATIAL KEY `g` (`g`) |
| 15 |
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 ROW_FORMAT=PAGE TRANSACTIONAL=1 |
| 16 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(150 150, 150 150)')); |
| 17 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(149 149, 151 151)')); |
| 18 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(148 148, 152 152)')); |
| 19 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(147 147, 153 153)')); |
| 20 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(146 146, 154 154)')); |
| 21 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(145 145, 155 155)')); |
| 22 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(144 144, 156 156)')); |
| 23 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(143 143, 157 157)')); |
| 24 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(142 142, 158 158)')); |
| 25 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(141 141, 159 159)')); |
| 26 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(140 140, 160 160)')); |
| 27 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(139 139, 161 161)')); |
| 28 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(138 138, 162 162)')); |
| 29 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(137 137, 163 163)')); |
| 30 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(136 136, 164 164)')); |
| 31 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(135 135, 165 165)')); |
| 32 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(134 134, 166 166)')); |
| 33 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(133 133, 167 167)')); |
| 34 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(132 132, 168 168)')); |
| 35 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(131 131, 169 169)')); |
| 36 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(130 130, 170 170)')); |
| 37 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(129 129, 171 171)')); |
| 38 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(128 128, 172 172)')); |
| 39 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(127 127, 173 173)')); |
| 40 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(126 126, 174 174)')); |
| 41 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(125 125, 175 175)')); |
| 42 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(124 124, 176 176)')); |
| 43 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(123 123, 177 177)')); |
| 44 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(122 122, 178 178)')); |
| 45 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(121 121, 179 179)')); |
| 46 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(120 120, 180 180)')); |
| 47 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(119 119, 181 181)')); |
| 48 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(118 118, 182 182)')); |
| 49 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(117 117, 183 183)')); |
| 50 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(116 116, 184 184)')); |
| 51 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(115 115, 185 185)')); |
| 52 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(114 114, 186 186)')); |
| 53 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(113 113, 187 187)')); |
| 54 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(112 112, 188 188)')); |
| 55 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(111 111, 189 189)')); |
| 56 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(110 110, 190 190)')); |
| 57 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(109 109, 191 191)')); |
| 58 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(108 108, 192 192)')); |
| 59 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(107 107, 193 193)')); |
| 60 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(106 106, 194 194)')); |
| 61 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(105 105, 195 195)')); |
| 62 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(104 104, 196 196)')); |
| 63 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(103 103, 197 197)')); |
| 64 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(102 102, 198 198)')); |
| 65 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(101 101, 199 199)')); |
| 66 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(100 100, 200 200)')); |
| 67 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(99 99, 201 201)')); |
| 68 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(98 98, 202 202)')); |
| 69 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(97 97, 203 203)')); |
| 70 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(96 96, 204 204)')); |
| 71 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(95 95, 205 205)')); |
| 72 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(94 94, 206 206)')); |
| 73 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(93 93, 207 207)')); |
| 74 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(92 92, 208 208)')); |
| 75 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(91 91, 209 209)')); |
| 76 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(90 90, 210 210)')); |
| 77 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(89 89, 211 211)')); |
| 78 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(88 88, 212 212)')); |
| 79 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(87 87, 213 213)')); |
| 80 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(86 86, 214 214)')); |
| 81 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(85 85, 215 215)')); |
| 82 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(84 84, 216 216)')); |
| 83 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(83 83, 217 217)')); |
| 84 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(82 82, 218 218)')); |
| 85 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(81 81, 219 219)')); |
| 86 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(80 80, 220 220)')); |
| 87 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(79 79, 221 221)')); |
| 88 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(78 78, 222 222)')); |
| 89 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(77 77, 223 223)')); |
| 90 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(76 76, 224 224)')); |
| 91 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(75 75, 225 225)')); |
| 92 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(74 74, 226 226)')); |
| 93 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(73 73, 227 227)')); |
| 94 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(72 72, 228 228)')); |
| 95 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(71 71, 229 229)')); |
| 96 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(70 70, 230 230)')); |
| 97 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(69 69, 231 231)')); |
| 98 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(68 68, 232 232)')); |
| 99 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(67 67, 233 233)')); |
| 100 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(66 66, 234 234)')); |
| 101 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(65 65, 235 235)')); |
| 102 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(64 64, 236 236)')); |
| 103 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(63 63, 237 237)')); |
| 104 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(62 62, 238 238)')); |
| 105 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(61 61, 239 239)')); |
| 106 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(60 60, 240 240)')); |
| 107 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(59 59, 241 241)')); |
| 108 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(58 58, 242 242)')); |
| 109 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(57 57, 243 243)')); |
| 110 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(56 56, 244 244)')); |
| 111 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(55 55, 245 245)')); |
| 112 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(54 54, 246 246)')); |
| 113 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(53 53, 247 247)')); |
| 114 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(52 52, 248 248)')); |
| 115 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(51 51, 249 249)')); |
| 116 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(50 50, 250 250)')); |
| 117 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(49 49, 251 251)')); |
| 118 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(48 48, 252 252)')); |
| 119 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(47 47, 253 253)')); |
| 120 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(46 46, 254 254)')); |
| 121 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(45 45, 255 255)')); |
| 122 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(44 44, 256 256)')); |
| 123 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(43 43, 257 257)')); |
| 124 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(42 42, 258 258)')); |
| 125 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(41 41, 259 259)')); |
| 126 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(40 40, 260 260)')); |
| 127 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(39 39, 261 261)')); |
| 128 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(38 38, 262 262)')); |
| 129 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(37 37, 263 263)')); |
| 130 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(36 36, 264 264)')); |
| 131 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(35 35, 265 265)')); |
| 132 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(34 34, 266 266)')); |
| 133 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(33 33, 267 267)')); |
| 134 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(32 32, 268 268)')); |
| 135 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(31 31, 269 269)')); |
| 136 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(30 30, 270 270)')); |
| 137 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(29 29, 271 271)')); |
| 138 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(28 28, 272 272)')); |
| 139 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(27 27, 273 273)')); |
| 140 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(26 26, 274 274)')); |
| 141 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(25 25, 275 275)')); |
| 142 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(24 24, 276 276)')); |
| 143 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(23 23, 277 277)')); |
| 144 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(22 22, 278 278)')); |
| 145 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(21 21, 279 279)')); |
| 146 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(20 20, 280 280)')); |
| 147 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(19 19, 281 281)')); |
| 148 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(18 18, 282 282)')); |
| 149 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(17 17, 283 283)')); |
| 150 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(16 16, 284 284)')); |
| 151 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(15 15, 285 285)')); |
| 152 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(14 14, 286 286)')); |
| 153 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(13 13, 287 287)')); |
| 154 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(12 12, 288 288)')); |
| 155 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(11 11, 289 289)')); |
| 156 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(10 10, 290 290)')); |
| 157 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(9 9, 291 291)')); |
| 158 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(8 8, 292 292)')); |
| 159 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(7 7, 293 293)')); |
| 160 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(6 6, 294 294)')); |
| 161 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(5 5, 295 295)')); |
| 162 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(4 4, 296 296)')); |
| 163 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(3 3, 297 297)')); |
| 164 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(2 2, 298 298)')); |
| 165 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(1 1, 299 299)')); |
| 166 |
SELECT count(*) FROM t1; |
| 167 |
count(*) |
| 168 |
150 |
| 169 |
EXPLAIN SELECT fid, AsText(g) FROM t1 WHERE Within(g, GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')); |
| 170 |
id select_type table type possible_keys key key_len ref rows Extra |
| 171 |
1 SIMPLE t1 range g g 34 NULL 11 Using where |
| 172 |
SELECT fid, AsText(g) FROM t1 WHERE Within(g, GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')); |
| 173 |
fid AsText(g) |
| 174 |
1 LINESTRING(150 150,150 150) |
| 175 |
2 LINESTRING(149 149,151 151) |
| 176 |
3 LINESTRING(148 148,152 152) |
| 177 |
4 LINESTRING(147 147,153 153) |
| 178 |
5 LINESTRING(146 146,154 154) |
| 179 |
6 LINESTRING(145 145,155 155) |
| 180 |
7 LINESTRING(144 144,156 156) |
| 181 |
8 LINESTRING(143 143,157 157) |
| 182 |
9 LINESTRING(142 142,158 158) |
| 183 |
10 LINESTRING(141 141,159 159) |
| 184 |
11 LINESTRING(140 140,160 160) |
| 185 |
DROP TABLE t1; |
| 186 |
CREATE TABLE t2 ( |
| 187 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 188 |
g GEOMETRY NOT NULL |
| 189 |
) transactional=1 row_format=page; |
| 190 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 10 * 10 - 9), Point(10 * 10, 10 * 10)))); |
| 191 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 9 * 10 - 9), Point(10 * 10, 9 * 10)))); |
| 192 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 8 * 10 - 9), Point(10 * 10, 8 * 10)))); |
| 193 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 7 * 10 - 9), Point(10 * 10, 7 * 10)))); |
| 194 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 6 * 10 - 9), Point(10 * 10, 6 * 10)))); |
| 195 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 5 * 10 - 9), Point(10 * 10, 5 * 10)))); |
| 196 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 4 * 10 - 9), Point(10 * 10, 4 * 10)))); |
| 197 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 3 * 10 - 9), Point(10 * 10, 3 * 10)))); |
| 198 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 2 * 10 - 9), Point(10 * 10, 2 * 10)))); |
| 199 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(10 * 10 - 9, 1 * 10 - 9), Point(10 * 10, 1 * 10)))); |
| 200 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 10 * 10 - 9), Point(9 * 10, 10 * 10)))); |
| 201 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 9 * 10 - 9), Point(9 * 10, 9 * 10)))); |
| 202 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 8 * 10 - 9), Point(9 * 10, 8 * 10)))); |
| 203 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 7 * 10 - 9), Point(9 * 10, 7 * 10)))); |
| 204 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 6 * 10 - 9), Point(9 * 10, 6 * 10)))); |
| 205 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 5 * 10 - 9), Point(9 * 10, 5 * 10)))); |
| 206 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 4 * 10 - 9), Point(9 * 10, 4 * 10)))); |
| 207 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 3 * 10 - 9), Point(9 * 10, 3 * 10)))); |
| 208 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 2 * 10 - 9), Point(9 * 10, 2 * 10)))); |
| 209 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(9 * 10 - 9, 1 * 10 - 9), Point(9 * 10, 1 * 10)))); |
| 210 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 10 * 10 - 9), Point(8 * 10, 10 * 10)))); |
| 211 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 9 * 10 - 9), Point(8 * 10, 9 * 10)))); |
| 212 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 8 * 10 - 9), Point(8 * 10, 8 * 10)))); |
| 213 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 7 * 10 - 9), Point(8 * 10, 7 * 10)))); |
| 214 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 6 * 10 - 9), Point(8 * 10, 6 * 10)))); |
| 215 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 5 * 10 - 9), Point(8 * 10, 5 * 10)))); |
| 216 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 4 * 10 - 9), Point(8 * 10, 4 * 10)))); |
| 217 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 3 * 10 - 9), Point(8 * 10, 3 * 10)))); |
| 218 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 2 * 10 - 9), Point(8 * 10, 2 * 10)))); |
| 219 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(8 * 10 - 9, 1 * 10 - 9), Point(8 * 10, 1 * 10)))); |
| 220 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 10 * 10 - 9), Point(7 * 10, 10 * 10)))); |
| 221 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 9 * 10 - 9), Point(7 * 10, 9 * 10)))); |
| 222 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 8 * 10 - 9), Point(7 * 10, 8 * 10)))); |
| 223 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 7 * 10 - 9), Point(7 * 10, 7 * 10)))); |
| 224 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 6 * 10 - 9), Point(7 * 10, 6 * 10)))); |
| 225 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 5 * 10 - 9), Point(7 * 10, 5 * 10)))); |
| 226 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 4 * 10 - 9), Point(7 * 10, 4 * 10)))); |
| 227 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 3 * 10 - 9), Point(7 * 10, 3 * 10)))); |
| 228 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 2 * 10 - 9), Point(7 * 10, 2 * 10)))); |
| 229 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(7 * 10 - 9, 1 * 10 - 9), Point(7 * 10, 1 * 10)))); |
| 230 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 10 * 10 - 9), Point(6 * 10, 10 * 10)))); |
| 231 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 9 * 10 - 9), Point(6 * 10, 9 * 10)))); |
| 232 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 8 * 10 - 9), Point(6 * 10, 8 * 10)))); |
| 233 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 7 * 10 - 9), Point(6 * 10, 7 * 10)))); |
| 234 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 6 * 10 - 9), Point(6 * 10, 6 * 10)))); |
| 235 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 5 * 10 - 9), Point(6 * 10, 5 * 10)))); |
| 236 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 4 * 10 - 9), Point(6 * 10, 4 * 10)))); |
| 237 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 3 * 10 - 9), Point(6 * 10, 3 * 10)))); |
| 238 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 2 * 10 - 9), Point(6 * 10, 2 * 10)))); |
| 239 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(6 * 10 - 9, 1 * 10 - 9), Point(6 * 10, 1 * 10)))); |
| 240 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 10 * 10 - 9), Point(5 * 10, 10 * 10)))); |
| 241 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 9 * 10 - 9), Point(5 * 10, 9 * 10)))); |
| 242 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 8 * 10 - 9), Point(5 * 10, 8 * 10)))); |
| 243 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 7 * 10 - 9), Point(5 * 10, 7 * 10)))); |
| 244 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 6 * 10 - 9), Point(5 * 10, 6 * 10)))); |
| 245 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 5 * 10 - 9), Point(5 * 10, 5 * 10)))); |
| 246 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 4 * 10 - 9), Point(5 * 10, 4 * 10)))); |
| 247 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 3 * 10 - 9), Point(5 * 10, 3 * 10)))); |
| 248 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 2 * 10 - 9), Point(5 * 10, 2 * 10)))); |
| 249 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(5 * 10 - 9, 1 * 10 - 9), Point(5 * 10, 1 * 10)))); |
| 250 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 10 * 10 - 9), Point(4 * 10, 10 * 10)))); |
| 251 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 9 * 10 - 9), Point(4 * 10, 9 * 10)))); |
| 252 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 8 * 10 - 9), Point(4 * 10, 8 * 10)))); |
| 253 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 7 * 10 - 9), Point(4 * 10, 7 * 10)))); |
| 254 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 6 * 10 - 9), Point(4 * 10, 6 * 10)))); |
| 255 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 5 * 10 - 9), Point(4 * 10, 5 * 10)))); |
| 256 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 4 * 10 - 9), Point(4 * 10, 4 * 10)))); |
| 257 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 3 * 10 - 9), Point(4 * 10, 3 * 10)))); |
| 258 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 2 * 10 - 9), Point(4 * 10, 2 * 10)))); |
| 259 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(4 * 10 - 9, 1 * 10 - 9), Point(4 * 10, 1 * 10)))); |
| 260 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 10 * 10 - 9), Point(3 * 10, 10 * 10)))); |
| 261 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 9 * 10 - 9), Point(3 * 10, 9 * 10)))); |
| 262 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 8 * 10 - 9), Point(3 * 10, 8 * 10)))); |
| 263 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 7 * 10 - 9), Point(3 * 10, 7 * 10)))); |
| 264 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 6 * 10 - 9), Point(3 * 10, 6 * 10)))); |
| 265 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 5 * 10 - 9), Point(3 * 10, 5 * 10)))); |
| 266 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 4 * 10 - 9), Point(3 * 10, 4 * 10)))); |
| 267 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 3 * 10 - 9), Point(3 * 10, 3 * 10)))); |
| 268 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 2 * 10 - 9), Point(3 * 10, 2 * 10)))); |
| 269 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(3 * 10 - 9, 1 * 10 - 9), Point(3 * 10, 1 * 10)))); |
| 270 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 10 * 10 - 9), Point(2 * 10, 10 * 10)))); |
| 271 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 9 * 10 - 9), Point(2 * 10, 9 * 10)))); |
| 272 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 8 * 10 - 9), Point(2 * 10, 8 * 10)))); |
| 273 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 7 * 10 - 9), Point(2 * 10, 7 * 10)))); |
| 274 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 6 * 10 - 9), Point(2 * 10, 6 * 10)))); |
| 275 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 5 * 10 - 9), Point(2 * 10, 5 * 10)))); |
| 276 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 4 * 10 - 9), Point(2 * 10, 4 * 10)))); |
| 277 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 3 * 10 - 9), Point(2 * 10, 3 * 10)))); |
| 278 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 2 * 10 - 9), Point(2 * 10, 2 * 10)))); |
| 279 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(2 * 10 - 9, 1 * 10 - 9), Point(2 * 10, 1 * 10)))); |
| 280 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 10 * 10 - 9), Point(1 * 10, 10 * 10)))); |
| 281 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 9 * 10 - 9), Point(1 * 10, 9 * 10)))); |
| 282 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 8 * 10 - 9), Point(1 * 10, 8 * 10)))); |
| 283 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 7 * 10 - 9), Point(1 * 10, 7 * 10)))); |
| 284 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 6 * 10 - 9), Point(1 * 10, 6 * 10)))); |
| 285 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 5 * 10 - 9), Point(1 * 10, 5 * 10)))); |
| 286 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 4 * 10 - 9), Point(1 * 10, 4 * 10)))); |
| 287 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 3 * 10 - 9), Point(1 * 10, 3 * 10)))); |
| 288 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 2 * 10 - 9), Point(1 * 10, 2 * 10)))); |
| 289 |
INSERT INTO t2 (g) VALUES (GeometryFromWKB(LineString(Point(1 * 10 - 9, 1 * 10 - 9), Point(1 * 10, 1 * 10)))); |
| 290 |
ALTER TABLE t2 ADD SPATIAL KEY(g); |
| 291 |
SHOW CREATE TABLE t2; |
| 292 |
Table Create Table |
| 293 |
t2 CREATE TABLE `t2` ( |
| 294 |
`fid` int(11) NOT NULL AUTO_INCREMENT, |
| 295 |
`g` geometry NOT NULL, |
| 296 |
PRIMARY KEY (`fid`), |
| 297 |
SPATIAL KEY `g` (`g`) |
| 298 |
) ENGINE=Aria AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 ROW_FORMAT=PAGE TRANSACTIONAL=1 |
| 299 |
SELECT count(*) FROM t2; |
| 300 |
count(*) |
| 301 |
100 |
| 302 |
EXPLAIN SELECT fid, AsText(g) FROM t2 WHERE Within(g, |
| 303 |
GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')); |
| 304 |
id select_type table type possible_keys key key_len ref rows Extra |
| 305 |
1 SIMPLE t2 range g g 34 NULL 4 Using where |
| 306 |
SELECT fid, AsText(g) FROM t2 WHERE Within(g, |
| 307 |
GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')); |
| 308 |
fid AsText(g) |
| 309 |
45 LINESTRING(51 51,60 60) |
| 310 |
46 LINESTRING(51 41,60 50) |
| 311 |
55 LINESTRING(41 51,50 60) |
| 312 |
56 LINESTRING(41 41,50 50) |
| 313 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 10 * 10 - 9), Point(10 * 10, 10 * 10))))); |
| 314 |
SELECT count(*) FROM t2; |
| 315 |
count(*) |
| 316 |
99 |
| 317 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 9 * 10 - 9), Point(10 * 10, 9 * 10))))); |
| 318 |
SELECT count(*) FROM t2; |
| 319 |
count(*) |
| 320 |
98 |
| 321 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 8 * 10 - 9), Point(10 * 10, 8 * 10))))); |
| 322 |
SELECT count(*) FROM t2; |
| 323 |
count(*) |
| 324 |
97 |
| 325 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 7 * 10 - 9), Point(10 * 10, 7 * 10))))); |
| 326 |
SELECT count(*) FROM t2; |
| 327 |
count(*) |
| 328 |
96 |
| 329 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 6 * 10 - 9), Point(10 * 10, 6 * 10))))); |
| 330 |
SELECT count(*) FROM t2; |
| 331 |
count(*) |
| 332 |
95 |
| 333 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 5 * 10 - 9), Point(10 * 10, 5 * 10))))); |
| 334 |
SELECT count(*) FROM t2; |
| 335 |
count(*) |
| 336 |
94 |
| 337 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 4 * 10 - 9), Point(10 * 10, 4 * 10))))); |
| 338 |
SELECT count(*) FROM t2; |
| 339 |
count(*) |
| 340 |
93 |
| 341 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 3 * 10 - 9), Point(10 * 10, 3 * 10))))); |
| 342 |
SELECT count(*) FROM t2; |
| 343 |
count(*) |
| 344 |
92 |
| 345 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 2 * 10 - 9), Point(10 * 10, 2 * 10))))); |
| 346 |
SELECT count(*) FROM t2; |
| 347 |
count(*) |
| 348 |
91 |
| 349 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(10 * 10 - 9, 1 * 10 - 9), Point(10 * 10, 1 * 10))))); |
| 350 |
SELECT count(*) FROM t2; |
| 351 |
count(*) |
| 352 |
90 |
| 353 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 10 * 10 - 9), Point(9 * 10, 10 * 10))))); |
| 354 |
SELECT count(*) FROM t2; |
| 355 |
count(*) |
| 356 |
89 |
| 357 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 9 * 10 - 9), Point(9 * 10, 9 * 10))))); |
| 358 |
SELECT count(*) FROM t2; |
| 359 |
count(*) |
| 360 |
88 |
| 361 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 8 * 10 - 9), Point(9 * 10, 8 * 10))))); |
| 362 |
SELECT count(*) FROM t2; |
| 363 |
count(*) |
| 364 |
87 |
| 365 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 7 * 10 - 9), Point(9 * 10, 7 * 10))))); |
| 366 |
SELECT count(*) FROM t2; |
| 367 |
count(*) |
| 368 |
86 |
| 369 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 6 * 10 - 9), Point(9 * 10, 6 * 10))))); |
| 370 |
SELECT count(*) FROM t2; |
| 371 |
count(*) |
| 372 |
85 |
| 373 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 5 * 10 - 9), Point(9 * 10, 5 * 10))))); |
| 374 |
SELECT count(*) FROM t2; |
| 375 |
count(*) |
| 376 |
84 |
| 377 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 4 * 10 - 9), Point(9 * 10, 4 * 10))))); |
| 378 |
SELECT count(*) FROM t2; |
| 379 |
count(*) |
| 380 |
83 |
| 381 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 3 * 10 - 9), Point(9 * 10, 3 * 10))))); |
| 382 |
SELECT count(*) FROM t2; |
| 383 |
count(*) |
| 384 |
82 |
| 385 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 2 * 10 - 9), Point(9 * 10, 2 * 10))))); |
| 386 |
SELECT count(*) FROM t2; |
| 387 |
count(*) |
| 388 |
81 |
| 389 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(9 * 10 - 9, 1 * 10 - 9), Point(9 * 10, 1 * 10))))); |
| 390 |
SELECT count(*) FROM t2; |
| 391 |
count(*) |
| 392 |
80 |
| 393 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 10 * 10 - 9), Point(8 * 10, 10 * 10))))); |
| 394 |
SELECT count(*) FROM t2; |
| 395 |
count(*) |
| 396 |
79 |
| 397 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 9 * 10 - 9), Point(8 * 10, 9 * 10))))); |
| 398 |
SELECT count(*) FROM t2; |
| 399 |
count(*) |
| 400 |
78 |
| 401 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 8 * 10 - 9), Point(8 * 10, 8 * 10))))); |
| 402 |
SELECT count(*) FROM t2; |
| 403 |
count(*) |
| 404 |
77 |
| 405 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 7 * 10 - 9), Point(8 * 10, 7 * 10))))); |
| 406 |
SELECT count(*) FROM t2; |
| 407 |
count(*) |
| 408 |
76 |
| 409 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 6 * 10 - 9), Point(8 * 10, 6 * 10))))); |
| 410 |
SELECT count(*) FROM t2; |
| 411 |
count(*) |
| 412 |
75 |
| 413 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 5 * 10 - 9), Point(8 * 10, 5 * 10))))); |
| 414 |
SELECT count(*) FROM t2; |
| 415 |
count(*) |
| 416 |
74 |
| 417 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 4 * 10 - 9), Point(8 * 10, 4 * 10))))); |
| 418 |
SELECT count(*) FROM t2; |
| 419 |
count(*) |
| 420 |
73 |
| 421 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 3 * 10 - 9), Point(8 * 10, 3 * 10))))); |
| 422 |
SELECT count(*) FROM t2; |
| 423 |
count(*) |
| 424 |
72 |
| 425 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 2 * 10 - 9), Point(8 * 10, 2 * 10))))); |
| 426 |
SELECT count(*) FROM t2; |
| 427 |
count(*) |
| 428 |
71 |
| 429 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(8 * 10 - 9, 1 * 10 - 9), Point(8 * 10, 1 * 10))))); |
| 430 |
SELECT count(*) FROM t2; |
| 431 |
count(*) |
| 432 |
70 |
| 433 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 10 * 10 - 9), Point(7 * 10, 10 * 10))))); |
| 434 |
SELECT count(*) FROM t2; |
| 435 |
count(*) |
| 436 |
69 |
| 437 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 9 * 10 - 9), Point(7 * 10, 9 * 10))))); |
| 438 |
SELECT count(*) FROM t2; |
| 439 |
count(*) |
| 440 |
68 |
| 441 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 8 * 10 - 9), Point(7 * 10, 8 * 10))))); |
| 442 |
SELECT count(*) FROM t2; |
| 443 |
count(*) |
| 444 |
67 |
| 445 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 7 * 10 - 9), Point(7 * 10, 7 * 10))))); |
| 446 |
SELECT count(*) FROM t2; |
| 447 |
count(*) |
| 448 |
66 |
| 449 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 6 * 10 - 9), Point(7 * 10, 6 * 10))))); |
| 450 |
SELECT count(*) FROM t2; |
| 451 |
count(*) |
| 452 |
65 |
| 453 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 5 * 10 - 9), Point(7 * 10, 5 * 10))))); |
| 454 |
SELECT count(*) FROM t2; |
| 455 |
count(*) |
| 456 |
64 |
| 457 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 4 * 10 - 9), Point(7 * 10, 4 * 10))))); |
| 458 |
SELECT count(*) FROM t2; |
| 459 |
count(*) |
| 460 |
63 |
| 461 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 3 * 10 - 9), Point(7 * 10, 3 * 10))))); |
| 462 |
SELECT count(*) FROM t2; |
| 463 |
count(*) |
| 464 |
62 |
| 465 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 2 * 10 - 9), Point(7 * 10, 2 * 10))))); |
| 466 |
SELECT count(*) FROM t2; |
| 467 |
count(*) |
| 468 |
61 |
| 469 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(7 * 10 - 9, 1 * 10 - 9), Point(7 * 10, 1 * 10))))); |
| 470 |
SELECT count(*) FROM t2; |
| 471 |
count(*) |
| 472 |
60 |
| 473 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 10 * 10 - 9), Point(6 * 10, 10 * 10))))); |
| 474 |
SELECT count(*) FROM t2; |
| 475 |
count(*) |
| 476 |
59 |
| 477 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 9 * 10 - 9), Point(6 * 10, 9 * 10))))); |
| 478 |
SELECT count(*) FROM t2; |
| 479 |
count(*) |
| 480 |
58 |
| 481 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 8 * 10 - 9), Point(6 * 10, 8 * 10))))); |
| 482 |
SELECT count(*) FROM t2; |
| 483 |
count(*) |
| 484 |
57 |
| 485 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 7 * 10 - 9), Point(6 * 10, 7 * 10))))); |
| 486 |
SELECT count(*) FROM t2; |
| 487 |
count(*) |
| 488 |
56 |
| 489 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 6 * 10 - 9), Point(6 * 10, 6 * 10))))); |
| 490 |
SELECT count(*) FROM t2; |
| 491 |
count(*) |
| 492 |
55 |
| 493 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 5 * 10 - 9), Point(6 * 10, 5 * 10))))); |
| 494 |
SELECT count(*) FROM t2; |
| 495 |
count(*) |
| 496 |
54 |
| 497 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 4 * 10 - 9), Point(6 * 10, 4 * 10))))); |
| 498 |
SELECT count(*) FROM t2; |
| 499 |
count(*) |
| 500 |
53 |
| 501 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 3 * 10 - 9), Point(6 * 10, 3 * 10))))); |
| 502 |
SELECT count(*) FROM t2; |
| 503 |
count(*) |
| 504 |
52 |
| 505 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 2 * 10 - 9), Point(6 * 10, 2 * 10))))); |
| 506 |
SELECT count(*) FROM t2; |
| 507 |
count(*) |
| 508 |
51 |
| 509 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(6 * 10 - 9, 1 * 10 - 9), Point(6 * 10, 1 * 10))))); |
| 510 |
SELECT count(*) FROM t2; |
| 511 |
count(*) |
| 512 |
50 |
| 513 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 10 * 10 - 9), Point(5 * 10, 10 * 10))))); |
| 514 |
SELECT count(*) FROM t2; |
| 515 |
count(*) |
| 516 |
49 |
| 517 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 9 * 10 - 9), Point(5 * 10, 9 * 10))))); |
| 518 |
SELECT count(*) FROM t2; |
| 519 |
count(*) |
| 520 |
48 |
| 521 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 8 * 10 - 9), Point(5 * 10, 8 * 10))))); |
| 522 |
SELECT count(*) FROM t2; |
| 523 |
count(*) |
| 524 |
47 |
| 525 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 7 * 10 - 9), Point(5 * 10, 7 * 10))))); |
| 526 |
SELECT count(*) FROM t2; |
| 527 |
count(*) |
| 528 |
46 |
| 529 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 6 * 10 - 9), Point(5 * 10, 6 * 10))))); |
| 530 |
SELECT count(*) FROM t2; |
| 531 |
count(*) |
| 532 |
45 |
| 533 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 5 * 10 - 9), Point(5 * 10, 5 * 10))))); |
| 534 |
SELECT count(*) FROM t2; |
| 535 |
count(*) |
| 536 |
44 |
| 537 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 4 * 10 - 9), Point(5 * 10, 4 * 10))))); |
| 538 |
SELECT count(*) FROM t2; |
| 539 |
count(*) |
| 540 |
43 |
| 541 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 3 * 10 - 9), Point(5 * 10, 3 * 10))))); |
| 542 |
SELECT count(*) FROM t2; |
| 543 |
count(*) |
| 544 |
42 |
| 545 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 2 * 10 - 9), Point(5 * 10, 2 * 10))))); |
| 546 |
SELECT count(*) FROM t2; |
| 547 |
count(*) |
| 548 |
41 |
| 549 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(5 * 10 - 9, 1 * 10 - 9), Point(5 * 10, 1 * 10))))); |
| 550 |
SELECT count(*) FROM t2; |
| 551 |
count(*) |
| 552 |
40 |
| 553 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 10 * 10 - 9), Point(4 * 10, 10 * 10))))); |
| 554 |
SELECT count(*) FROM t2; |
| 555 |
count(*) |
| 556 |
39 |
| 557 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 9 * 10 - 9), Point(4 * 10, 9 * 10))))); |
| 558 |
SELECT count(*) FROM t2; |
| 559 |
count(*) |
| 560 |
38 |
| 561 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 8 * 10 - 9), Point(4 * 10, 8 * 10))))); |
| 562 |
SELECT count(*) FROM t2; |
| 563 |
count(*) |
| 564 |
37 |
| 565 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 7 * 10 - 9), Point(4 * 10, 7 * 10))))); |
| 566 |
SELECT count(*) FROM t2; |
| 567 |
count(*) |
| 568 |
36 |
| 569 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 6 * 10 - 9), Point(4 * 10, 6 * 10))))); |
| 570 |
SELECT count(*) FROM t2; |
| 571 |
count(*) |
| 572 |
35 |
| 573 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 5 * 10 - 9), Point(4 * 10, 5 * 10))))); |
| 574 |
SELECT count(*) FROM t2; |
| 575 |
count(*) |
| 576 |
34 |
| 577 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 4 * 10 - 9), Point(4 * 10, 4 * 10))))); |
| 578 |
SELECT count(*) FROM t2; |
| 579 |
count(*) |
| 580 |
33 |
| 581 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 3 * 10 - 9), Point(4 * 10, 3 * 10))))); |
| 582 |
SELECT count(*) FROM t2; |
| 583 |
count(*) |
| 584 |
32 |
| 585 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 2 * 10 - 9), Point(4 * 10, 2 * 10))))); |
| 586 |
SELECT count(*) FROM t2; |
| 587 |
count(*) |
| 588 |
31 |
| 589 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(4 * 10 - 9, 1 * 10 - 9), Point(4 * 10, 1 * 10))))); |
| 590 |
SELECT count(*) FROM t2; |
| 591 |
count(*) |
| 592 |
30 |
| 593 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 10 * 10 - 9), Point(3 * 10, 10 * 10))))); |
| 594 |
SELECT count(*) FROM t2; |
| 595 |
count(*) |
| 596 |
29 |
| 597 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 9 * 10 - 9), Point(3 * 10, 9 * 10))))); |
| 598 |
SELECT count(*) FROM t2; |
| 599 |
count(*) |
| 600 |
28 |
| 601 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 8 * 10 - 9), Point(3 * 10, 8 * 10))))); |
| 602 |
SELECT count(*) FROM t2; |
| 603 |
count(*) |
| 604 |
27 |
| 605 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 7 * 10 - 9), Point(3 * 10, 7 * 10))))); |
| 606 |
SELECT count(*) FROM t2; |
| 607 |
count(*) |
| 608 |
26 |
| 609 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 6 * 10 - 9), Point(3 * 10, 6 * 10))))); |
| 610 |
SELECT count(*) FROM t2; |
| 611 |
count(*) |
| 612 |
25 |
| 613 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 5 * 10 - 9), Point(3 * 10, 5 * 10))))); |
| 614 |
SELECT count(*) FROM t2; |
| 615 |
count(*) |
| 616 |
24 |
| 617 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 4 * 10 - 9), Point(3 * 10, 4 * 10))))); |
| 618 |
SELECT count(*) FROM t2; |
| 619 |
count(*) |
| 620 |
23 |
| 621 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 3 * 10 - 9), Point(3 * 10, 3 * 10))))); |
| 622 |
SELECT count(*) FROM t2; |
| 623 |
count(*) |
| 624 |
22 |
| 625 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 2 * 10 - 9), Point(3 * 10, 2 * 10))))); |
| 626 |
SELECT count(*) FROM t2; |
| 627 |
count(*) |
| 628 |
21 |
| 629 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(3 * 10 - 9, 1 * 10 - 9), Point(3 * 10, 1 * 10))))); |
| 630 |
SELECT count(*) FROM t2; |
| 631 |
count(*) |
| 632 |
20 |
| 633 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 10 * 10 - 9), Point(2 * 10, 10 * 10))))); |
| 634 |
SELECT count(*) FROM t2; |
| 635 |
count(*) |
| 636 |
19 |
| 637 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 9 * 10 - 9), Point(2 * 10, 9 * 10))))); |
| 638 |
SELECT count(*) FROM t2; |
| 639 |
count(*) |
| 640 |
18 |
| 641 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 8 * 10 - 9), Point(2 * 10, 8 * 10))))); |
| 642 |
SELECT count(*) FROM t2; |
| 643 |
count(*) |
| 644 |
17 |
| 645 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 7 * 10 - 9), Point(2 * 10, 7 * 10))))); |
| 646 |
SELECT count(*) FROM t2; |
| 647 |
count(*) |
| 648 |
16 |
| 649 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 6 * 10 - 9), Point(2 * 10, 6 * 10))))); |
| 650 |
SELECT count(*) FROM t2; |
| 651 |
count(*) |
| 652 |
15 |
| 653 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 5 * 10 - 9), Point(2 * 10, 5 * 10))))); |
| 654 |
SELECT count(*) FROM t2; |
| 655 |
count(*) |
| 656 |
14 |
| 657 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 4 * 10 - 9), Point(2 * 10, 4 * 10))))); |
| 658 |
SELECT count(*) FROM t2; |
| 659 |
count(*) |
| 660 |
13 |
| 661 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 3 * 10 - 9), Point(2 * 10, 3 * 10))))); |
| 662 |
SELECT count(*) FROM t2; |
| 663 |
count(*) |
| 664 |
12 |
| 665 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 2 * 10 - 9), Point(2 * 10, 2 * 10))))); |
| 666 |
SELECT count(*) FROM t2; |
| 667 |
count(*) |
| 668 |
11 |
| 669 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(2 * 10 - 9, 1 * 10 - 9), Point(2 * 10, 1 * 10))))); |
| 670 |
SELECT count(*) FROM t2; |
| 671 |
count(*) |
| 672 |
10 |
| 673 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 10 * 10 - 9), Point(1 * 10, 10 * 10))))); |
| 674 |
SELECT count(*) FROM t2; |
| 675 |
count(*) |
| 676 |
9 |
| 677 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 9 * 10 - 9), Point(1 * 10, 9 * 10))))); |
| 678 |
SELECT count(*) FROM t2; |
| 679 |
count(*) |
| 680 |
8 |
| 681 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 8 * 10 - 9), Point(1 * 10, 8 * 10))))); |
| 682 |
SELECT count(*) FROM t2; |
| 683 |
count(*) |
| 684 |
7 |
| 685 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 7 * 10 - 9), Point(1 * 10, 7 * 10))))); |
| 686 |
SELECT count(*) FROM t2; |
| 687 |
count(*) |
| 688 |
6 |
| 689 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 6 * 10 - 9), Point(1 * 10, 6 * 10))))); |
| 690 |
SELECT count(*) FROM t2; |
| 691 |
count(*) |
| 692 |
5 |
| 693 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 5 * 10 - 9), Point(1 * 10, 5 * 10))))); |
| 694 |
SELECT count(*) FROM t2; |
| 695 |
count(*) |
| 696 |
4 |
| 697 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 4 * 10 - 9), Point(1 * 10, 4 * 10))))); |
| 698 |
SELECT count(*) FROM t2; |
| 699 |
count(*) |
| 700 |
3 |
| 701 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 3 * 10 - 9), Point(1 * 10, 3 * 10))))); |
| 702 |
SELECT count(*) FROM t2; |
| 703 |
count(*) |
| 704 |
2 |
| 705 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 2 * 10 - 9), Point(1 * 10, 2 * 10))))); |
| 706 |
SELECT count(*) FROM t2; |
| 707 |
count(*) |
| 708 |
1 |
| 709 |
DELETE FROM t2 WHERE Within(g, Envelope(GeometryFromWKB(LineString(Point(1 * 10 - 9, 1 * 10 - 9), Point(1 * 10, 1 * 10))))); |
| 710 |
SELECT count(*) FROM t2; |
| 711 |
count(*) |
| 712 |
0 |
| 713 |
DROP TABLE t2; |
| 714 |
drop table if exists t1; |
| 715 |
Warnings: |
| 716 |
Note 1051 Unknown table 'test.t1' |
| 717 |
CREATE TABLE t1 (a geometry NOT NULL, SPATIAL (a)) transactional=1 row_format=page; |
| 718 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 719 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 720 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 721 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 722 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 723 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 724 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 725 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 726 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 727 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 728 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 729 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 730 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 731 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 732 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 733 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 734 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 735 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 736 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 737 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 738 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 739 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 740 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 741 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 742 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 743 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 744 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 745 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 746 |
INSERT INTO t1 VALUES (GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 747 |
check table t1; |
| 748 |
Table Op Msg_type Msg_text |
| 749 |
test.t1 check status OK |
| 750 |
analyze table t1; |
| 751 |
Table Op Msg_type Msg_text |
| 752 |
test.t1 analyze status Engine-independent statistics collected |
| 753 |
test.t1 analyze status OK |
| 754 |
drop table t1; |
| 755 |
CREATE TABLE t1 ( |
| 756 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 757 |
g GEOMETRY NOT NULL, |
| 758 |
SPATIAL KEY(g) |
| 759 |
) transactional=1 row_format=page; |
| 760 |
INSERT INTO t1 (g) VALUES (GeomFromText('LineString(1 2, 2 3)')),(GeomFromText('LineString(1 2, 2 4)')); |
| 761 |
drop table t1; |
| 762 |
CREATE TABLE t1 ( |
| 763 |
line LINESTRING NOT NULL, |
| 764 |
kind ENUM('po', 'pp', 'rr', 'dr', 'rd', 'ts', 'cl') NOT NULL DEFAULT 'po', |
| 765 |
name VARCHAR(32), |
| 766 |
SPATIAL KEY (line) |
| 767 |
) transactional=1 row_format=page; |
| 768 |
ALTER TABLE t1 DISABLE KEYS; |
| 769 |
INSERT INTO t1 (name, kind, line) VALUES |
| 770 |
("Aadaouane", "pp", GeomFromText("LINESTRING(32.816667 35.983333)")), |
| 771 |
("Aadassiye", "pp", GeomFromText("LINESTRING(35.816667 36.216667)")), |
| 772 |
("Aadbel", "pp", GeomFromText("LINESTRING(34.533333 36.100000)")), |
| 773 |
("Aadchit", "pp", GeomFromText("LINESTRING(33.347222 35.423611)")), |
| 774 |
("Aadchite", "pp", GeomFromText("LINESTRING(33.347222 35.423611)")), |
| 775 |
("Aadchit el Qoussair", "pp", GeomFromText("LINESTRING(33.283333 35.483333)")), |
| 776 |
("Aaddaye", "pp", GeomFromText("LINESTRING(36.716667 40.833333)")), |
| 777 |
("'Aadeissa", "pp", GeomFromText("LINESTRING(32.823889 35.698889)")), |
| 778 |
("Aaderup", "pp", GeomFromText("LINESTRING(55.216667 11.766667)")), |
| 779 |
("Qalaat Aades", "pp", GeomFromText("LINESTRING(33.503333 35.377500)")), |
| 780 |
("A ad'ino", "pp", GeomFromText("LINESTRING(54.812222 38.209167)")), |
| 781 |
("Aadi Noia", "pp", GeomFromText("LINESTRING(13.800000 39.833333)")), |
| 782 |
("Aad La Macta", "pp", GeomFromText("LINESTRING(35.779444 -0.129167)")), |
| 783 |
("Aadland", "pp", GeomFromText("LINESTRING(60.366667 5.483333)")), |
| 784 |
("Aadliye", "pp", GeomFromText("LINESTRING(33.366667 36.333333)")), |
| 785 |
("Aadloun", "pp", GeomFromText("LINESTRING(33.403889 35.273889)")), |
| 786 |
("Aadma", "pp", GeomFromText("LINESTRING(58.798333 22.663889)")), |
| 787 |
("Aadma Asundus", "pp", GeomFromText("LINESTRING(58.798333 22.663889)")), |
| 788 |
("Aadmoun", "pp", GeomFromText("LINESTRING(34.150000 35.650000)")), |
| 789 |
("Aadneram", "pp", GeomFromText("LINESTRING(59.016667 6.933333)")), |
| 790 |
("Aadneskaar", "pp", GeomFromText("LINESTRING(58.083333 6.983333)")), |
| 791 |
("Aadorf", "pp", GeomFromText("LINESTRING(47.483333 8.900000)")), |
| 792 |
("Aadorp", "pp", GeomFromText("LINESTRING(52.366667 6.633333)")), |
| 793 |
("Aadouane", "pp", GeomFromText("LINESTRING(32.816667 35.983333)")), |
| 794 |
("Aadoui", "pp", GeomFromText("LINESTRING(34.450000 35.983333)")), |
| 795 |
("Aadouiye", "pp", GeomFromText("LINESTRING(34.583333 36.183333)")), |
| 796 |
("Aadouss", "pp", GeomFromText("LINESTRING(33.512500 35.601389)")), |
| 797 |
("Aadra", "pp", GeomFromText("LINESTRING(33.616667 36.500000)")), |
| 798 |
("Aadzi", "pp", GeomFromText("LINESTRING(38.100000 64.850000)")); |
| 799 |
ALTER TABLE t1 ENABLE KEYS; |
| 800 |
INSERT INTO t1 (name, kind, line) VALUES ("austria", "pp", GeomFromText('LINESTRING(14.9906 48.9887,14.9946 48.9904,14.9947 48.9916)')); |
| 801 |
drop table t1; |
| 802 |
CREATE TABLE t1 (st varchar(100)); |
| 803 |
INSERT INTO t1 VALUES ("Fake string"); |
| 804 |
CREATE TABLE t2 (geom GEOMETRY NOT NULL, SPATIAL KEY gk(geom)) transactional=1 row_format=page; |
| 805 |
INSERT IGNORE INTO t2 SELECT GeomFromText(st) FROM t1; |
| 806 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 807 |
drop table t1, t2; |
| 808 |
CREATE TABLE t1 (`geometry` geometry NOT NULL,SPATIAL KEY `gndx` (`geometry`)) transactional=1 row_format=page DEFAULT CHARSET=latin1; |
| 809 |
INSERT INTO t1 (geometry) VALUES |
| 810 |
(PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, -18.6055555000 |
| 811 |
-66.8158332999, -18.7186111000 -66.8102777000, -18.7211111000 -66.9269443999, |
| 812 |
-18.6086111000 -66.9327777000))')); |
| 813 |
INSERT INTO t1 (geometry) VALUES |
| 814 |
(PolygonFromText('POLYGON((-65.7402776999 -96.6686111000, -65.7372222000 |
| 815 |
-96.5516666000, -65.8502777000 -96.5461111000, -65.8527777000 -96.6627777000, |
| 816 |
-65.7402776999 -96.6686111000))')); |
| 817 |
check table t1 extended; |
| 818 |
Table Op Msg_type Msg_text |
| 819 |
test.t1 check status OK |
| 820 |
drop table t1; |
| 821 |
CREATE TABLE t1 ( |
| 822 |
c1 geometry NOT NULL, |
| 823 |
SPATIAL KEY i1 (c1) |
| 824 |
) transactional=1 row_format=page DEFAULT CHARSET=latin1; |
| 825 |
INSERT INTO t1 (c1) VALUES ( |
| 826 |
PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 827 |
-18.6055555000 -66.8158332999, |
| 828 |
-18.7186111000 -66.8102777000, |
| 829 |
-18.7211111000 -66.9269443999, |
| 830 |
-18.6086111000 -66.9327777000))')); |
| 831 |
CHECK TABLE t1 EXTENDED; |
| 832 |
Table Op Msg_type Msg_text |
| 833 |
test.t1 check status OK |
| 834 |
DROP TABLE t1; |
| 835 |
CREATE TABLE t1 ( |
| 836 |
c1 geometry NOT NULL, |
| 837 |
SPATIAL KEY i1 (c1) |
| 838 |
) transactional=1 row_format=page DEFAULT CHARSET=latin1; |
| 839 |
INSERT INTO t1 (c1) VALUES ( |
| 840 |
PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 841 |
-18.6055555000 -66.8158332999, |
| 842 |
-18.7186111000 -66.8102777000, |
| 843 |
-18.7211111000 -66.9269443999, |
| 844 |
-18.6086111000 -66.9327777000))')); |
| 845 |
INSERT INTO t1 (c1) VALUES ( |
| 846 |
PolygonFromText('POLYGON((-65.7402776999 -96.6686111000, |
| 847 |
-65.7372222000 -96.5516666000, |
| 848 |
-65.8502777000 -96.5461111000, |
| 849 |
-65.8527777000 -96.6627777000, |
| 850 |
-65.7402776999 -96.6686111000))')); |
| 851 |
INSERT INTO t1 (c1) VALUES ( |
| 852 |
PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 853 |
-18.6055555000 -66.8158332999, |
| 854 |
-18.7186111000 -66.8102777000, |
| 855 |
-18.7211111000 -66.9269443999, |
| 856 |
-18.6086111000 -66.9327777000))')); |
| 857 |
CHECK TABLE t1 EXTENDED; |
| 858 |
Table Op Msg_type Msg_text |
| 859 |
test.t1 check status OK |
| 860 |
DROP TABLE t1; |
| 861 |
CREATE TABLE t1 (foo GEOMETRY NOT NULL, SPATIAL INDEX(foo) ) transactional=1 row_format=page; |
| 862 |
INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(1,1))); |
| 863 |
INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(1,0))); |
| 864 |
INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(0,1))); |
| 865 |
INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(0,0))); |
| 866 |
SELECT 1 FROM t1 WHERE foo != PointFromWKB(POINT(0,0)); |
| 867 |
1 |
| 868 |
1 |
| 869 |
1 |
| 870 |
1 |
| 871 |
DROP TABLE t1; |
| 872 |
CREATE TABLE t1 (id bigint(12) unsigned NOT NULL auto_increment, |
| 873 |
c2 varchar(15) collate utf8_bin default NULL, |
| 874 |
c1 varchar(15) collate utf8_bin default NULL, |
| 875 |
c3 varchar(10) collate utf8_bin default NULL, |
| 876 |
spatial_point point NOT NULL, |
| 877 |
PRIMARY KEY(id), |
| 878 |
SPATIAL KEY (spatial_point) |
| 879 |
)transactional=1 row_format=page DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 880 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 881 |
('y', 's', 'j', GeomFromText('POINT(167 74)')), |
| 882 |
('r', 'n', 'd', GeomFromText('POINT(215 118)')), |
| 883 |
('g', 'n', 'e', GeomFromText('POINT(203 98)')), |
| 884 |
('h', 'd', 'd', GeomFromText('POINT(54 193)')), |
| 885 |
('r', 'x', 'y', GeomFromText('POINT(47 69)')), |
| 886 |
('t', 'q', 'r', GeomFromText('POINT(109 42)')), |
| 887 |
('a', 'z', 'd', GeomFromText('POINT(0 154)')), |
| 888 |
('x', 'v', 'o', GeomFromText('POINT(174 131)')), |
| 889 |
('b', 'r', 'a', GeomFromText('POINT(114 253)')), |
| 890 |
('x', 'z', 'i', GeomFromText('POINT(163 21)')), |
| 891 |
('w', 'p', 'i', GeomFromText('POINT(42 102)')), |
| 892 |
('g', 'j', 'j', GeomFromText('POINT(170 133)')), |
| 893 |
('m', 'g', 'n', GeomFromText('POINT(28 22)')), |
| 894 |
('b', 'z', 'h', GeomFromText('POINT(174 28)')), |
| 895 |
('q', 'k', 'f', GeomFromText('POINT(233 73)')), |
| 896 |
('w', 'w', 'a', GeomFromText('POINT(124 200)')), |
| 897 |
('t', 'j', 'w', GeomFromText('POINT(252 101)')), |
| 898 |
('d', 'r', 'd', GeomFromText('POINT(98 18)')), |
| 899 |
('w', 'o', 'y', GeomFromText('POINT(165 31)')), |
| 900 |
('y', 'h', 't', GeomFromText('POINT(14 220)')), |
| 901 |
('d', 'p', 'u', GeomFromText('POINT(223 196)')), |
| 902 |
('g', 'y', 'g', GeomFromText('POINT(207 96)')), |
| 903 |
('x', 'm', 'n', GeomFromText('POINT(214 3)')), |
| 904 |
('g', 'v', 'e', GeomFromText('POINT(140 205)')), |
| 905 |
('g', 'm', 'm', GeomFromText('POINT(10 236)')), |
| 906 |
('i', 'r', 'j', GeomFromText('POINT(137 228)')), |
| 907 |
('w', 's', 'p', GeomFromText('POINT(115 6)')), |
| 908 |
('o', 'n', 'k', GeomFromText('POINT(158 129)')), |
| 909 |
('j', 'h', 'l', GeomFromText('POINT(129 72)')), |
| 910 |
('f', 'x', 'l', GeomFromText('POINT(139 207)')), |
| 911 |
('u', 'd', 'n', GeomFromText('POINT(125 109)')), |
| 912 |
('b', 'a', 'z', GeomFromText('POINT(30 32)')), |
| 913 |
('m', 'h', 'o', GeomFromText('POINT(251 251)')), |
| 914 |
('f', 'r', 'd', GeomFromText('POINT(243 211)')), |
| 915 |
('b', 'd', 'r', GeomFromText('POINT(232 80)')), |
| 916 |
('g', 'k', 'v', GeomFromText('POINT(15 100)')), |
| 917 |
('i', 'f', 'c', GeomFromText('POINT(109 66)')), |
| 918 |
('r', 't', 'j', GeomFromText('POINT(178 6)')), |
| 919 |
('y', 'n', 'f', GeomFromText('POINT(233 211)')), |
| 920 |
('f', 'y', 'm', GeomFromText('POINT(99 16)')), |
| 921 |
('z', 'q', 'l', GeomFromText('POINT(39 49)')), |
| 922 |
('j', 'c', 'r', GeomFromText('POINT(75 187)')), |
| 923 |
('c', 'y', 'y', GeomFromText('POINT(246 253)')), |
| 924 |
('w', 'u', 'd', GeomFromText('POINT(56 190)')), |
| 925 |
('n', 'q', 'm', GeomFromText('POINT(73 149)')), |
| 926 |
('d', 'y', 'a', GeomFromText('POINT(134 6)')), |
| 927 |
('z', 's', 'w', GeomFromText('POINT(216 225)')), |
| 928 |
('d', 'u', 'k', GeomFromText('POINT(132 70)')), |
| 929 |
('f', 'v', 't', GeomFromText('POINT(187 141)')), |
| 930 |
('r', 'r', 'a', GeomFromText('POINT(152 39)')), |
| 931 |
('y', 'p', 'o', GeomFromText('POINT(45 27)')), |
| 932 |
('p', 'n', 'm', GeomFromText('POINT(228 148)')), |
| 933 |
('e', 'g', 'e', GeomFromText('POINT(88 81)')), |
| 934 |
('m', 'a', 'h', GeomFromText('POINT(35 29)')), |
| 935 |
('m', 'h', 'f', GeomFromText('POINT(30 71)')), |
| 936 |
('h', 'k', 'i', GeomFromText('POINT(244 78)')), |
| 937 |
('z', 'v', 'd', GeomFromText('POINT(241 38)')), |
| 938 |
('q', 'l', 'j', GeomFromText('POINT(13 71)')), |
| 939 |
('s', 'p', 'g', GeomFromText('POINT(108 38)')), |
| 940 |
('q', 's', 'j', GeomFromText('POINT(92 101)')), |
| 941 |
('l', 'h', 'g', GeomFromText('POINT(120 78)')), |
| 942 |
('w', 't', 'b', GeomFromText('POINT(193 109)')), |
| 943 |
('b', 's', 's', GeomFromText('POINT(223 211)')), |
| 944 |
('w', 'w', 'y', GeomFromText('POINT(122 42)')), |
| 945 |
('q', 'c', 'c', GeomFromText('POINT(104 102)')), |
| 946 |
('w', 'g', 'n', GeomFromText('POINT(213 120)')), |
| 947 |
('p', 'q', 'a', GeomFromText('POINT(247 148)')), |
| 948 |
('c', 'z', 'e', GeomFromText('POINT(18 106)')), |
| 949 |
('z', 'u', 'n', GeomFromText('POINT(70 133)')), |
| 950 |
('j', 'n', 'x', GeomFromText('POINT(232 13)')), |
| 951 |
('e', 'h', 'f', GeomFromText('POINT(22 135)')), |
| 952 |
('w', 'l', 'f', GeomFromText('POINT(9 180)')), |
| 953 |
('a', 'v', 'q', GeomFromText('POINT(163 228)')), |
| 954 |
('i', 'z', 'o', GeomFromText('POINT(180 100)')), |
| 955 |
('e', 'c', 'l', GeomFromText('POINT(182 231)')), |
| 956 |
('c', 'k', 'o', GeomFromText('POINT(19 60)')), |
| 957 |
('q', 'f', 'p', GeomFromText('POINT(79 95)')), |
| 958 |
('m', 'd', 'r', GeomFromText('POINT(3 127)')), |
| 959 |
('m', 'e', 't', GeomFromText('POINT(136 154)')), |
| 960 |
('w', 'w', 'w', GeomFromText('POINT(102 15)')), |
| 961 |
('l', 'n', 'q', GeomFromText('POINT(71 196)')), |
| 962 |
('p', 'k', 'c', GeomFromText('POINT(47 139)')), |
| 963 |
('j', 'o', 'r', GeomFromText('POINT(177 128)')), |
| 964 |
('j', 'q', 'a', GeomFromText('POINT(170 6)')), |
| 965 |
('b', 'a', 'o', GeomFromText('POINT(63 211)')), |
| 966 |
('g', 's', 'o', GeomFromText('POINT(144 251)')), |
| 967 |
('w', 'u', 'w', GeomFromText('POINT(221 214)')), |
| 968 |
('g', 'a', 'm', GeomFromText('POINT(14 102)')), |
| 969 |
('u', 'q', 'z', GeomFromText('POINT(86 200)')), |
| 970 |
('k', 'a', 'm', GeomFromText('POINT(144 222)')), |
| 971 |
('j', 'u', 'r', GeomFromText('POINT(216 142)')), |
| 972 |
('q', 'k', 'v', GeomFromText('POINT(121 236)')), |
| 973 |
('p', 'o', 'r', GeomFromText('POINT(108 102)')), |
| 974 |
('b', 'd', 'x', GeomFromText('POINT(127 198)')), |
| 975 |
('k', 's', 'a', GeomFromText('POINT(2 150)')), |
| 976 |
('f', 'm', 'f', GeomFromText('POINT(160 191)')), |
| 977 |
('q', 'y', 'x', GeomFromText('POINT(98 111)')), |
| 978 |
('o', 'f', 'm', GeomFromText('POINT(232 218)')), |
| 979 |
('c', 'w', 'j', GeomFromText('POINT(156 165)')), |
| 980 |
('s', 'q', 'v', GeomFromText('POINT(98 161)')); |
| 981 |
SET @@RAND_SEED1=692635050, @@RAND_SEED2=297339954; |
| 982 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 983 |
SET @@RAND_SEED1=159925977, @@RAND_SEED2=942570618; |
| 984 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 985 |
SET @@RAND_SEED1=328169745, @@RAND_SEED2=410451954; |
| 986 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 987 |
SET @@RAND_SEED1=178507359, @@RAND_SEED2=332493072; |
| 988 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 989 |
SET @@RAND_SEED1=1034033013, @@RAND_SEED2=558966507; |
| 990 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 991 |
UPDATE t1 set spatial_point=GeomFromText('POINT(230 9)') where c1 like 'y%'; |
| 992 |
UPDATE t1 set spatial_point=GeomFromText('POINT(95 35)') where c1 like 'j%'; |
| 993 |
UPDATE t1 set spatial_point=GeomFromText('POINT(93 99)') where c1 like 'a%'; |
| 994 |
UPDATE t1 set spatial_point=GeomFromText('POINT(19 81)') where c1 like 'r%'; |
| 995 |
UPDATE t1 set spatial_point=GeomFromText('POINT(20 177)') where c1 like 'h%'; |
| 996 |
UPDATE t1 set spatial_point=GeomFromText('POINT(221 193)') where c1 like 'u%'; |
| 997 |
UPDATE t1 set spatial_point=GeomFromText('POINT(195 205)') where c1 like 'd%'; |
| 998 |
UPDATE t1 set spatial_point=GeomFromText('POINT(15 213)') where c1 like 'u%'; |
| 999 |
UPDATE t1 set spatial_point=GeomFromText('POINT(214 63)') where c1 like 'n%'; |
| 1000 |
UPDATE t1 set spatial_point=GeomFromText('POINT(243 171)') where c1 like 'c%'; |
| 1001 |
UPDATE t1 set spatial_point=GeomFromText('POINT(198 82)') where c1 like 'y%'; |
| 1002 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 1003 |
('f', 'y', 'p', GeomFromText('POINT(109 235)')), |
| 1004 |
('b', 'e', 'v', GeomFromText('POINT(20 48)')), |
| 1005 |
('i', 'u', 'f', GeomFromText('POINT(15 55)')), |
| 1006 |
('o', 'r', 'z', GeomFromText('POINT(105 64)')), |
| 1007 |
('a', 'p', 'a', GeomFromText('POINT(142 236)')), |
| 1008 |
('g', 'i', 'k', GeomFromText('POINT(10 49)')), |
| 1009 |
('x', 'z', 'x', GeomFromText('POINT(192 200)')), |
| 1010 |
('c', 'v', 'r', GeomFromText('POINT(94 168)')), |
| 1011 |
('y', 'z', 'e', GeomFromText('POINT(141 51)')), |
| 1012 |
('h', 'm', 'd', GeomFromText('POINT(35 251)')), |
| 1013 |
('v', 'm', 'q', GeomFromText('POINT(44 90)')), |
| 1014 |
('j', 'l', 'z', GeomFromText('POINT(67 237)')), |
| 1015 |
('i', 'v', 'a', GeomFromText('POINT(75 14)')), |
| 1016 |
('b', 'q', 't', GeomFromText('POINT(153 33)')), |
| 1017 |
('e', 'm', 'a', GeomFromText('POINT(247 49)')), |
| 1018 |
('l', 'y', 'g', GeomFromText('POINT(56 203)')), |
| 1019 |
('v', 'o', 'r', GeomFromText('POINT(90 54)')), |
| 1020 |
('r', 'n', 'd', GeomFromText('POINT(135 83)')), |
| 1021 |
('j', 't', 'u', GeomFromText('POINT(174 239)')), |
| 1022 |
('u', 'n', 'g', GeomFromText('POINT(104 191)')), |
| 1023 |
('p', 'q', 'y', GeomFromText('POINT(63 171)')), |
| 1024 |
('o', 'q', 'p', GeomFromText('POINT(192 103)')), |
| 1025 |
('f', 'x', 'e', GeomFromText('POINT(244 30)')), |
| 1026 |
('n', 'x', 'c', GeomFromText('POINT(92 103)')), |
| 1027 |
('r', 'q', 'z', GeomFromText('POINT(166 20)')), |
| 1028 |
('s', 'a', 'j', GeomFromText('POINT(137 205)')), |
| 1029 |
('z', 't', 't', GeomFromText('POINT(99 134)')), |
| 1030 |
('o', 'm', 'j', GeomFromText('POINT(217 3)')), |
| 1031 |
('n', 'h', 'j', GeomFromText('POINT(211 17)')), |
| 1032 |
('v', 'v', 'a', GeomFromText('POINT(41 137)')), |
| 1033 |
('q', 'o', 'j', GeomFromText('POINT(5 92)')), |
| 1034 |
('z', 'y', 'e', GeomFromText('POINT(175 212)')), |
| 1035 |
('j', 'z', 'h', GeomFromText('POINT(224 194)')), |
| 1036 |
('a', 'g', 'm', GeomFromText('POINT(31 119)')), |
| 1037 |
('p', 'c', 'f', GeomFromText('POINT(17 221)')), |
| 1038 |
('t', 'h', 'k', GeomFromText('POINT(26 203)')), |
| 1039 |
('u', 'w', 'p', GeomFromText('POINT(47 185)')), |
| 1040 |
('z', 'a', 'c', GeomFromText('POINT(61 133)')), |
| 1041 |
('u', 'k', 'a', GeomFromText('POINT(210 115)')), |
| 1042 |
('k', 'f', 'h', GeomFromText('POINT(125 113)')), |
| 1043 |
('t', 'v', 'y', GeomFromText('POINT(12 239)')), |
| 1044 |
('u', 'v', 'd', GeomFromText('POINT(90 24)')), |
| 1045 |
('m', 'y', 'w', GeomFromText('POINT(25 243)')), |
| 1046 |
('d', 'n', 'g', GeomFromText('POINT(122 92)')), |
| 1047 |
('z', 'm', 'f', GeomFromText('POINT(235 110)')), |
| 1048 |
('q', 'd', 'f', GeomFromText('POINT(233 217)')), |
| 1049 |
('a', 'v', 'u', GeomFromText('POINT(69 59)')), |
| 1050 |
('x', 'k', 'p', GeomFromText('POINT(240 14)')), |
| 1051 |
('i', 'v', 'r', GeomFromText('POINT(154 42)')), |
| 1052 |
('w', 'h', 'l', GeomFromText('POINT(178 156)')), |
| 1053 |
('d', 'h', 'n', GeomFromText('POINT(65 157)')), |
| 1054 |
('c', 'k', 'z', GeomFromText('POINT(62 33)')), |
| 1055 |
('e', 'l', 'w', GeomFromText('POINT(162 1)')), |
| 1056 |
('r', 'f', 'i', GeomFromText('POINT(127 71)')), |
| 1057 |
('q', 'm', 'c', GeomFromText('POINT(63 118)')), |
| 1058 |
('c', 'h', 'u', GeomFromText('POINT(205 203)')), |
| 1059 |
('d', 't', 'p', GeomFromText('POINT(234 87)')), |
| 1060 |
('s', 'g', 'h', GeomFromText('POINT(149 34)')), |
| 1061 |
('o', 'b', 'q', GeomFromText('POINT(159 179)')), |
| 1062 |
('k', 'u', 'f', GeomFromText('POINT(202 254)')), |
| 1063 |
('u', 'f', 'g', GeomFromText('POINT(70 15)')), |
| 1064 |
('x', 's', 'b', GeomFromText('POINT(25 181)')), |
| 1065 |
('s', 'c', 'g', GeomFromText('POINT(252 17)')), |
| 1066 |
('a', 'c', 'f', GeomFromText('POINT(89 67)')), |
| 1067 |
('r', 'e', 'q', GeomFromText('POINT(55 54)')), |
| 1068 |
('f', 'i', 'k', GeomFromText('POINT(178 230)')), |
| 1069 |
('p', 'e', 'l', GeomFromText('POINT(198 28)')), |
| 1070 |
('w', 'o', 'd', GeomFromText('POINT(204 189)')), |
| 1071 |
('c', 'a', 'g', GeomFromText('POINT(230 178)')), |
| 1072 |
('r', 'o', 'e', GeomFromText('POINT(61 116)')), |
| 1073 |
('w', 'a', 'a', GeomFromText('POINT(178 237)')), |
| 1074 |
('v', 'd', 'e', GeomFromText('POINT(70 85)')), |
| 1075 |
('k', 'c', 'e', GeomFromText('POINT(147 118)')), |
| 1076 |
('d', 'q', 't', GeomFromText('POINT(218 77)')), |
| 1077 |
('k', 'g', 'f', GeomFromText('POINT(192 113)')), |
| 1078 |
('w', 'n', 'e', GeomFromText('POINT(92 124)')), |
| 1079 |
('r', 'm', 'q', GeomFromText('POINT(130 65)')), |
| 1080 |
('o', 'r', 'r', GeomFromText('POINT(174 233)')), |
| 1081 |
('k', 'n', 't', GeomFromText('POINT(175 147)')), |
| 1082 |
('q', 'm', 'r', GeomFromText('POINT(18 208)')), |
| 1083 |
('l', 'd', 'i', GeomFromText('POINT(13 104)')), |
| 1084 |
('w', 'o', 'y', GeomFromText('POINT(207 39)')), |
| 1085 |
('p', 'u', 'o', GeomFromText('POINT(114 31)')), |
| 1086 |
('y', 'a', 'p', GeomFromText('POINT(106 59)')), |
| 1087 |
('a', 'x', 'z', GeomFromText('POINT(17 57)')), |
| 1088 |
('v', 'h', 'x', GeomFromText('POINT(170 13)')), |
| 1089 |
('t', 's', 'u', GeomFromText('POINT(84 18)')), |
| 1090 |
('z', 'z', 'f', GeomFromText('POINT(250 197)')), |
| 1091 |
('l', 'z', 't', GeomFromText('POINT(59 80)')), |
| 1092 |
('j', 'g', 's', GeomFromText('POINT(54 26)')), |
| 1093 |
('g', 'v', 'm', GeomFromText('POINT(89 98)')), |
| 1094 |
('q', 'v', 'b', GeomFromText('POINT(39 240)')), |
| 1095 |
('x', 'k', 'v', GeomFromText('POINT(246 207)')), |
| 1096 |
('k', 'u', 'i', GeomFromText('POINT(105 111)')), |
| 1097 |
('w', 'z', 's', GeomFromText('POINT(235 8)')), |
| 1098 |
('d', 'd', 'd', GeomFromText('POINT(105 4)')), |
| 1099 |
('c', 'z', 'q', GeomFromText('POINT(13 140)')), |
| 1100 |
('m', 'k', 'i', GeomFromText('POINT(208 120)')), |
| 1101 |
('g', 'a', 'g', GeomFromText('POINT(9 182)')), |
| 1102 |
('z', 'j', 'r', GeomFromText('POINT(149 153)')), |
| 1103 |
('h', 'f', 'g', GeomFromText('POINT(81 236)')), |
| 1104 |
('m', 'e', 'q', GeomFromText('POINT(209 215)')), |
| 1105 |
('c', 'h', 'y', GeomFromText('POINT(235 70)')), |
| 1106 |
('i', 'e', 'g', GeomFromText('POINT(138 26)')), |
| 1107 |
('m', 't', 'u', GeomFromText('POINT(119 237)')), |
| 1108 |
('o', 'w', 's', GeomFromText('POINT(193 166)')), |
| 1109 |
('f', 'm', 'q', GeomFromText('POINT(85 96)')), |
| 1110 |
('x', 'l', 'x', GeomFromText('POINT(58 115)')), |
| 1111 |
('x', 'q', 'u', GeomFromText('POINT(108 210)')), |
| 1112 |
('b', 'h', 'i', GeomFromText('POINT(250 139)')), |
| 1113 |
('y', 'd', 'x', GeomFromText('POINT(199 135)')), |
| 1114 |
('w', 'h', 'p', GeomFromText('POINT(247 233)')), |
| 1115 |
('p', 'z', 't', GeomFromText('POINT(148 249)')), |
| 1116 |
('q', 'a', 'u', GeomFromText('POINT(174 78)')), |
| 1117 |
('v', 't', 'm', GeomFromText('POINT(70 228)')), |
| 1118 |
('t', 'n', 'f', GeomFromText('POINT(123 2)')), |
| 1119 |
('x', 't', 'b', GeomFromText('POINT(35 50)')), |
| 1120 |
('r', 'j', 'f', GeomFromText('POINT(200 51)')), |
| 1121 |
('s', 'q', 'o', GeomFromText('POINT(23 184)')), |
| 1122 |
('u', 'v', 'z', GeomFromText('POINT(7 113)')), |
| 1123 |
('v', 'u', 'l', GeomFromText('POINT(145 190)')), |
| 1124 |
('o', 'k', 'i', GeomFromText('POINT(161 122)')), |
| 1125 |
('l', 'y', 'e', GeomFromText('POINT(17 232)')), |
| 1126 |
('t', 'b', 'e', GeomFromText('POINT(120 50)')), |
| 1127 |
('e', 's', 'u', GeomFromText('POINT(254 1)')), |
| 1128 |
('d', 'd', 'u', GeomFromText('POINT(167 140)')), |
| 1129 |
('o', 'b', 'x', GeomFromText('POINT(186 237)')), |
| 1130 |
('m', 's', 's', GeomFromText('POINT(172 149)')), |
| 1131 |
('t', 'y', 'a', GeomFromText('POINT(149 85)')), |
| 1132 |
('x', 't', 'r', GeomFromText('POINT(10 165)')), |
| 1133 |
('g', 'c', 'e', GeomFromText('POINT(95 165)')), |
| 1134 |
('e', 'e', 'z', GeomFromText('POINT(98 65)')), |
| 1135 |
('f', 'v', 'i', GeomFromText('POINT(149 144)')), |
| 1136 |
('o', 'p', 'm', GeomFromText('POINT(233 67)')), |
| 1137 |
('t', 'u', 'b', GeomFromText('POINT(109 215)')), |
| 1138 |
('o', 'o', 'b', GeomFromText('POINT(130 48)')), |
| 1139 |
('e', 'm', 'h', GeomFromText('POINT(88 189)')), |
| 1140 |
('e', 'v', 'y', GeomFromText('POINT(55 29)')), |
| 1141 |
('e', 't', 'm', GeomFromText('POINT(129 55)')), |
| 1142 |
('p', 'p', 'i', GeomFromText('POINT(126 222)')), |
| 1143 |
('c', 'i', 'c', GeomFromText('POINT(19 158)')), |
| 1144 |
('c', 'b', 's', GeomFromText('POINT(13 19)')), |
| 1145 |
('u', 'y', 'a', GeomFromText('POINT(114 5)')), |
| 1146 |
('a', 'o', 'f', GeomFromText('POINT(227 232)')), |
| 1147 |
('t', 'c', 'z', GeomFromText('POINT(63 62)')), |
| 1148 |
('d', 'o', 'k', GeomFromText('POINT(48 228)')), |
| 1149 |
('x', 'c', 'e', GeomFromText('POINT(204 2)')), |
| 1150 |
('e', 'e', 'g', GeomFromText('POINT(125 43)')), |
| 1151 |
('o', 'r', 'f', GeomFromText('POINT(171 140)')); |
| 1152 |
UPDATE t1 set spatial_point=GeomFromText('POINT(163 157)') where c1 like 'w%'; |
| 1153 |
UPDATE t1 set spatial_point=GeomFromText('POINT(53 151)') where c1 like 'd%'; |
| 1154 |
UPDATE t1 set spatial_point=GeomFromText('POINT(96 183)') where c1 like 'r%'; |
| 1155 |
UPDATE t1 set spatial_point=GeomFromText('POINT(57 91)') where c1 like 'q%'; |
| 1156 |
UPDATE t1 set spatial_point=GeomFromText('POINT(202 110)') where c1 like 'c%'; |
| 1157 |
UPDATE t1 set spatial_point=GeomFromText('POINT(120 137)') where c1 like 'w%'; |
| 1158 |
UPDATE t1 set spatial_point=GeomFromText('POINT(207 147)') where c1 like 'c%'; |
| 1159 |
UPDATE t1 set spatial_point=GeomFromText('POINT(31 125)') where c1 like 'e%'; |
| 1160 |
UPDATE t1 set spatial_point=GeomFromText('POINT(27 36)') where c1 like 'r%'; |
| 1161 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 1162 |
('b', 'c', 'e', GeomFromText('POINT(41 137)')), |
| 1163 |
('p', 'y', 'k', GeomFromText('POINT(50 22)')), |
| 1164 |
('s', 'c', 'h', GeomFromText('POINT(208 173)')), |
| 1165 |
('x', 'u', 'l', GeomFromText('POINT(199 175)')), |
| 1166 |
('s', 'r', 'h', GeomFromText('POINT(85 192)')), |
| 1167 |
('j', 'k', 'u', GeomFromText('POINT(18 25)')), |
| 1168 |
('p', 'w', 'h', GeomFromText('POINT(152 197)')), |
| 1169 |
('e', 'd', 'c', GeomFromText('POINT(229 3)')), |
| 1170 |
('o', 'x', 'k', GeomFromText('POINT(187 155)')), |
| 1171 |
('o', 'b', 'k', GeomFromText('POINT(208 150)')), |
| 1172 |
('d', 'a', 'j', GeomFromText('POINT(70 87)')), |
| 1173 |
('f', 'e', 'k', GeomFromText('POINT(156 96)')), |
| 1174 |
('u', 'y', 'p', GeomFromText('POINT(239 193)')), |
| 1175 |
('n', 'v', 'p', GeomFromText('POINT(223 98)')), |
| 1176 |
('z', 'j', 'r', GeomFromText('POINT(87 89)')), |
| 1177 |
('h', 'x', 'x', GeomFromText('POINT(92 0)')), |
| 1178 |
('r', 'v', 'r', GeomFromText('POINT(159 139)')), |
| 1179 |
('v', 'g', 'g', GeomFromText('POINT(16 229)')), |
| 1180 |
('z', 'k', 'u', GeomFromText('POINT(99 52)')), |
| 1181 |
('p', 'p', 'o', GeomFromText('POINT(105 125)')), |
| 1182 |
('w', 'h', 'y', GeomFromText('POINT(105 154)')), |
| 1183 |
('v', 'y', 'z', GeomFromText('POINT(134 238)')), |
| 1184 |
('x', 'o', 'o', GeomFromText('POINT(178 88)')), |
| 1185 |
('z', 'w', 'd', GeomFromText('POINT(123 60)')), |
| 1186 |
('q', 'f', 'u', GeomFromText('POINT(64 90)')), |
| 1187 |
('s', 'n', 't', GeomFromText('POINT(50 138)')), |
| 1188 |
('v', 'p', 't', GeomFromText('POINT(114 91)')), |
| 1189 |
('a', 'o', 'n', GeomFromText('POINT(78 43)')), |
| 1190 |
('k', 'u', 'd', GeomFromText('POINT(185 161)')), |
| 1191 |
('w', 'd', 'n', GeomFromText('POINT(25 92)')), |
| 1192 |
('k', 'w', 'a', GeomFromText('POINT(59 238)')), |
| 1193 |
('t', 'c', 'f', GeomFromText('POINT(65 87)')), |
| 1194 |
('g', 's', 'p', GeomFromText('POINT(238 126)')), |
| 1195 |
('d', 'n', 'y', GeomFromText('POINT(107 173)')), |
| 1196 |
('l', 'a', 'w', GeomFromText('POINT(125 152)')), |
| 1197 |
('m', 'd', 'j', GeomFromText('POINT(146 53)')), |
| 1198 |
('q', 'm', 'c', GeomFromText('POINT(217 187)')), |
| 1199 |
('i', 'r', 'r', GeomFromText('POINT(6 113)')), |
| 1200 |
('e', 'j', 'b', GeomFromText('POINT(37 83)')), |
| 1201 |
('w', 'w', 'h', GeomFromText('POINT(83 199)')), |
| 1202 |
('k', 'b', 's', GeomFromText('POINT(170 64)')), |
| 1203 |
('s', 'b', 'c', GeomFromText('POINT(163 130)')), |
| 1204 |
('c', 'h', 'a', GeomFromText('POINT(141 3)')), |
| 1205 |
('k', 'j', 'u', GeomFromText('POINT(143 76)')), |
| 1206 |
('r', 'h', 'o', GeomFromText('POINT(243 92)')), |
| 1207 |
('i', 'd', 'b', GeomFromText('POINT(205 13)')), |
| 1208 |
('r', 'y', 'q', GeomFromText('POINT(138 8)')), |
| 1209 |
('m', 'o', 'i', GeomFromText('POINT(36 45)')), |
| 1210 |
('v', 'g', 'm', GeomFromText('POINT(0 40)')), |
| 1211 |
('f', 'e', 'i', GeomFromText('POINT(76 6)')), |
| 1212 |
('c', 'q', 'q', GeomFromText('POINT(115 248)')), |
| 1213 |
('x', 'c', 'i', GeomFromText('POINT(29 74)')), |
| 1214 |
('l', 's', 't', GeomFromText('POINT(83 18)')), |
| 1215 |
('t', 't', 'a', GeomFromText('POINT(26 168)')), |
| 1216 |
('u', 'n', 'x', GeomFromText('POINT(200 110)')), |
| 1217 |
('j', 'b', 'd', GeomFromText('POINT(216 136)')), |
| 1218 |
('s', 'p', 'w', GeomFromText('POINT(38 156)')), |
| 1219 |
('f', 'b', 'v', GeomFromText('POINT(29 186)')), |
| 1220 |
('v', 'e', 'r', GeomFromText('POINT(149 40)')), |
| 1221 |
('v', 't', 'm', GeomFromText('POINT(184 24)')), |
| 1222 |
('y', 'g', 'a', GeomFromText('POINT(219 105)')), |
| 1223 |
('s', 'f', 'i', GeomFromText('POINT(114 130)')), |
| 1224 |
('e', 'q', 'h', GeomFromText('POINT(203 135)')), |
| 1225 |
('h', 'g', 'b', GeomFromText('POINT(9 208)')), |
| 1226 |
('o', 'l', 'r', GeomFromText('POINT(245 79)')), |
| 1227 |
('s', 's', 'v', GeomFromText('POINT(238 198)')), |
| 1228 |
('w', 'w', 'z', GeomFromText('POINT(209 232)')), |
| 1229 |
('v', 'd', 'n', GeomFromText('POINT(30 193)')), |
| 1230 |
('q', 'w', 'k', GeomFromText('POINT(133 18)')), |
| 1231 |
('o', 'h', 'o', GeomFromText('POINT(42 140)')), |
| 1232 |
('f', 'f', 'h', GeomFromText('POINT(145 1)')), |
| 1233 |
('u', 's', 'r', GeomFromText('POINT(70 62)')), |
| 1234 |
('x', 'n', 'q', GeomFromText('POINT(33 86)')), |
| 1235 |
('u', 'p', 'v', GeomFromText('POINT(232 220)')), |
| 1236 |
('z', 'e', 'a', GeomFromText('POINT(130 69)')), |
| 1237 |
('r', 'u', 'z', GeomFromText('POINT(243 241)')), |
| 1238 |
('b', 'n', 't', GeomFromText('POINT(120 12)')), |
| 1239 |
('u', 'f', 's', GeomFromText('POINT(190 212)')), |
| 1240 |
('a', 'd', 'q', GeomFromText('POINT(235 191)')), |
| 1241 |
('f', 'q', 'm', GeomFromText('POINT(176 2)')), |
| 1242 |
('n', 'c', 's', GeomFromText('POINT(218 163)')), |
| 1243 |
('e', 'm', 'h', GeomFromText('POINT(163 108)')), |
| 1244 |
('c', 'f', 'l', GeomFromText('POINT(220 115)')), |
| 1245 |
('c', 'v', 'q', GeomFromText('POINT(66 45)')), |
| 1246 |
('w', 'v', 'x', GeomFromText('POINT(251 220)')), |
| 1247 |
('f', 'w', 'z', GeomFromText('POINT(146 149)')), |
| 1248 |
('h', 'n', 'h', GeomFromText('POINT(148 128)')), |
| 1249 |
('y', 'k', 'v', GeomFromText('POINT(28 110)')), |
| 1250 |
('c', 'x', 'q', GeomFromText('POINT(13 13)')), |
| 1251 |
('e', 'd', 's', GeomFromText('POINT(91 190)')), |
| 1252 |
('c', 'w', 'c', GeomFromText('POINT(10 231)')), |
| 1253 |
('u', 'j', 'n', GeomFromText('POINT(250 21)')), |
| 1254 |
('w', 'n', 'x', GeomFromText('POINT(141 69)')), |
| 1255 |
('f', 'p', 'y', GeomFromText('POINT(228 246)')), |
| 1256 |
('d', 'q', 'f', GeomFromText('POINT(194 22)')), |
| 1257 |
('d', 'z', 'l', GeomFromText('POINT(233 181)')), |
| 1258 |
('c', 'a', 'q', GeomFromText('POINT(183 96)')), |
| 1259 |
('m', 'i', 'd', GeomFromText('POINT(117 226)')), |
| 1260 |
('z', 'y', 'y', GeomFromText('POINT(62 81)')), |
| 1261 |
('g', 'v', 'm', GeomFromText('POINT(66 158)')); |
| 1262 |
SET @@RAND_SEED1=481064922, @@RAND_SEED2=438133497; |
| 1263 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 1264 |
SET @@RAND_SEED1=280535103, @@RAND_SEED2=444518646; |
| 1265 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 1266 |
SET @@RAND_SEED1=1072017234, @@RAND_SEED2=484203885; |
| 1267 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 1268 |
SET @@RAND_SEED1=358851897, @@RAND_SEED2=358495224; |
| 1269 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 1270 |
SET @@RAND_SEED1=509031459, @@RAND_SEED2=675962925; |
| 1271 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 1272 |
UPDATE t1 set spatial_point=GeomFromText('POINT(61 203)') where c1 like 'y%'; |
| 1273 |
UPDATE t1 set spatial_point=GeomFromText('POINT(202 194)') where c1 like 'f%'; |
| 1274 |
UPDATE t1 set spatial_point=GeomFromText('POINT(228 18)') where c1 like 'h%'; |
| 1275 |
UPDATE t1 set spatial_point=GeomFromText('POINT(88 18)') where c1 like 'l%'; |
| 1276 |
UPDATE t1 set spatial_point=GeomFromText('POINT(176 94)') where c1 like 'e%'; |
| 1277 |
UPDATE t1 set spatial_point=GeomFromText('POINT(44 47)') where c1 like 'g%'; |
| 1278 |
UPDATE t1 set spatial_point=GeomFromText('POINT(95 191)') where c1 like 'b%'; |
| 1279 |
UPDATE t1 set spatial_point=GeomFromText('POINT(179 218)') where c1 like 'y%'; |
| 1280 |
UPDATE t1 set spatial_point=GeomFromText('POINT(239 40)') where c1 like 'g%'; |
| 1281 |
UPDATE t1 set spatial_point=GeomFromText('POINT(248 41)') where c1 like 'q%'; |
| 1282 |
UPDATE t1 set spatial_point=GeomFromText('POINT(167 82)') where c1 like 't%'; |
| 1283 |
UPDATE t1 set spatial_point=GeomFromText('POINT(13 104)') where c1 like 'u%'; |
| 1284 |
UPDATE t1 set spatial_point=GeomFromText('POINT(139 84)') where c1 like 'a%'; |
| 1285 |
UPDATE t1 set spatial_point=GeomFromText('POINT(145 108)') where c1 like 'p%'; |
| 1286 |
UPDATE t1 set spatial_point=GeomFromText('POINT(147 57)') where c1 like 't%'; |
| 1287 |
UPDATE t1 set spatial_point=GeomFromText('POINT(217 144)') where c1 like 'n%'; |
| 1288 |
UPDATE t1 set spatial_point=GeomFromText('POINT(160 224)') where c1 like 'w%'; |
| 1289 |
UPDATE t1 set spatial_point=GeomFromText('POINT(38 28)') where c1 like 'j%'; |
| 1290 |
UPDATE t1 set spatial_point=GeomFromText('POINT(104 114)') where c1 like 'q%'; |
| 1291 |
UPDATE t1 set spatial_point=GeomFromText('POINT(88 19)') where c1 like 'c%'; |
| 1292 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 1293 |
('f', 'x', 'p', GeomFromText('POINT(92 181)')), |
| 1294 |
('s', 'i', 'c', GeomFromText('POINT(49 60)')), |
| 1295 |
('c', 'c', 'i', GeomFromText('POINT(7 57)')), |
| 1296 |
('n', 'g', 'k', GeomFromText('POINT(252 105)')), |
| 1297 |
('g', 'b', 'm', GeomFromText('POINT(180 11)')), |
| 1298 |
('u', 'l', 'r', GeomFromText('POINT(32 90)')), |
| 1299 |
('c', 'x', 'e', GeomFromText('POINT(143 24)')), |
| 1300 |
('x', 'u', 'a', GeomFromText('POINT(123 92)')), |
| 1301 |
('s', 'b', 'h', GeomFromText('POINT(190 108)')), |
| 1302 |
('c', 'x', 'b', GeomFromText('POINT(104 100)')), |
| 1303 |
('i', 'd', 't', GeomFromText('POINT(214 104)')), |
| 1304 |
('r', 'w', 'g', GeomFromText('POINT(29 67)')), |
| 1305 |
('b', 'f', 'g', GeomFromText('POINT(149 46)')), |
| 1306 |
('r', 'r', 'd', GeomFromText('POINT(242 196)')), |
| 1307 |
('j', 'l', 'a', GeomFromText('POINT(90 196)')), |
| 1308 |
('e', 't', 'b', GeomFromText('POINT(190 64)')), |
| 1309 |
('l', 'x', 'w', GeomFromText('POINT(250 73)')), |
| 1310 |
('q', 'y', 'r', GeomFromText('POINT(120 182)')), |
| 1311 |
('s', 'j', 'a', GeomFromText('POINT(180 175)')), |
| 1312 |
('n', 'i', 'y', GeomFromText('POINT(124 136)')), |
| 1313 |
('s', 'x', 's', GeomFromText('POINT(176 209)')), |
| 1314 |
('u', 'f', 's', GeomFromText('POINT(215 173)')), |
| 1315 |
('m', 'j', 'x', GeomFromText('POINT(44 140)')), |
| 1316 |
('v', 'g', 'x', GeomFromText('POINT(177 233)')), |
| 1317 |
('u', 't', 'b', GeomFromText('POINT(136 197)')), |
| 1318 |
('f', 'g', 'b', GeomFromText('POINT(10 8)')), |
| 1319 |
('v', 'c', 'j', GeomFromText('POINT(13 81)')), |
| 1320 |
('d', 's', 'q', GeomFromText('POINT(200 100)')), |
| 1321 |
('a', 'p', 'j', GeomFromText('POINT(33 40)')), |
| 1322 |
('i', 'c', 'g', GeomFromText('POINT(168 204)')), |
| 1323 |
('k', 'h', 'i', GeomFromText('POINT(93 243)')), |
| 1324 |
('s', 'b', 's', GeomFromText('POINT(157 13)')), |
| 1325 |
('v', 'l', 'l', GeomFromText('POINT(103 6)')), |
| 1326 |
('r', 'b', 'k', GeomFromText('POINT(244 137)')), |
| 1327 |
('l', 'd', 'r', GeomFromText('POINT(162 254)')), |
| 1328 |
('q', 'b', 'z', GeomFromText('POINT(136 246)')), |
| 1329 |
('x', 'x', 'p', GeomFromText('POINT(120 37)')), |
| 1330 |
('m', 'e', 'z', GeomFromText('POINT(203 167)')), |
| 1331 |
('q', 'n', 'p', GeomFromText('POINT(94 119)')), |
| 1332 |
('b', 'g', 'u', GeomFromText('POINT(93 248)')), |
| 1333 |
('r', 'v', 'v', GeomFromText('POINT(53 88)')), |
| 1334 |
('y', 'a', 'i', GeomFromText('POINT(98 219)')), |
| 1335 |
('a', 's', 'g', GeomFromText('POINT(173 138)')), |
| 1336 |
('c', 'a', 't', GeomFromText('POINT(235 135)')), |
| 1337 |
('q', 'm', 'd', GeomFromText('POINT(224 208)')), |
| 1338 |
('e', 'p', 'k', GeomFromText('POINT(161 238)')), |
| 1339 |
('n', 'g', 'q', GeomFromText('POINT(35 204)')), |
| 1340 |
('t', 't', 'x', GeomFromText('POINT(230 178)')), |
| 1341 |
('w', 'f', 'a', GeomFromText('POINT(150 221)')), |
| 1342 |
('z', 'm', 'z', GeomFromText('POINT(119 42)')), |
| 1343 |
('l', 'j', 's', GeomFromText('POINT(97 96)')), |
| 1344 |
('f', 'z', 'x', GeomFromText('POINT(208 65)')), |
| 1345 |
('i', 'v', 'c', GeomFromText('POINT(145 79)')), |
| 1346 |
('l', 'f', 'k', GeomFromText('POINT(83 234)')), |
| 1347 |
('u', 'a', 's', GeomFromText('POINT(250 49)')), |
| 1348 |
('o', 'k', 'p', GeomFromText('POINT(46 50)')), |
| 1349 |
('d', 'e', 'z', GeomFromText('POINT(30 198)')), |
| 1350 |
('r', 'r', 'l', GeomFromText('POINT(78 189)')), |
| 1351 |
('y', 'l', 'f', GeomFromText('POINT(188 132)')), |
| 1352 |
('d', 'q', 'm', GeomFromText('POINT(247 107)')), |
| 1353 |
('p', 'j', 'n', GeomFromText('POINT(148 227)')), |
| 1354 |
('b', 'o', 'i', GeomFromText('POINT(172 25)')), |
| 1355 |
('e', 'v', 'd', GeomFromText('POINT(94 248)')), |
| 1356 |
('q', 'd', 'f', GeomFromText('POINT(15 29)')), |
| 1357 |
('w', 'b', 'b', GeomFromText('POINT(74 111)')), |
| 1358 |
('g', 'q', 'f', GeomFromText('POINT(107 215)')), |
| 1359 |
('o', 'h', 'r', GeomFromText('POINT(25 168)')), |
| 1360 |
('u', 't', 'w', GeomFromText('POINT(251 188)')), |
| 1361 |
('h', 's', 'w', GeomFromText('POINT(254 247)')), |
| 1362 |
('f', 'f', 'b', GeomFromText('POINT(166 103)')); |
| 1363 |
SET @@RAND_SEED1=866613816, @@RAND_SEED2=92289615; |
| 1364 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 1365 |
('l', 'c', 'l', GeomFromText('POINT(202 98)')), |
| 1366 |
('k', 'c', 'b', GeomFromText('POINT(46 206)')), |
| 1367 |
('r', 'y', 'm', GeomFromText('POINT(74 140)')), |
| 1368 |
('y', 'z', 'd', GeomFromText('POINT(200 160)')), |
| 1369 |
('s', 'y', 's', GeomFromText('POINT(156 205)')), |
| 1370 |
('u', 'v', 'p', GeomFromText('POINT(86 82)')), |
| 1371 |
('j', 's', 's', GeomFromText('POINT(91 233)')), |
| 1372 |
('x', 'j', 'f', GeomFromText('POINT(3 14)')), |
| 1373 |
('l', 'z', 'v', GeomFromText('POINT(123 156)')), |
| 1374 |
('h', 'i', 'o', GeomFromText('POINT(145 229)')), |
| 1375 |
('o', 'r', 'd', GeomFromText('POINT(15 22)')), |
| 1376 |
('f', 'x', 't', GeomFromText('POINT(21 60)')), |
| 1377 |
('t', 'g', 'h', GeomFromText('POINT(50 153)')), |
| 1378 |
('g', 'u', 'b', GeomFromText('POINT(82 85)')), |
| 1379 |
('v', 'a', 'p', GeomFromText('POINT(231 178)')), |
| 1380 |
('n', 'v', 'o', GeomFromText('POINT(183 25)')), |
| 1381 |
('j', 'n', 'm', GeomFromText('POINT(50 144)')), |
| 1382 |
('e', 'f', 'i', GeomFromText('POINT(46 16)')), |
| 1383 |
('d', 'w', 'a', GeomFromText('POINT(66 6)')), |
| 1384 |
('f', 'x', 'a', GeomFromText('POINT(107 197)')), |
| 1385 |
('m', 'o', 'a', GeomFromText('POINT(142 80)')), |
| 1386 |
('q', 'l', 'g', GeomFromText('POINT(251 23)')), |
| 1387 |
('c', 's', 's', GeomFromText('POINT(158 43)')), |
| 1388 |
('y', 'd', 'o', GeomFromText('POINT(196 228)')), |
| 1389 |
('d', 'p', 'l', GeomFromText('POINT(107 5)')), |
| 1390 |
('h', 'a', 'b', GeomFromText('POINT(183 166)')), |
| 1391 |
('m', 'w', 'p', GeomFromText('POINT(19 59)')), |
| 1392 |
('b', 'y', 'o', GeomFromText('POINT(178 30)')), |
| 1393 |
('x', 'w', 'i', GeomFromText('POINT(168 94)')), |
| 1394 |
('t', 'k', 'z', GeomFromText('POINT(171 5)')), |
| 1395 |
('r', 'm', 'a', GeomFromText('POINT(222 19)')), |
| 1396 |
('u', 'v', 'e', GeomFromText('POINT(224 80)')), |
| 1397 |
('q', 'r', 'k', GeomFromText('POINT(212 218)')), |
| 1398 |
('d', 'p', 'j', GeomFromText('POINT(169 7)')), |
| 1399 |
('d', 'r', 'v', GeomFromText('POINT(193 23)')), |
| 1400 |
('n', 'y', 'y', GeomFromText('POINT(130 178)')), |
| 1401 |
('m', 'z', 'r', GeomFromText('POINT(81 200)')), |
| 1402 |
('j', 'e', 'w', GeomFromText('POINT(145 239)')), |
| 1403 |
('v', 'h', 'x', GeomFromText('POINT(24 105)')), |
| 1404 |
('z', 'm', 'a', GeomFromText('POINT(175 129)')), |
| 1405 |
('b', 'c', 'v', GeomFromText('POINT(213 10)')), |
| 1406 |
('t', 't', 'u', GeomFromText('POINT(2 129)')), |
| 1407 |
('r', 's', 'v', GeomFromText('POINT(209 192)')), |
| 1408 |
('x', 'p', 'g', GeomFromText('POINT(43 63)')), |
| 1409 |
('t', 'e', 'u', GeomFromText('POINT(139 210)')), |
| 1410 |
('l', 'e', 't', GeomFromText('POINT(245 148)')), |
| 1411 |
('a', 'i', 'k', GeomFromText('POINT(167 195)')), |
| 1412 |
('m', 'o', 'h', GeomFromText('POINT(206 120)')), |
| 1413 |
('g', 'z', 's', GeomFromText('POINT(169 240)')), |
| 1414 |
('z', 'u', 's', GeomFromText('POINT(202 120)')), |
| 1415 |
('i', 'b', 'a', GeomFromText('POINT(216 18)')), |
| 1416 |
('w', 'y', 'g', GeomFromText('POINT(119 236)')), |
| 1417 |
('h', 'y', 'p', GeomFromText('POINT(161 24)')); |
| 1418 |
UPDATE t1 set spatial_point=GeomFromText('POINT(33 100)') where c1 like 't%'; |
| 1419 |
UPDATE t1 set spatial_point=GeomFromText('POINT(41 46)') where c1 like 'f%'; |
| 1420 |
CHECK TABLE t1 EXTENDED; |
| 1421 |
Table Op Msg_type Msg_text |
| 1422 |
test.t1 check status OK |
| 1423 |
DROP TABLE t1; |
| 1424 |
create table t1 (a geometry not null, spatial index(a)) transactional=1 row_format=page; |
| 1425 |
insert into t1 values (PointFromWKB(POINT(1.1517219314031e+164, 131072))); |
| 1426 |
insert into t1 values (PointFromWKB(POINT(9.1248812352444e+192, 2.9740338169556e+284))); |
| 1427 |
insert into t1 values (PointFromWKB(POINT(4.7783097267365e-299, -0))); |
| 1428 |
insert into t1 values (PointFromWKB(POINT(1.49166814624e-154, 2.0880974297595e-53))); |
| 1429 |
insert into t1 values (PointFromWKB(POINT(4.0917382598702e+149, 1.2024538023802e+111))); |
| 1430 |
insert into t1 values (PointFromWKB(POINT(2.0349165139404e+236, 2.9993936277913e-241))); |
| 1431 |
insert into t1 values (PointFromWKB(POINT(2.5243548967072e-29, 1.2024538023802e+111))); |
| 1432 |
insert into t1 values (PointFromWKB(POINT(0, 6.9835074892995e-251))); |
| 1433 |
insert into t1 values (PointFromWKB(POINT(2.0880974297595e-53, 3.1050361846014e+231))); |
| 1434 |
insert into t1 values (PointFromWKB(POINT(2.8728483499323e-188, 2.4600631144627e+260))); |
| 1435 |
insert into t1 values (PointFromWKB(POINT(3.0517578125e-05, 2.0349165139404e+236))); |
| 1436 |
insert into t1 values (PointFromWKB(POINT(1.1517219314031e+164, 1.1818212630766e-125))); |
| 1437 |
insert into t1 values (PointFromWKB(POINT(2.481040258324e-265, 5.7766220027675e-275))); |
| 1438 |
insert into t1 values (PointFromWKB(POINT(2.0880974297595e-53, 2.5243548967072e-29))); |
| 1439 |
insert into t1 values (PointFromWKB(POINT(5.7766220027675e-275, 9.9464647281957e+86))); |
| 1440 |
insert into t1 values (PointFromWKB(POINT(2.2181357552967e+130, 3.7857669957337e-270))); |
| 1441 |
insert into t1 values (PointFromWKB(POINT(4.5767114681874e-246, 3.6893488147419e+19))); |
| 1442 |
insert into t1 values (PointFromWKB(POINT(4.5767114681874e-246, 3.7537584144024e+255))); |
| 1443 |
insert into t1 values (PointFromWKB(POINT(3.7857669957337e-270, 1.8033161362863e-130))); |
| 1444 |
insert into t1 values (PointFromWKB(POINT(0, 5.8774717541114e-39))); |
| 1445 |
insert into t1 values (PointFromWKB(POINT(1.1517219314031e+164, 2.2761049594727e-159))); |
| 1446 |
insert into t1 values (PointFromWKB(POINT(6.243497100632e+144, 3.7857669957337e-270))); |
| 1447 |
insert into t1 values (PointFromWKB(POINT(3.7857669957337e-270, 2.6355494858076e-82))); |
| 1448 |
insert into t1 values (PointFromWKB(POINT(2.0349165139404e+236, 3.8518598887745e-34))); |
| 1449 |
insert into t1 values (PointFromWKB(POINT(4.6566128730774e-10, 2.0880974297595e-53))); |
| 1450 |
insert into t1 values (PointFromWKB(POINT(2.0880974297595e-53, 1.8827498946116e-183))); |
| 1451 |
insert into t1 values (PointFromWKB(POINT(1.8033161362863e-130, 9.1248812352444e+192))); |
| 1452 |
insert into t1 values (PointFromWKB(POINT(4.7783097267365e-299, 2.2761049594727e-159))); |
| 1453 |
insert into t1 values (PointFromWKB(POINT(1.94906280228e+289, 1.2338789709327e-178))); |
| 1454 |
drop table t1; |
| 1455 |
CREATE TABLE t1(foo GEOMETRY NOT NULL, SPATIAL INDEX(foo) ) transactional=1 row_format=page; |
| 1456 |
INSERT INTO t1(foo) VALUES (NULL); |
| 1457 |
ERROR 23000: Column 'foo' cannot be null |
| 1458 |
INSERT IGNORE INTO t1() VALUES (); |
| 1459 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 1460 |
INSERT INTO t1(foo) VALUES (''); |
| 1461 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 1462 |
DROP TABLE t1; |
| 1463 |
CREATE TABLE t1 (a INT AUTO_INCREMENT, b POINT NOT NULL, KEY (a), SPATIAL KEY (b)) transactional=1 row_format=page; |
| 1464 |
INSERT INTO t1 (b) VALUES (GeomFromText('POINT(1 2)')); |
| 1465 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1466 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1467 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1468 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1469 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1470 |
OPTIMIZE TABLE t1; |
| 1471 |
Table Op Msg_type Msg_text |
| 1472 |
test.t1 optimize status OK |
| 1473 |
DROP TABLE t1; |
| 1474 |
CREATE TABLE t1 (a INT, b GEOMETRY NOT NULL, SPATIAL KEY b(b)) transactional=1 row_format=page; |
| 1475 |
INSERT INTO t1 VALUES (1, GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)')); |
| 1476 |
INSERT INTO t1 VALUES (2, GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)')); |
| 1477 |
SELECT COUNT(*) FROM t1 WHERE |
| 1478 |
MBRINTERSECTS(b, GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') ); |
| 1479 |
COUNT(*) |
| 1480 |
2 |
| 1481 |
SELECT COUNT(*) FROM t1 IGNORE INDEX (b) WHERE |
| 1482 |
MBRINTERSECTS(b, GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') ); |
| 1483 |
COUNT(*) |
| 1484 |
2 |
| 1485 |
DROP TABLE t1; |
| 1486 |
End of 5.0 tests. |