| 1 |
DROP TABLE IF EXISTS t1, t2; |
| 2 |
CREATE TABLE t1 ( |
| 3 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 4 |
g GEOMETRY NOT NULL SRID 0, |
| 5 |
SPATIAL KEY(g) |
| 6 |
) ENGINE=InnoDB; |
| 7 |
SHOW CREATE TABLE t1; |
| 8 |
Table Create Table |
| 9 |
t1 CREATE TABLE `t1` ( |
| 10 |
`fid` int NOT NULL AUTO_INCREMENT, |
| 11 |
`g` geometry NOT NULL /*!80003 SRID 0 */, |
| 12 |
PRIMARY KEY (`fid`), |
| 13 |
SPATIAL KEY `g` (`g`) |
| 14 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 15 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(150 150, 150 150)')); |
| 16 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(149 149, 151 151)')); |
| 17 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(148 148, 152 152)')); |
| 18 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(147 147, 153 153)')); |
| 19 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(146 146, 154 154)')); |
| 20 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(145 145, 155 155)')); |
| 21 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(144 144, 156 156)')); |
| 22 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(143 143, 157 157)')); |
| 23 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(142 142, 158 158)')); |
| 24 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(141 141, 159 159)')); |
| 25 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(140 140, 160 160)')); |
| 26 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(139 139, 161 161)')); |
| 27 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(138 138, 162 162)')); |
| 28 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(137 137, 163 163)')); |
| 29 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(136 136, 164 164)')); |
| 30 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(135 135, 165 165)')); |
| 31 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(134 134, 166 166)')); |
| 32 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(133 133, 167 167)')); |
| 33 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(132 132, 168 168)')); |
| 34 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(131 131, 169 169)')); |
| 35 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(130 130, 170 170)')); |
| 36 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(129 129, 171 171)')); |
| 37 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(128 128, 172 172)')); |
| 38 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(127 127, 173 173)')); |
| 39 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(126 126, 174 174)')); |
| 40 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(125 125, 175 175)')); |
| 41 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(124 124, 176 176)')); |
| 42 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(123 123, 177 177)')); |
| 43 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(122 122, 178 178)')); |
| 44 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(121 121, 179 179)')); |
| 45 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(120 120, 180 180)')); |
| 46 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(119 119, 181 181)')); |
| 47 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(118 118, 182 182)')); |
| 48 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(117 117, 183 183)')); |
| 49 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(116 116, 184 184)')); |
| 50 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(115 115, 185 185)')); |
| 51 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(114 114, 186 186)')); |
| 52 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(113 113, 187 187)')); |
| 53 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(112 112, 188 188)')); |
| 54 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(111 111, 189 189)')); |
| 55 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(110 110, 190 190)')); |
| 56 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(109 109, 191 191)')); |
| 57 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(108 108, 192 192)')); |
| 58 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(107 107, 193 193)')); |
| 59 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(106 106, 194 194)')); |
| 60 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(105 105, 195 195)')); |
| 61 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(104 104, 196 196)')); |
| 62 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(103 103, 197 197)')); |
| 63 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(102 102, 198 198)')); |
| 64 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(101 101, 199 199)')); |
| 65 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(100 100, 200 200)')); |
| 66 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(99 99, 201 201)')); |
| 67 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(98 98, 202 202)')); |
| 68 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(97 97, 203 203)')); |
| 69 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(96 96, 204 204)')); |
| 70 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(95 95, 205 205)')); |
| 71 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(94 94, 206 206)')); |
| 72 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(93 93, 207 207)')); |
| 73 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(92 92, 208 208)')); |
| 74 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(91 91, 209 209)')); |
| 75 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(90 90, 210 210)')); |
| 76 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(89 89, 211 211)')); |
| 77 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(88 88, 212 212)')); |
| 78 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(87 87, 213 213)')); |
| 79 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(86 86, 214 214)')); |
| 80 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(85 85, 215 215)')); |
| 81 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(84 84, 216 216)')); |
| 82 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(83 83, 217 217)')); |
| 83 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(82 82, 218 218)')); |
| 84 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(81 81, 219 219)')); |
| 85 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(80 80, 220 220)')); |
| 86 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(79 79, 221 221)')); |
| 87 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(78 78, 222 222)')); |
| 88 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(77 77, 223 223)')); |
| 89 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(76 76, 224 224)')); |
| 90 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(75 75, 225 225)')); |
| 91 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(74 74, 226 226)')); |
| 92 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(73 73, 227 227)')); |
| 93 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(72 72, 228 228)')); |
| 94 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(71 71, 229 229)')); |
| 95 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(70 70, 230 230)')); |
| 96 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(69 69, 231 231)')); |
| 97 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(68 68, 232 232)')); |
| 98 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(67 67, 233 233)')); |
| 99 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(66 66, 234 234)')); |
| 100 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(65 65, 235 235)')); |
| 101 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(64 64, 236 236)')); |
| 102 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(63 63, 237 237)')); |
| 103 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(62 62, 238 238)')); |
| 104 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(61 61, 239 239)')); |
| 105 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(60 60, 240 240)')); |
| 106 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(59 59, 241 241)')); |
| 107 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(58 58, 242 242)')); |
| 108 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(57 57, 243 243)')); |
| 109 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(56 56, 244 244)')); |
| 110 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(55 55, 245 245)')); |
| 111 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(54 54, 246 246)')); |
| 112 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(53 53, 247 247)')); |
| 113 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(52 52, 248 248)')); |
| 114 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(51 51, 249 249)')); |
| 115 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(50 50, 250 250)')); |
| 116 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(49 49, 251 251)')); |
| 117 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(48 48, 252 252)')); |
| 118 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(47 47, 253 253)')); |
| 119 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(46 46, 254 254)')); |
| 120 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(45 45, 255 255)')); |
| 121 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(44 44, 256 256)')); |
| 122 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(43 43, 257 257)')); |
| 123 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(42 42, 258 258)')); |
| 124 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(41 41, 259 259)')); |
| 125 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(40 40, 260 260)')); |
| 126 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(39 39, 261 261)')); |
| 127 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(38 38, 262 262)')); |
| 128 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(37 37, 263 263)')); |
| 129 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(36 36, 264 264)')); |
| 130 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(35 35, 265 265)')); |
| 131 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(34 34, 266 266)')); |
| 132 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(33 33, 267 267)')); |
| 133 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(32 32, 268 268)')); |
| 134 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(31 31, 269 269)')); |
| 135 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(30 30, 270 270)')); |
| 136 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(29 29, 271 271)')); |
| 137 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(28 28, 272 272)')); |
| 138 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(27 27, 273 273)')); |
| 139 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(26 26, 274 274)')); |
| 140 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(25 25, 275 275)')); |
| 141 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(24 24, 276 276)')); |
| 142 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(23 23, 277 277)')); |
| 143 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(22 22, 278 278)')); |
| 144 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(21 21, 279 279)')); |
| 145 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(20 20, 280 280)')); |
| 146 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(19 19, 281 281)')); |
| 147 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(18 18, 282 282)')); |
| 148 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(17 17, 283 283)')); |
| 149 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(16 16, 284 284)')); |
| 150 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(15 15, 285 285)')); |
| 151 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(14 14, 286 286)')); |
| 152 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(13 13, 287 287)')); |
| 153 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(12 12, 288 288)')); |
| 154 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(11 11, 289 289)')); |
| 155 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(10 10, 290 290)')); |
| 156 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(9 9, 291 291)')); |
| 157 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(8 8, 292 292)')); |
| 158 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(7 7, 293 293)')); |
| 159 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(6 6, 294 294)')); |
| 160 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(5 5, 295 295)')); |
| 161 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(4 4, 296 296)')); |
| 162 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(3 3, 297 297)')); |
| 163 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(2 2, 298 298)')); |
| 164 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(1 1, 299 299)')); |
| 165 |
SELECT count(*) FROM t1; |
| 166 |
count(*) |
| 167 |
150 |
| 168 |
SELECT fid, ST_AsText(g) FROM t1 WHERE MBRWithin(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')) ORDER BY fid; |
| 169 |
fid ST_AsText(g) |
| 170 |
1 LINESTRING(150 150,150 150) |
| 171 |
2 LINESTRING(149 149,151 151) |
| 172 |
3 LINESTRING(148 148,152 152) |
| 173 |
4 LINESTRING(147 147,153 153) |
| 174 |
5 LINESTRING(146 146,154 154) |
| 175 |
6 LINESTRING(145 145,155 155) |
| 176 |
7 LINESTRING(144 144,156 156) |
| 177 |
8 LINESTRING(143 143,157 157) |
| 178 |
9 LINESTRING(142 142,158 158) |
| 179 |
10 LINESTRING(141 141,159 159) |
| 180 |
11 LINESTRING(140 140,160 160) |
| 181 |
DROP TABLE t1; |
| 182 |
CREATE TABLE t2 ( |
| 183 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 184 |
g GEOMETRY NOT NULL SRID 0 |
| 185 |
) ENGINE=InnoDB; |
| 186 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 10 * 10 - 9), Point(10 * 10, 10 * 10))); |
| 187 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 9 * 10 - 9), Point(10 * 10, 9 * 10))); |
| 188 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 8 * 10 - 9), Point(10 * 10, 8 * 10))); |
| 189 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 7 * 10 - 9), Point(10 * 10, 7 * 10))); |
| 190 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 6 * 10 - 9), Point(10 * 10, 6 * 10))); |
| 191 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 5 * 10 - 9), Point(10 * 10, 5 * 10))); |
| 192 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 4 * 10 - 9), Point(10 * 10, 4 * 10))); |
| 193 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 3 * 10 - 9), Point(10 * 10, 3 * 10))); |
| 194 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 2 * 10 - 9), Point(10 * 10, 2 * 10))); |
| 195 |
INSERT INTO t2 (g) VALUES (LineString(Point(10 * 10 - 9, 1 * 10 - 9), Point(10 * 10, 1 * 10))); |
| 196 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 10 * 10 - 9), Point(9 * 10, 10 * 10))); |
| 197 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 9 * 10 - 9), Point(9 * 10, 9 * 10))); |
| 198 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 8 * 10 - 9), Point(9 * 10, 8 * 10))); |
| 199 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 7 * 10 - 9), Point(9 * 10, 7 * 10))); |
| 200 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 6 * 10 - 9), Point(9 * 10, 6 * 10))); |
| 201 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 5 * 10 - 9), Point(9 * 10, 5 * 10))); |
| 202 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 4 * 10 - 9), Point(9 * 10, 4 * 10))); |
| 203 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 3 * 10 - 9), Point(9 * 10, 3 * 10))); |
| 204 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 2 * 10 - 9), Point(9 * 10, 2 * 10))); |
| 205 |
INSERT INTO t2 (g) VALUES (LineString(Point(9 * 10 - 9, 1 * 10 - 9), Point(9 * 10, 1 * 10))); |
| 206 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 10 * 10 - 9), Point(8 * 10, 10 * 10))); |
| 207 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 9 * 10 - 9), Point(8 * 10, 9 * 10))); |
| 208 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 8 * 10 - 9), Point(8 * 10, 8 * 10))); |
| 209 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 7 * 10 - 9), Point(8 * 10, 7 * 10))); |
| 210 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 6 * 10 - 9), Point(8 * 10, 6 * 10))); |
| 211 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 5 * 10 - 9), Point(8 * 10, 5 * 10))); |
| 212 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 4 * 10 - 9), Point(8 * 10, 4 * 10))); |
| 213 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 3 * 10 - 9), Point(8 * 10, 3 * 10))); |
| 214 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 2 * 10 - 9), Point(8 * 10, 2 * 10))); |
| 215 |
INSERT INTO t2 (g) VALUES (LineString(Point(8 * 10 - 9, 1 * 10 - 9), Point(8 * 10, 1 * 10))); |
| 216 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 10 * 10 - 9), Point(7 * 10, 10 * 10))); |
| 217 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 9 * 10 - 9), Point(7 * 10, 9 * 10))); |
| 218 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 8 * 10 - 9), Point(7 * 10, 8 * 10))); |
| 219 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 7 * 10 - 9), Point(7 * 10, 7 * 10))); |
| 220 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 6 * 10 - 9), Point(7 * 10, 6 * 10))); |
| 221 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 5 * 10 - 9), Point(7 * 10, 5 * 10))); |
| 222 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 4 * 10 - 9), Point(7 * 10, 4 * 10))); |
| 223 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 3 * 10 - 9), Point(7 * 10, 3 * 10))); |
| 224 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 2 * 10 - 9), Point(7 * 10, 2 * 10))); |
| 225 |
INSERT INTO t2 (g) VALUES (LineString(Point(7 * 10 - 9, 1 * 10 - 9), Point(7 * 10, 1 * 10))); |
| 226 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 10 * 10 - 9), Point(6 * 10, 10 * 10))); |
| 227 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 9 * 10 - 9), Point(6 * 10, 9 * 10))); |
| 228 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 8 * 10 - 9), Point(6 * 10, 8 * 10))); |
| 229 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 7 * 10 - 9), Point(6 * 10, 7 * 10))); |
| 230 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 6 * 10 - 9), Point(6 * 10, 6 * 10))); |
| 231 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 5 * 10 - 9), Point(6 * 10, 5 * 10))); |
| 232 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 4 * 10 - 9), Point(6 * 10, 4 * 10))); |
| 233 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 3 * 10 - 9), Point(6 * 10, 3 * 10))); |
| 234 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 2 * 10 - 9), Point(6 * 10, 2 * 10))); |
| 235 |
INSERT INTO t2 (g) VALUES (LineString(Point(6 * 10 - 9, 1 * 10 - 9), Point(6 * 10, 1 * 10))); |
| 236 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 10 * 10 - 9), Point(5 * 10, 10 * 10))); |
| 237 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 9 * 10 - 9), Point(5 * 10, 9 * 10))); |
| 238 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 8 * 10 - 9), Point(5 * 10, 8 * 10))); |
| 239 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 7 * 10 - 9), Point(5 * 10, 7 * 10))); |
| 240 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 6 * 10 - 9), Point(5 * 10, 6 * 10))); |
| 241 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 5 * 10 - 9), Point(5 * 10, 5 * 10))); |
| 242 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 4 * 10 - 9), Point(5 * 10, 4 * 10))); |
| 243 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 3 * 10 - 9), Point(5 * 10, 3 * 10))); |
| 244 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 2 * 10 - 9), Point(5 * 10, 2 * 10))); |
| 245 |
INSERT INTO t2 (g) VALUES (LineString(Point(5 * 10 - 9, 1 * 10 - 9), Point(5 * 10, 1 * 10))); |
| 246 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 10 * 10 - 9), Point(4 * 10, 10 * 10))); |
| 247 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 9 * 10 - 9), Point(4 * 10, 9 * 10))); |
| 248 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 8 * 10 - 9), Point(4 * 10, 8 * 10))); |
| 249 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 7 * 10 - 9), Point(4 * 10, 7 * 10))); |
| 250 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 6 * 10 - 9), Point(4 * 10, 6 * 10))); |
| 251 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 5 * 10 - 9), Point(4 * 10, 5 * 10))); |
| 252 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 4 * 10 - 9), Point(4 * 10, 4 * 10))); |
| 253 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 3 * 10 - 9), Point(4 * 10, 3 * 10))); |
| 254 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 2 * 10 - 9), Point(4 * 10, 2 * 10))); |
| 255 |
INSERT INTO t2 (g) VALUES (LineString(Point(4 * 10 - 9, 1 * 10 - 9), Point(4 * 10, 1 * 10))); |
| 256 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 10 * 10 - 9), Point(3 * 10, 10 * 10))); |
| 257 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 9 * 10 - 9), Point(3 * 10, 9 * 10))); |
| 258 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 8 * 10 - 9), Point(3 * 10, 8 * 10))); |
| 259 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 7 * 10 - 9), Point(3 * 10, 7 * 10))); |
| 260 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 6 * 10 - 9), Point(3 * 10, 6 * 10))); |
| 261 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 5 * 10 - 9), Point(3 * 10, 5 * 10))); |
| 262 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 4 * 10 - 9), Point(3 * 10, 4 * 10))); |
| 263 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 3 * 10 - 9), Point(3 * 10, 3 * 10))); |
| 264 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 2 * 10 - 9), Point(3 * 10, 2 * 10))); |
| 265 |
INSERT INTO t2 (g) VALUES (LineString(Point(3 * 10 - 9, 1 * 10 - 9), Point(3 * 10, 1 * 10))); |
| 266 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 10 * 10 - 9), Point(2 * 10, 10 * 10))); |
| 267 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 9 * 10 - 9), Point(2 * 10, 9 * 10))); |
| 268 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 8 * 10 - 9), Point(2 * 10, 8 * 10))); |
| 269 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 7 * 10 - 9), Point(2 * 10, 7 * 10))); |
| 270 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 6 * 10 - 9), Point(2 * 10, 6 * 10))); |
| 271 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 5 * 10 - 9), Point(2 * 10, 5 * 10))); |
| 272 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 4 * 10 - 9), Point(2 * 10, 4 * 10))); |
| 273 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 3 * 10 - 9), Point(2 * 10, 3 * 10))); |
| 274 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 2 * 10 - 9), Point(2 * 10, 2 * 10))); |
| 275 |
INSERT INTO t2 (g) VALUES (LineString(Point(2 * 10 - 9, 1 * 10 - 9), Point(2 * 10, 1 * 10))); |
| 276 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 10 * 10 - 9), Point(1 * 10, 10 * 10))); |
| 277 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 9 * 10 - 9), Point(1 * 10, 9 * 10))); |
| 278 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 8 * 10 - 9), Point(1 * 10, 8 * 10))); |
| 279 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 7 * 10 - 9), Point(1 * 10, 7 * 10))); |
| 280 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 6 * 10 - 9), Point(1 * 10, 6 * 10))); |
| 281 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 5 * 10 - 9), Point(1 * 10, 5 * 10))); |
| 282 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 4 * 10 - 9), Point(1 * 10, 4 * 10))); |
| 283 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 3 * 10 - 9), Point(1 * 10, 3 * 10))); |
| 284 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 2 * 10 - 9), Point(1 * 10, 2 * 10))); |
| 285 |
INSERT INTO t2 (g) VALUES (LineString(Point(1 * 10 - 9, 1 * 10 - 9), Point(1 * 10, 1 * 10))); |
| 286 |
ALTER TABLE t2 ADD SPATIAL KEY(g); |
| 287 |
SHOW CREATE TABLE t2; |
| 288 |
Table Create Table |
| 289 |
t2 CREATE TABLE `t2` ( |
| 290 |
`fid` int NOT NULL AUTO_INCREMENT, |
| 291 |
`g` geometry NOT NULL /*!80003 SRID 0 */, |
| 292 |
PRIMARY KEY (`fid`), |
| 293 |
SPATIAL KEY `g` (`g`) |
| 294 |
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 295 |
SELECT count(*) FROM t2; |
| 296 |
count(*) |
| 297 |
100 |
| 298 |
SELECT fid, ST_AsText(g) FROM t2 WHERE MBRWithin(g, |
| 299 |
ST_GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')) ORDER BY fid; |
| 300 |
fid ST_AsText(g) |
| 301 |
45 LINESTRING(51 51,60 60) |
| 302 |
46 LINESTRING(51 41,60 50) |
| 303 |
55 LINESTRING(41 51,50 60) |
| 304 |
56 LINESTRING(41 41,50 50) |
| 305 |
DROP TABLE t2; |
| 306 |
drop table if exists t1; |
| 307 |
Warnings: |
| 308 |
Note 1051 Unknown table 'test.t1' |
| 309 |
CREATE TABLE t1 (a geometry NOT NULL SRID 0, SPATIAL (a)); |
| 310 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 311 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 312 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 313 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 314 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 315 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 316 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 317 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 318 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 319 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 320 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 321 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 322 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 323 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 324 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 325 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 326 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 327 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 328 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 329 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 330 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 331 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 332 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 333 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 334 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 335 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 336 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 337 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 338 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 339 |
check table t1; |
| 340 |
Table Op Msg_type Msg_text |
| 341 |
test.t1 check status OK |
| 342 |
analyze table t1; |
| 343 |
Table Op Msg_type Msg_text |
| 344 |
test.t1 analyze status OK |
| 345 |
drop table t1; |
| 346 |
CREATE TABLE t1 ( |
| 347 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 348 |
g GEOMETRY NOT NULL SRID 0, |
| 349 |
SPATIAL KEY(g) |
| 350 |
) ENGINE=InnoDB; |
| 351 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(1 2, 2 3)')),(ST_GeomFromText('LineString(1 2, 2 4)')); |
| 352 |
drop table t1; |
| 353 |
CREATE TABLE t1 ( |
| 354 |
line LINESTRING NOT NULL SRID 0, |
| 355 |
kind ENUM('po', 'pp', 'rr', 'dr', 'rd', 'ts', 'cl') NOT NULL DEFAULT 'po', |
| 356 |
name VARCHAR(32), |
| 357 |
SPATIAL KEY (line) |
| 358 |
) engine=InnoDB; |
| 359 |
ALTER TABLE t1 DISABLE KEYS; |
| 360 |
Warnings: |
| 361 |
Note 1031 Table storage engine for 't1' doesn't have this option |
| 362 |
INSERT INTO t1 (name, kind, line) VALUES |
| 363 |
("Aadaouane", "pp", ST_GeomFromText("POINT(32.816667 35.983333)")), |
| 364 |
("Aadassiye", "pp", ST_GeomFromText("POINT(35.816667 36.216667)")), |
| 365 |
("Aadbel", "pp", ST_GeomFromText("POINT(34.533333 36.100000)")), |
| 366 |
("Aadchit", "pp", ST_GeomFromText("POINT(33.347222 35.423611)")), |
| 367 |
("Aadchite", "pp", ST_GeomFromText("POINT(33.347222 35.423611)")), |
| 368 |
("Aadchit el Qoussair", "pp", ST_GeomFromText("POINT(33.283333 35.483333)")), |
| 369 |
("Aaddaye", "pp", ST_GeomFromText("POINT(36.716667 40.833333)")), |
| 370 |
("'Aadeissa", "pp", ST_GeomFromText("POINT(32.823889 35.698889)")), |
| 371 |
("Aaderup", "pp", ST_GeomFromText("POINT(55.216667 11.766667)")), |
| 372 |
("Qalaat Aades", "pp", ST_GeomFromText("POINT(33.503333 35.377500)")), |
| 373 |
("A ad'ino", "pp", ST_GeomFromText("POINT(54.812222 38.209167)")), |
| 374 |
("Aadi Noia", "pp", ST_GeomFromText("POINT(13.800000 39.833333)")), |
| 375 |
("Aad La Macta", "pp", ST_GeomFromText("POINT(35.779444 -0.129167)")), |
| 376 |
("Aadland", "pp", ST_GeomFromText("POINT(60.366667 5.483333)")), |
| 377 |
("Aadliye", "pp", ST_GeomFromText("POINT(33.366667 36.333333)")), |
| 378 |
("Aadloun", "pp", ST_GeomFromText("POINT(33.403889 35.273889)")), |
| 379 |
("Aadma", "pp", ST_GeomFromText("POINT(58.798333 22.663889)")), |
| 380 |
("Aadma Asundus", "pp", ST_GeomFromText("POINT(58.798333 22.663889)")), |
| 381 |
("Aadmoun", "pp", ST_GeomFromText("POINT(34.150000 35.650000)")), |
| 382 |
("Aadneram", "pp", ST_GeomFromText("POINT(59.016667 6.933333)")), |
| 383 |
("Aadneskaar", "pp", ST_GeomFromText("POINT(58.083333 6.983333)")), |
| 384 |
("Aadorf", "pp", ST_GeomFromText("POINT(47.483333 8.900000)")), |
| 385 |
("Aadorp", "pp", ST_GeomFromText("POINT(52.366667 6.633333)")), |
| 386 |
("Aadouane", "pp", ST_GeomFromText("POINT(32.816667 35.983333)")), |
| 387 |
("Aadoui", "pp", ST_GeomFromText("POINT(34.450000 35.983333)")), |
| 388 |
("Aadouiye", "pp", ST_GeomFromText("POINT(34.583333 36.183333)")), |
| 389 |
("Aadouss", "pp", ST_GeomFromText("POINT(33.512500 35.601389)")), |
| 390 |
("Aadra", "pp", ST_GeomFromText("POINT(33.616667 36.500000)")), |
| 391 |
("Aadzi", "pp", ST_GeomFromText("POINT(38.100000 64.850000)")); |
| 392 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 393 |
ALTER TABLE t1 ENABLE KEYS; |
| 394 |
Warnings: |
| 395 |
Note 1031 Table storage engine for 't1' doesn't have this option |
| 396 |
INSERT INTO t1 (name, kind, line) VALUES ("austria", "pp", ST_GeomFromText('LINESTRING(14.9906 48.9887,14.9946 48.9904,14.9947 48.9916)')); |
| 397 |
drop table t1; |
| 398 |
CREATE TABLE t1 (st varchar(100)); |
| 399 |
INSERT INTO t1 VALUES ("Fake string"); |
| 400 |
CREATE TABLE t2 (geom GEOMETRY NOT NULL SRID 0, SPATIAL KEY gk(geom)); |
| 401 |
INSERT INTO t2 SELECT ST_GeomFromText(st) FROM t1; |
| 402 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 403 |
drop table t1, t2; |
| 404 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 405 |
CREATE TABLE t1 (`geometry` geometry NOT NULL SRID 0,SPATIAL KEY `gndx` (`geometry`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 406 |
INSERT INTO t1 (geometry) VALUES |
| 407 |
(ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, -18.6055555000 |
| 408 |
-66.8158332999, -18.7186111000 -66.8102777000, -18.7211111000 -66.9269443999, |
| 409 |
-18.6086111000 -66.9327777000))')); |
| 410 |
INSERT INTO t1 (geometry) VALUES |
| 411 |
(ST_PolygonFromText('POLYGON((-65.7402776999 -96.6686111000, -65.7372222000 |
| 412 |
-96.5516666000, -65.8502777000 -96.5461111000, -65.8527777000 -96.6627777000, |
| 413 |
-65.7402776999 -96.6686111000))')); |
| 414 |
check table t1 extended; |
| 415 |
Table Op Msg_type Msg_text |
| 416 |
test.t1 check status OK |
| 417 |
drop table t1; |
| 418 |
CREATE TABLE t1 (`geometry` geometry NOT NULL SRID 0,SPATIAL KEY `gndx` (`geometry`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 419 |
INSERT INTO t1 (geometry) VALUES |
| 420 |
(ST_PolygonFromText('POLYGON((2 2, 2 8, 10 8, 10 2, 2 2))')); |
| 421 |
INSERT INTO t1 (geometry) VALUES |
| 422 |
(ST_PolygonFromText('POLYGON((2 12, 15 12, 15 18, 2 18, 2 12))')); |
| 423 |
INSERT INTO t1 (geometry) VALUES |
| 424 |
(ST_PolygonFromText('POLYGON((3 5, 3 18, 10 18, 10 5, 3 5))')); |
| 425 |
INSERT INTO t1 (geometry) VALUES |
| 426 |
(ST_PolygonFromText('POLYGON((4 6, 4 8, 10 8, 10 4, 4 6))')); |
| 427 |
set @g1 = ST_GeomFromText('Polygon((0 0,0 1000,1000 1000,1000 0,0 0))'); |
| 428 |
select count(*) from t1 where MBRWithin(t1.geometry, @g1); |
| 429 |
count(*) |
| 430 |
4 |
| 431 |
start transaction; |
| 432 |
INSERT INTO t1 (geometry) VALUES |
| 433 |
(ST_PolygonFromText('POLYGON((4 6, 4 8, 10 8, 10 4, 4 6))')); |
| 434 |
select count(*) from t1 where MBRWithin(t1.geometry, @g1); |
| 435 |
count(*) |
| 436 |
5 |
| 437 |
rollback; |
| 438 |
select count(*) from t1 where MBRWithin(t1.geometry, @g1); |
| 439 |
count(*) |
| 440 |
4 |
| 441 |
set @g2 = ST_GeomFromText('POINT(2 2)'); |
| 442 |
select count(*) from t1 where MBRcontains(t1.geometry, @g2); |
| 443 |
count(*) |
| 444 |
0 |
| 445 |
select count(*) from t1 where MBRintersects(t1.geometry, @g2); |
| 446 |
count(*) |
| 447 |
1 |
| 448 |
set @g3 = ST_GeomFromText('LINESTRING(2 2, 2 12)'); |
| 449 |
select count(*) from t1 where MBRintersects(t1.geometry, @g3); |
| 450 |
count(*) |
| 451 |
2 |
| 452 |
DROP TABLE t1; |
| 453 |
CREATE TABLE t1 ( |
| 454 |
c1 geometry NOT NULL SRID 0, |
| 455 |
SPATIAL KEY i1 (c1) |
| 456 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 457 |
INSERT INTO t1 (c1) VALUES ( |
| 458 |
ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 459 |
-18.6055555000 -66.8158332999, |
| 460 |
-18.7186111000 -66.8102777000, |
| 461 |
-18.7211111000 -66.9269443999, |
| 462 |
-18.6086111000 -66.9327777000))')); |
| 463 |
CHECK TABLE t1 EXTENDED; |
| 464 |
Table Op Msg_type Msg_text |
| 465 |
test.t1 check status OK |
| 466 |
DROP TABLE t1; |
| 467 |
CREATE TABLE t1 ( |
| 468 |
c1 geometry NOT NULL SRID 0, |
| 469 |
SPATIAL KEY i1 (c1) |
| 470 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 471 |
INSERT INTO t1 (c1) VALUES ( |
| 472 |
ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 473 |
-18.6055555000 -66.8158332999, |
| 474 |
-18.7186111000 -66.8102777000, |
| 475 |
-18.7211111000 -66.9269443999, |
| 476 |
-18.6086111000 -66.9327777000))')); |
| 477 |
INSERT INTO t1 (c1) VALUES ( |
| 478 |
ST_PolygonFromText('POLYGON((-65.7402776999 -96.6686111000, |
| 479 |
-65.7372222000 -96.5516666000, |
| 480 |
-65.8502777000 -96.5461111000, |
| 481 |
-65.8527777000 -96.6627777000, |
| 482 |
-65.7402776999 -96.6686111000))')); |
| 483 |
INSERT INTO t1 (c1) VALUES ( |
| 484 |
ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 485 |
-18.6055555000 -66.8158332999, |
| 486 |
-18.7186111000 -66.8102777000, |
| 487 |
-18.7211111000 -66.9269443999, |
| 488 |
-18.6086111000 -66.9327777000))')); |
| 489 |
CHECK TABLE t1 EXTENDED; |
| 490 |
Table Op Msg_type Msg_text |
| 491 |
test.t1 check status OK |
| 492 |
DROP TABLE t1; |
| 493 |
SET sql_mode = default; |
| 494 |
CREATE TABLE t1 (foo GEOMETRY NOT NULL SRID 0, SPATIAL INDEX(foo) ); |
| 495 |
INSERT INTO t1 (foo) VALUES (POINT(1,1)); |
| 496 |
INSERT INTO t1 (foo) VALUES (POINT(1,0)); |
| 497 |
INSERT INTO t1 (foo) VALUES (POINT(0,1)); |
| 498 |
INSERT INTO t1 (foo) VALUES (POINT(0,0)); |
| 499 |
SELECT 1 FROM t1 WHERE foo != POINT(0,0); |
| 500 |
1 |
| 501 |
1 |
| 502 |
1 |
| 503 |
1 |
| 504 |
DROP TABLE t1; |
| 505 |
CREATE TABLE t1 (id bigint(12) unsigned NOT NULL auto_increment, |
| 506 |
c2 varchar(15) collate utf8_bin default NULL, |
| 507 |
c1 varchar(15) collate utf8_bin default NULL, |
| 508 |
c3 varchar(10) collate utf8_bin default NULL, |
| 509 |
spatial_point point NOT NULL SRID 0, |
| 510 |
PRIMARY KEY(id), |
| 511 |
SPATIAL KEY (spatial_point) |
| 512 |
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 513 |
Warnings: |
| 514 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 515 |
Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. |
| 516 |
Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. |
| 517 |
Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. |
| 518 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 519 |
Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. |
| 520 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 521 |
('y', 's', 'j', ST_GeomFromText('POINT(167 74)')), |
| 522 |
('r', 'n', 'd', ST_GeomFromText('POINT(215 118)')), |
| 523 |
('g', 'n', 'e', ST_GeomFromText('POINT(203 98)')), |
| 524 |
('h', 'd', 'd', ST_GeomFromText('POINT(54 193)')), |
| 525 |
('r', 'x', 'y', ST_GeomFromText('POINT(47 69)')), |
| 526 |
('t', 'q', 'r', ST_GeomFromText('POINT(109 42)')), |
| 527 |
('a', 'z', 'd', ST_GeomFromText('POINT(0 154)')), |
| 528 |
('x', 'v', 'o', ST_GeomFromText('POINT(174 131)')), |
| 529 |
('b', 'r', 'a', ST_GeomFromText('POINT(114 253)')), |
| 530 |
('x', 'z', 'i', ST_GeomFromText('POINT(163 21)')), |
| 531 |
('w', 'p', 'i', ST_GeomFromText('POINT(42 102)')), |
| 532 |
('g', 'j', 'j', ST_GeomFromText('POINT(170 133)')), |
| 533 |
('m', 'g', 'n', ST_GeomFromText('POINT(28 22)')), |
| 534 |
('b', 'z', 'h', ST_GeomFromText('POINT(174 28)')), |
| 535 |
('q', 'k', 'f', ST_GeomFromText('POINT(233 73)')), |
| 536 |
('w', 'w', 'a', ST_GeomFromText('POINT(124 200)')), |
| 537 |
('t', 'j', 'w', ST_GeomFromText('POINT(252 101)')), |
| 538 |
('d', 'r', 'd', ST_GeomFromText('POINT(98 18)')), |
| 539 |
('w', 'o', 'y', ST_GeomFromText('POINT(165 31)')), |
| 540 |
('y', 'h', 't', ST_GeomFromText('POINT(14 220)')), |
| 541 |
('d', 'p', 'u', ST_GeomFromText('POINT(223 196)')), |
| 542 |
('g', 'y', 'g', ST_GeomFromText('POINT(207 96)')), |
| 543 |
('x', 'm', 'n', ST_GeomFromText('POINT(214 3)')), |
| 544 |
('g', 'v', 'e', ST_GeomFromText('POINT(140 205)')), |
| 545 |
('g', 'm', 'm', ST_GeomFromText('POINT(10 236)')), |
| 546 |
('i', 'r', 'j', ST_GeomFromText('POINT(137 228)')), |
| 547 |
('w', 's', 'p', ST_GeomFromText('POINT(115 6)')), |
| 548 |
('o', 'n', 'k', ST_GeomFromText('POINT(158 129)')), |
| 549 |
('j', 'h', 'l', ST_GeomFromText('POINT(129 72)')), |
| 550 |
('f', 'x', 'l', ST_GeomFromText('POINT(139 207)')), |
| 551 |
('u', 'd', 'n', ST_GeomFromText('POINT(125 109)')), |
| 552 |
('b', 'a', 'z', ST_GeomFromText('POINT(30 32)')), |
| 553 |
('m', 'h', 'o', ST_GeomFromText('POINT(251 251)')), |
| 554 |
('f', 'r', 'd', ST_GeomFromText('POINT(243 211)')), |
| 555 |
('b', 'd', 'r', ST_GeomFromText('POINT(232 80)')), |
| 556 |
('g', 'k', 'v', ST_GeomFromText('POINT(15 100)')), |
| 557 |
('i', 'f', 'c', ST_GeomFromText('POINT(109 66)')), |
| 558 |
('r', 't', 'j', ST_GeomFromText('POINT(178 6)')), |
| 559 |
('y', 'n', 'f', ST_GeomFromText('POINT(233 211)')), |
| 560 |
('f', 'y', 'm', ST_GeomFromText('POINT(99 16)')), |
| 561 |
('z', 'q', 'l', ST_GeomFromText('POINT(39 49)')), |
| 562 |
('j', 'c', 'r', ST_GeomFromText('POINT(75 187)')), |
| 563 |
('c', 'y', 'y', ST_GeomFromText('POINT(246 253)')), |
| 564 |
('w', 'u', 'd', ST_GeomFromText('POINT(56 190)')), |
| 565 |
('n', 'q', 'm', ST_GeomFromText('POINT(73 149)')), |
| 566 |
('d', 'y', 'a', ST_GeomFromText('POINT(134 6)')), |
| 567 |
('z', 's', 'w', ST_GeomFromText('POINT(216 225)')), |
| 568 |
('d', 'u', 'k', ST_GeomFromText('POINT(132 70)')), |
| 569 |
('f', 'v', 't', ST_GeomFromText('POINT(187 141)')), |
| 570 |
('r', 'r', 'a', ST_GeomFromText('POINT(152 39)')), |
| 571 |
('y', 'p', 'o', ST_GeomFromText('POINT(45 27)')), |
| 572 |
('p', 'n', 'm', ST_GeomFromText('POINT(228 148)')), |
| 573 |
('e', 'g', 'e', ST_GeomFromText('POINT(88 81)')), |
| 574 |
('m', 'a', 'h', ST_GeomFromText('POINT(35 29)')), |
| 575 |
('m', 'h', 'f', ST_GeomFromText('POINT(30 71)')), |
| 576 |
('h', 'k', 'i', ST_GeomFromText('POINT(244 78)')), |
| 577 |
('z', 'v', 'd', ST_GeomFromText('POINT(241 38)')), |
| 578 |
('q', 'l', 'j', ST_GeomFromText('POINT(13 71)')), |
| 579 |
('s', 'p', 'g', ST_GeomFromText('POINT(108 38)')), |
| 580 |
('q', 's', 'j', ST_GeomFromText('POINT(92 101)')), |
| 581 |
('l', 'h', 'g', ST_GeomFromText('POINT(120 78)')), |
| 582 |
('w', 't', 'b', ST_GeomFromText('POINT(193 109)')), |
| 583 |
('b', 's', 's', ST_GeomFromText('POINT(223 211)')), |
| 584 |
('w', 'w', 'y', ST_GeomFromText('POINT(122 42)')), |
| 585 |
('q', 'c', 'c', ST_GeomFromText('POINT(104 102)')), |
| 586 |
('w', 'g', 'n', ST_GeomFromText('POINT(213 120)')), |
| 587 |
('p', 'q', 'a', ST_GeomFromText('POINT(247 148)')), |
| 588 |
('c', 'z', 'e', ST_GeomFromText('POINT(18 106)')), |
| 589 |
('z', 'u', 'n', ST_GeomFromText('POINT(70 133)')), |
| 590 |
('j', 'n', 'x', ST_GeomFromText('POINT(232 13)')), |
| 591 |
('e', 'h', 'f', ST_GeomFromText('POINT(22 135)')), |
| 592 |
('w', 'l', 'f', ST_GeomFromText('POINT(9 180)')), |
| 593 |
('a', 'v', 'q', ST_GeomFromText('POINT(163 228)')), |
| 594 |
('i', 'z', 'o', ST_GeomFromText('POINT(180 100)')), |
| 595 |
('e', 'c', 'l', ST_GeomFromText('POINT(182 231)')), |
| 596 |
('c', 'k', 'o', ST_GeomFromText('POINT(19 60)')), |
| 597 |
('q', 'f', 'p', ST_GeomFromText('POINT(79 95)')), |
| 598 |
('m', 'd', 'r', ST_GeomFromText('POINT(3 127)')), |
| 599 |
('m', 'e', 't', ST_GeomFromText('POINT(136 154)')), |
| 600 |
('w', 'w', 'w', ST_GeomFromText('POINT(102 15)')), |
| 601 |
('l', 'n', 'q', ST_GeomFromText('POINT(71 196)')), |
| 602 |
('p', 'k', 'c', ST_GeomFromText('POINT(47 139)')), |
| 603 |
('j', 'o', 'r', ST_GeomFromText('POINT(177 128)')), |
| 604 |
('j', 'q', 'a', ST_GeomFromText('POINT(170 6)')), |
| 605 |
('b', 'a', 'o', ST_GeomFromText('POINT(63 211)')), |
| 606 |
('g', 's', 'o', ST_GeomFromText('POINT(144 251)')), |
| 607 |
('w', 'u', 'w', ST_GeomFromText('POINT(221 214)')), |
| 608 |
('g', 'a', 'm', ST_GeomFromText('POINT(14 102)')), |
| 609 |
('u', 'q', 'z', ST_GeomFromText('POINT(86 200)')), |
| 610 |
('k', 'a', 'm', ST_GeomFromText('POINT(144 222)')), |
| 611 |
('j', 'u', 'r', ST_GeomFromText('POINT(216 142)')), |
| 612 |
('q', 'k', 'v', ST_GeomFromText('POINT(121 236)')), |
| 613 |
('p', 'o', 'r', ST_GeomFromText('POINT(108 102)')), |
| 614 |
('b', 'd', 'x', ST_GeomFromText('POINT(127 198)')), |
| 615 |
('k', 's', 'a', ST_GeomFromText('POINT(2 150)')), |
| 616 |
('f', 'm', 'f', ST_GeomFromText('POINT(160 191)')), |
| 617 |
('q', 'y', 'x', ST_GeomFromText('POINT(98 111)')), |
| 618 |
('o', 'f', 'm', ST_GeomFromText('POINT(232 218)')), |
| 619 |
('c', 'w', 'j', ST_GeomFromText('POINT(156 165)')), |
| 620 |
('s', 'q', 'v', ST_GeomFromText('POINT(98 161)')); |
| 621 |
SET @@RAND_SEED1=692635050, @@RAND_SEED2=297339954; |
| 622 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 623 |
SET @@RAND_SEED1=159925977, @@RAND_SEED2=942570618; |
| 624 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 625 |
SET @@RAND_SEED1=328169745, @@RAND_SEED2=410451954; |
| 626 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 627 |
SET @@RAND_SEED1=178507359, @@RAND_SEED2=332493072; |
| 628 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 629 |
SET @@RAND_SEED1=1034033013, @@RAND_SEED2=558966507; |
| 630 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 631 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(230 9)') where c1 like 'y%'; |
| 632 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(95 35)') where c1 like 'j%'; |
| 633 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(93 99)') where c1 like 'a%'; |
| 634 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(19 81)') where c1 like 'r%'; |
| 635 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(20 177)') where c1 like 'h%'; |
| 636 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(221 193)') where c1 like 'u%'; |
| 637 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(195 205)') where c1 like 'd%'; |
| 638 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(15 213)') where c1 like 'u%'; |
| 639 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(214 63)') where c1 like 'n%'; |
| 640 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(243 171)') where c1 like 'c%'; |
| 641 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(198 82)') where c1 like 'y%'; |
| 642 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 643 |
('f', 'y', 'p', ST_GeomFromText('POINT(109 235)')), |
| 644 |
('b', 'e', 'v', ST_GeomFromText('POINT(20 48)')), |
| 645 |
('i', 'u', 'f', ST_GeomFromText('POINT(15 55)')), |
| 646 |
('o', 'r', 'z', ST_GeomFromText('POINT(105 64)')), |
| 647 |
('a', 'p', 'a', ST_GeomFromText('POINT(142 236)')), |
| 648 |
('g', 'i', 'k', ST_GeomFromText('POINT(10 49)')), |
| 649 |
('x', 'z', 'x', ST_GeomFromText('POINT(192 200)')), |
| 650 |
('c', 'v', 'r', ST_GeomFromText('POINT(94 168)')), |
| 651 |
('y', 'z', 'e', ST_GeomFromText('POINT(141 51)')), |
| 652 |
('h', 'm', 'd', ST_GeomFromText('POINT(35 251)')), |
| 653 |
('v', 'm', 'q', ST_GeomFromText('POINT(44 90)')), |
| 654 |
('j', 'l', 'z', ST_GeomFromText('POINT(67 237)')), |
| 655 |
('i', 'v', 'a', ST_GeomFromText('POINT(75 14)')), |
| 656 |
('b', 'q', 't', ST_GeomFromText('POINT(153 33)')), |
| 657 |
('e', 'm', 'a', ST_GeomFromText('POINT(247 49)')), |
| 658 |
('l', 'y', 'g', ST_GeomFromText('POINT(56 203)')), |
| 659 |
('v', 'o', 'r', ST_GeomFromText('POINT(90 54)')), |
| 660 |
('r', 'n', 'd', ST_GeomFromText('POINT(135 83)')), |
| 661 |
('j', 't', 'u', ST_GeomFromText('POINT(174 239)')), |
| 662 |
('u', 'n', 'g', ST_GeomFromText('POINT(104 191)')), |
| 663 |
('p', 'q', 'y', ST_GeomFromText('POINT(63 171)')), |
| 664 |
('o', 'q', 'p', ST_GeomFromText('POINT(192 103)')), |
| 665 |
('f', 'x', 'e', ST_GeomFromText('POINT(244 30)')), |
| 666 |
('n', 'x', 'c', ST_GeomFromText('POINT(92 103)')), |
| 667 |
('r', 'q', 'z', ST_GeomFromText('POINT(166 20)')), |
| 668 |
('s', 'a', 'j', ST_GeomFromText('POINT(137 205)')), |
| 669 |
('z', 't', 't', ST_GeomFromText('POINT(99 134)')), |
| 670 |
('o', 'm', 'j', ST_GeomFromText('POINT(217 3)')), |
| 671 |
('n', 'h', 'j', ST_GeomFromText('POINT(211 17)')), |
| 672 |
('v', 'v', 'a', ST_GeomFromText('POINT(41 137)')), |
| 673 |
('q', 'o', 'j', ST_GeomFromText('POINT(5 92)')), |
| 674 |
('z', 'y', 'e', ST_GeomFromText('POINT(175 212)')), |
| 675 |
('j', 'z', 'h', ST_GeomFromText('POINT(224 194)')), |
| 676 |
('a', 'g', 'm', ST_GeomFromText('POINT(31 119)')), |
| 677 |
('p', 'c', 'f', ST_GeomFromText('POINT(17 221)')), |
| 678 |
('t', 'h', 'k', ST_GeomFromText('POINT(26 203)')), |
| 679 |
('u', 'w', 'p', ST_GeomFromText('POINT(47 185)')), |
| 680 |
('z', 'a', 'c', ST_GeomFromText('POINT(61 133)')), |
| 681 |
('u', 'k', 'a', ST_GeomFromText('POINT(210 115)')), |
| 682 |
('k', 'f', 'h', ST_GeomFromText('POINT(125 113)')), |
| 683 |
('t', 'v', 'y', ST_GeomFromText('POINT(12 239)')), |
| 684 |
('u', 'v', 'd', ST_GeomFromText('POINT(90 24)')), |
| 685 |
('m', 'y', 'w', ST_GeomFromText('POINT(25 243)')), |
| 686 |
('d', 'n', 'g', ST_GeomFromText('POINT(122 92)')), |
| 687 |
('z', 'm', 'f', ST_GeomFromText('POINT(235 110)')), |
| 688 |
('q', 'd', 'f', ST_GeomFromText('POINT(233 217)')), |
| 689 |
('a', 'v', 'u', ST_GeomFromText('POINT(69 59)')), |
| 690 |
('x', 'k', 'p', ST_GeomFromText('POINT(240 14)')), |
| 691 |
('i', 'v', 'r', ST_GeomFromText('POINT(154 42)')), |
| 692 |
('w', 'h', 'l', ST_GeomFromText('POINT(178 156)')), |
| 693 |
('d', 'h', 'n', ST_GeomFromText('POINT(65 157)')), |
| 694 |
('c', 'k', 'z', ST_GeomFromText('POINT(62 33)')), |
| 695 |
('e', 'l', 'w', ST_GeomFromText('POINT(162 1)')), |
| 696 |
('r', 'f', 'i', ST_GeomFromText('POINT(127 71)')), |
| 697 |
('q', 'm', 'c', ST_GeomFromText('POINT(63 118)')), |
| 698 |
('c', 'h', 'u', ST_GeomFromText('POINT(205 203)')), |
| 699 |
('d', 't', 'p', ST_GeomFromText('POINT(234 87)')), |
| 700 |
('s', 'g', 'h', ST_GeomFromText('POINT(149 34)')), |
| 701 |
('o', 'b', 'q', ST_GeomFromText('POINT(159 179)')), |
| 702 |
('k', 'u', 'f', ST_GeomFromText('POINT(202 254)')), |
| 703 |
('u', 'f', 'g', ST_GeomFromText('POINT(70 15)')), |
| 704 |
('x', 's', 'b', ST_GeomFromText('POINT(25 181)')), |
| 705 |
('s', 'c', 'g', ST_GeomFromText('POINT(252 17)')), |
| 706 |
('a', 'c', 'f', ST_GeomFromText('POINT(89 67)')), |
| 707 |
('r', 'e', 'q', ST_GeomFromText('POINT(55 54)')), |
| 708 |
('f', 'i', 'k', ST_GeomFromText('POINT(178 230)')), |
| 709 |
('p', 'e', 'l', ST_GeomFromText('POINT(198 28)')), |
| 710 |
('w', 'o', 'd', ST_GeomFromText('POINT(204 189)')), |
| 711 |
('c', 'a', 'g', ST_GeomFromText('POINT(230 178)')), |
| 712 |
('r', 'o', 'e', ST_GeomFromText('POINT(61 116)')), |
| 713 |
('w', 'a', 'a', ST_GeomFromText('POINT(178 237)')), |
| 714 |
('v', 'd', 'e', ST_GeomFromText('POINT(70 85)')), |
| 715 |
('k', 'c', 'e', ST_GeomFromText('POINT(147 118)')), |
| 716 |
('d', 'q', 't', ST_GeomFromText('POINT(218 77)')), |
| 717 |
('k', 'g', 'f', ST_GeomFromText('POINT(192 113)')), |
| 718 |
('w', 'n', 'e', ST_GeomFromText('POINT(92 124)')), |
| 719 |
('r', 'm', 'q', ST_GeomFromText('POINT(130 65)')), |
| 720 |
('o', 'r', 'r', ST_GeomFromText('POINT(174 233)')), |
| 721 |
('k', 'n', 't', ST_GeomFromText('POINT(175 147)')), |
| 722 |
('q', 'm', 'r', ST_GeomFromText('POINT(18 208)')), |
| 723 |
('l', 'd', 'i', ST_GeomFromText('POINT(13 104)')), |
| 724 |
('w', 'o', 'y', ST_GeomFromText('POINT(207 39)')), |
| 725 |
('p', 'u', 'o', ST_GeomFromText('POINT(114 31)')), |
| 726 |
('y', 'a', 'p', ST_GeomFromText('POINT(106 59)')), |
| 727 |
('a', 'x', 'z', ST_GeomFromText('POINT(17 57)')), |
| 728 |
('v', 'h', 'x', ST_GeomFromText('POINT(170 13)')), |
| 729 |
('t', 's', 'u', ST_GeomFromText('POINT(84 18)')), |
| 730 |
('z', 'z', 'f', ST_GeomFromText('POINT(250 197)')), |
| 731 |
('l', 'z', 't', ST_GeomFromText('POINT(59 80)')), |
| 732 |
('j', 'g', 's', ST_GeomFromText('POINT(54 26)')), |
| 733 |
('g', 'v', 'm', ST_GeomFromText('POINT(89 98)')), |
| 734 |
('q', 'v', 'b', ST_GeomFromText('POINT(39 240)')), |
| 735 |
('x', 'k', 'v', ST_GeomFromText('POINT(246 207)')), |
| 736 |
('k', 'u', 'i', ST_GeomFromText('POINT(105 111)')), |
| 737 |
('w', 'z', 's', ST_GeomFromText('POINT(235 8)')), |
| 738 |
('d', 'd', 'd', ST_GeomFromText('POINT(105 4)')), |
| 739 |
('c', 'z', 'q', ST_GeomFromText('POINT(13 140)')), |
| 740 |
('m', 'k', 'i', ST_GeomFromText('POINT(208 120)')), |
| 741 |
('g', 'a', 'g', ST_GeomFromText('POINT(9 182)')), |
| 742 |
('z', 'j', 'r', ST_GeomFromText('POINT(149 153)')), |
| 743 |
('h', 'f', 'g', ST_GeomFromText('POINT(81 236)')), |
| 744 |
('m', 'e', 'q', ST_GeomFromText('POINT(209 215)')), |
| 745 |
('c', 'h', 'y', ST_GeomFromText('POINT(235 70)')), |
| 746 |
('i', 'e', 'g', ST_GeomFromText('POINT(138 26)')), |
| 747 |
('m', 't', 'u', ST_GeomFromText('POINT(119 237)')), |
| 748 |
('o', 'w', 's', ST_GeomFromText('POINT(193 166)')), |
| 749 |
('f', 'm', 'q', ST_GeomFromText('POINT(85 96)')), |
| 750 |
('x', 'l', 'x', ST_GeomFromText('POINT(58 115)')), |
| 751 |
('x', 'q', 'u', ST_GeomFromText('POINT(108 210)')), |
| 752 |
('b', 'h', 'i', ST_GeomFromText('POINT(250 139)')), |
| 753 |
('y', 'd', 'x', ST_GeomFromText('POINT(199 135)')), |
| 754 |
('w', 'h', 'p', ST_GeomFromText('POINT(247 233)')), |
| 755 |
('p', 'z', 't', ST_GeomFromText('POINT(148 249)')), |
| 756 |
('q', 'a', 'u', ST_GeomFromText('POINT(174 78)')), |
| 757 |
('v', 't', 'm', ST_GeomFromText('POINT(70 228)')), |
| 758 |
('t', 'n', 'f', ST_GeomFromText('POINT(123 2)')), |
| 759 |
('x', 't', 'b', ST_GeomFromText('POINT(35 50)')), |
| 760 |
('r', 'j', 'f', ST_GeomFromText('POINT(200 51)')), |
| 761 |
('s', 'q', 'o', ST_GeomFromText('POINT(23 184)')), |
| 762 |
('u', 'v', 'z', ST_GeomFromText('POINT(7 113)')), |
| 763 |
('v', 'u', 'l', ST_GeomFromText('POINT(145 190)')), |
| 764 |
('o', 'k', 'i', ST_GeomFromText('POINT(161 122)')), |
| 765 |
('l', 'y', 'e', ST_GeomFromText('POINT(17 232)')), |
| 766 |
('t', 'b', 'e', ST_GeomFromText('POINT(120 50)')), |
| 767 |
('e', 's', 'u', ST_GeomFromText('POINT(254 1)')), |
| 768 |
('d', 'd', 'u', ST_GeomFromText('POINT(167 140)')), |
| 769 |
('o', 'b', 'x', ST_GeomFromText('POINT(186 237)')), |
| 770 |
('m', 's', 's', ST_GeomFromText('POINT(172 149)')), |
| 771 |
('t', 'y', 'a', ST_GeomFromText('POINT(149 85)')), |
| 772 |
('x', 't', 'r', ST_GeomFromText('POINT(10 165)')), |
| 773 |
('g', 'c', 'e', ST_GeomFromText('POINT(95 165)')), |
| 774 |
('e', 'e', 'z', ST_GeomFromText('POINT(98 65)')), |
| 775 |
('f', 'v', 'i', ST_GeomFromText('POINT(149 144)')), |
| 776 |
('o', 'p', 'm', ST_GeomFromText('POINT(233 67)')), |
| 777 |
('t', 'u', 'b', ST_GeomFromText('POINT(109 215)')), |
| 778 |
('o', 'o', 'b', ST_GeomFromText('POINT(130 48)')), |
| 779 |
('e', 'm', 'h', ST_GeomFromText('POINT(88 189)')), |
| 780 |
('e', 'v', 'y', ST_GeomFromText('POINT(55 29)')), |
| 781 |
('e', 't', 'm', ST_GeomFromText('POINT(129 55)')), |
| 782 |
('p', 'p', 'i', ST_GeomFromText('POINT(126 222)')), |
| 783 |
('c', 'i', 'c', ST_GeomFromText('POINT(19 158)')), |
| 784 |
('c', 'b', 's', ST_GeomFromText('POINT(13 19)')), |
| 785 |
('u', 'y', 'a', ST_GeomFromText('POINT(114 5)')), |
| 786 |
('a', 'o', 'f', ST_GeomFromText('POINT(227 232)')), |
| 787 |
('t', 'c', 'z', ST_GeomFromText('POINT(63 62)')), |
| 788 |
('d', 'o', 'k', ST_GeomFromText('POINT(48 228)')), |
| 789 |
('x', 'c', 'e', ST_GeomFromText('POINT(204 2)')), |
| 790 |
('e', 'e', 'g', ST_GeomFromText('POINT(125 43)')), |
| 791 |
('o', 'r', 'f', ST_GeomFromText('POINT(171 140)')); |
| 792 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(163 157)') where c1 like 'w%'; |
| 793 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(53 151)') where c1 like 'd%'; |
| 794 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(96 183)') where c1 like 'r%'; |
| 795 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(57 91)') where c1 like 'q%'; |
| 796 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(202 110)') where c1 like 'c%'; |
| 797 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(120 137)') where c1 like 'w%'; |
| 798 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(207 147)') where c1 like 'c%'; |
| 799 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(31 125)') where c1 like 'e%'; |
| 800 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(27 36)') where c1 like 'r%'; |
| 801 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 802 |
('b', 'c', 'e', ST_GeomFromText('POINT(41 137)')), |
| 803 |
('p', 'y', 'k', ST_GeomFromText('POINT(50 22)')), |
| 804 |
('s', 'c', 'h', ST_GeomFromText('POINT(208 173)')), |
| 805 |
('x', 'u', 'l', ST_GeomFromText('POINT(199 175)')), |
| 806 |
('s', 'r', 'h', ST_GeomFromText('POINT(85 192)')), |
| 807 |
('j', 'k', 'u', ST_GeomFromText('POINT(18 25)')), |
| 808 |
('p', 'w', 'h', ST_GeomFromText('POINT(152 197)')), |
| 809 |
('e', 'd', 'c', ST_GeomFromText('POINT(229 3)')), |
| 810 |
('o', 'x', 'k', ST_GeomFromText('POINT(187 155)')), |
| 811 |
('o', 'b', 'k', ST_GeomFromText('POINT(208 150)')), |
| 812 |
('d', 'a', 'j', ST_GeomFromText('POINT(70 87)')), |
| 813 |
('f', 'e', 'k', ST_GeomFromText('POINT(156 96)')), |
| 814 |
('u', 'y', 'p', ST_GeomFromText('POINT(239 193)')), |
| 815 |
('n', 'v', 'p', ST_GeomFromText('POINT(223 98)')), |
| 816 |
('z', 'j', 'r', ST_GeomFromText('POINT(87 89)')), |
| 817 |
('h', 'x', 'x', ST_GeomFromText('POINT(92 0)')), |
| 818 |
('r', 'v', 'r', ST_GeomFromText('POINT(159 139)')), |
| 819 |
('v', 'g', 'g', ST_GeomFromText('POINT(16 229)')), |
| 820 |
('z', 'k', 'u', ST_GeomFromText('POINT(99 52)')), |
| 821 |
('p', 'p', 'o', ST_GeomFromText('POINT(105 125)')), |
| 822 |
('w', 'h', 'y', ST_GeomFromText('POINT(105 154)')), |
| 823 |
('v', 'y', 'z', ST_GeomFromText('POINT(134 238)')), |
| 824 |
('x', 'o', 'o', ST_GeomFromText('POINT(178 88)')), |
| 825 |
('z', 'w', 'd', ST_GeomFromText('POINT(123 60)')), |
| 826 |
('q', 'f', 'u', ST_GeomFromText('POINT(64 90)')), |
| 827 |
('s', 'n', 't', ST_GeomFromText('POINT(50 138)')), |
| 828 |
('v', 'p', 't', ST_GeomFromText('POINT(114 91)')), |
| 829 |
('a', 'o', 'n', ST_GeomFromText('POINT(78 43)')), |
| 830 |
('k', 'u', 'd', ST_GeomFromText('POINT(185 161)')), |
| 831 |
('w', 'd', 'n', ST_GeomFromText('POINT(25 92)')), |
| 832 |
('k', 'w', 'a', ST_GeomFromText('POINT(59 238)')), |
| 833 |
('t', 'c', 'f', ST_GeomFromText('POINT(65 87)')), |
| 834 |
('g', 's', 'p', ST_GeomFromText('POINT(238 126)')), |
| 835 |
('d', 'n', 'y', ST_GeomFromText('POINT(107 173)')), |
| 836 |
('l', 'a', 'w', ST_GeomFromText('POINT(125 152)')), |
| 837 |
('m', 'd', 'j', ST_GeomFromText('POINT(146 53)')), |
| 838 |
('q', 'm', 'c', ST_GeomFromText('POINT(217 187)')), |
| 839 |
('i', 'r', 'r', ST_GeomFromText('POINT(6 113)')), |
| 840 |
('e', 'j', 'b', ST_GeomFromText('POINT(37 83)')), |
| 841 |
('w', 'w', 'h', ST_GeomFromText('POINT(83 199)')), |
| 842 |
('k', 'b', 's', ST_GeomFromText('POINT(170 64)')), |
| 843 |
('s', 'b', 'c', ST_GeomFromText('POINT(163 130)')), |
| 844 |
('c', 'h', 'a', ST_GeomFromText('POINT(141 3)')), |
| 845 |
('k', 'j', 'u', ST_GeomFromText('POINT(143 76)')), |
| 846 |
('r', 'h', 'o', ST_GeomFromText('POINT(243 92)')), |
| 847 |
('i', 'd', 'b', ST_GeomFromText('POINT(205 13)')), |
| 848 |
('r', 'y', 'q', ST_GeomFromText('POINT(138 8)')), |
| 849 |
('m', 'o', 'i', ST_GeomFromText('POINT(36 45)')), |
| 850 |
('v', 'g', 'm', ST_GeomFromText('POINT(0 40)')), |
| 851 |
('f', 'e', 'i', ST_GeomFromText('POINT(76 6)')), |
| 852 |
('c', 'q', 'q', ST_GeomFromText('POINT(115 248)')), |
| 853 |
('x', 'c', 'i', ST_GeomFromText('POINT(29 74)')), |
| 854 |
('l', 's', 't', ST_GeomFromText('POINT(83 18)')), |
| 855 |
('t', 't', 'a', ST_GeomFromText('POINT(26 168)')), |
| 856 |
('u', 'n', 'x', ST_GeomFromText('POINT(200 110)')), |
| 857 |
('j', 'b', 'd', ST_GeomFromText('POINT(216 136)')), |
| 858 |
('s', 'p', 'w', ST_GeomFromText('POINT(38 156)')), |
| 859 |
('f', 'b', 'v', ST_GeomFromText('POINT(29 186)')), |
| 860 |
('v', 'e', 'r', ST_GeomFromText('POINT(149 40)')), |
| 861 |
('v', 't', 'm', ST_GeomFromText('POINT(184 24)')), |
| 862 |
('y', 'g', 'a', ST_GeomFromText('POINT(219 105)')), |
| 863 |
('s', 'f', 'i', ST_GeomFromText('POINT(114 130)')), |
| 864 |
('e', 'q', 'h', ST_GeomFromText('POINT(203 135)')), |
| 865 |
('h', 'g', 'b', ST_GeomFromText('POINT(9 208)')), |
| 866 |
('o', 'l', 'r', ST_GeomFromText('POINT(245 79)')), |
| 867 |
('s', 's', 'v', ST_GeomFromText('POINT(238 198)')), |
| 868 |
('w', 'w', 'z', ST_GeomFromText('POINT(209 232)')), |
| 869 |
('v', 'd', 'n', ST_GeomFromText('POINT(30 193)')), |
| 870 |
('q', 'w', 'k', ST_GeomFromText('POINT(133 18)')), |
| 871 |
('o', 'h', 'o', ST_GeomFromText('POINT(42 140)')), |
| 872 |
('f', 'f', 'h', ST_GeomFromText('POINT(145 1)')), |
| 873 |
('u', 's', 'r', ST_GeomFromText('POINT(70 62)')), |
| 874 |
('x', 'n', 'q', ST_GeomFromText('POINT(33 86)')), |
| 875 |
('u', 'p', 'v', ST_GeomFromText('POINT(232 220)')), |
| 876 |
('z', 'e', 'a', ST_GeomFromText('POINT(130 69)')), |
| 877 |
('r', 'u', 'z', ST_GeomFromText('POINT(243 241)')), |
| 878 |
('b', 'n', 't', ST_GeomFromText('POINT(120 12)')), |
| 879 |
('u', 'f', 's', ST_GeomFromText('POINT(190 212)')), |
| 880 |
('a', 'd', 'q', ST_GeomFromText('POINT(235 191)')), |
| 881 |
('f', 'q', 'm', ST_GeomFromText('POINT(176 2)')), |
| 882 |
('n', 'c', 's', ST_GeomFromText('POINT(218 163)')), |
| 883 |
('e', 'm', 'h', ST_GeomFromText('POINT(163 108)')), |
| 884 |
('c', 'f', 'l', ST_GeomFromText('POINT(220 115)')), |
| 885 |
('c', 'v', 'q', ST_GeomFromText('POINT(66 45)')), |
| 886 |
('w', 'v', 'x', ST_GeomFromText('POINT(251 220)')), |
| 887 |
('f', 'w', 'z', ST_GeomFromText('POINT(146 149)')), |
| 888 |
('h', 'n', 'h', ST_GeomFromText('POINT(148 128)')), |
| 889 |
('y', 'k', 'v', ST_GeomFromText('POINT(28 110)')), |
| 890 |
('c', 'x', 'q', ST_GeomFromText('POINT(13 13)')), |
| 891 |
('e', 'd', 's', ST_GeomFromText('POINT(91 190)')), |
| 892 |
('c', 'w', 'c', ST_GeomFromText('POINT(10 231)')), |
| 893 |
('u', 'j', 'n', ST_GeomFromText('POINT(250 21)')), |
| 894 |
('w', 'n', 'x', ST_GeomFromText('POINT(141 69)')), |
| 895 |
('f', 'p', 'y', ST_GeomFromText('POINT(228 246)')), |
| 896 |
('d', 'q', 'f', ST_GeomFromText('POINT(194 22)')), |
| 897 |
('d', 'z', 'l', ST_GeomFromText('POINT(233 181)')), |
| 898 |
('c', 'a', 'q', ST_GeomFromText('POINT(183 96)')), |
| 899 |
('m', 'i', 'd', ST_GeomFromText('POINT(117 226)')), |
| 900 |
('z', 'y', 'y', ST_GeomFromText('POINT(62 81)')), |
| 901 |
('g', 'v', 'm', ST_GeomFromText('POINT(66 158)')); |
| 902 |
SET @@RAND_SEED1=481064922, @@RAND_SEED2=438133497; |
| 903 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 904 |
SET @@RAND_SEED1=280535103, @@RAND_SEED2=444518646; |
| 905 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 906 |
SET @@RAND_SEED1=1072017234, @@RAND_SEED2=484203885; |
| 907 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 908 |
SET @@RAND_SEED1=358851897, @@RAND_SEED2=358495224; |
| 909 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 910 |
SET @@RAND_SEED1=509031459, @@RAND_SEED2=675962925; |
| 911 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 912 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(202 194)') where c1 like 'f%'; |
| 913 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(228 18)') where c1 like 'h%'; |
| 914 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(88 18)') where c1 like 'l%'; |
| 915 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(176 94)') where c1 like 'e%'; |
| 916 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(44 47)') where c1 like 'g%'; |
| 917 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(95 191)') where c1 like 'b%'; |
| 918 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(179 218)') where c1 like 'y%'; |
| 919 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(239 40)') where c1 like 'g%'; |
| 920 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(248 41)') where c1 like 'q%'; |
| 921 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(167 82)') where c1 like 't%'; |
| 922 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(13 104)') where c1 like 'u%'; |
| 923 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(139 84)') where c1 like 'a%'; |
| 924 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(145 108)') where c1 like 'p%'; |
| 925 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(147 57)') where c1 like 't%'; |
| 926 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(217 144)') where c1 like 'n%'; |
| 927 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(160 224)') where c1 like 'w%'; |
| 928 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(38 28)') where c1 like 'j%'; |
| 929 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(104 114)') where c1 like 'q%'; |
| 930 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(88 19)') where c1 like 'c%'; |
| 931 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 932 |
('f', 'x', 'p', ST_GeomFromText('POINT(92 181)')), |
| 933 |
('s', 'i', 'c', ST_GeomFromText('POINT(49 60)')), |
| 934 |
('c', 'c', 'i', ST_GeomFromText('POINT(7 57)')), |
| 935 |
('n', 'g', 'k', ST_GeomFromText('POINT(252 105)')), |
| 936 |
('g', 'b', 'm', ST_GeomFromText('POINT(180 11)')), |
| 937 |
('u', 'l', 'r', ST_GeomFromText('POINT(32 90)')), |
| 938 |
('c', 'x', 'e', ST_GeomFromText('POINT(143 24)')), |
| 939 |
('x', 'u', 'a', ST_GeomFromText('POINT(123 92)')), |
| 940 |
('s', 'b', 'h', ST_GeomFromText('POINT(190 108)')), |
| 941 |
('c', 'x', 'b', ST_GeomFromText('POINT(104 100)')), |
| 942 |
('i', 'd', 't', ST_GeomFromText('POINT(214 104)')), |
| 943 |
('r', 'w', 'g', ST_GeomFromText('POINT(29 67)')), |
| 944 |
('b', 'f', 'g', ST_GeomFromText('POINT(149 46)')), |
| 945 |
('r', 'r', 'd', ST_GeomFromText('POINT(242 196)')), |
| 946 |
('j', 'l', 'a', ST_GeomFromText('POINT(90 196)')), |
| 947 |
('e', 't', 'b', ST_GeomFromText('POINT(190 64)')), |
| 948 |
('l', 'x', 'w', ST_GeomFromText('POINT(250 73)')), |
| 949 |
('q', 'y', 'r', ST_GeomFromText('POINT(120 182)')), |
| 950 |
('s', 'j', 'a', ST_GeomFromText('POINT(180 175)')), |
| 951 |
('n', 'i', 'y', ST_GeomFromText('POINT(124 136)')), |
| 952 |
('s', 'x', 's', ST_GeomFromText('POINT(176 209)')), |
| 953 |
('u', 'f', 's', ST_GeomFromText('POINT(215 173)')), |
| 954 |
('m', 'j', 'x', ST_GeomFromText('POINT(44 140)')), |
| 955 |
('v', 'g', 'x', ST_GeomFromText('POINT(177 233)')), |
| 956 |
('u', 't', 'b', ST_GeomFromText('POINT(136 197)')), |
| 957 |
('f', 'g', 'b', ST_GeomFromText('POINT(10 8)')), |
| 958 |
('v', 'c', 'j', ST_GeomFromText('POINT(13 81)')), |
| 959 |
('d', 's', 'q', ST_GeomFromText('POINT(200 100)')), |
| 960 |
('a', 'p', 'j', ST_GeomFromText('POINT(33 40)')), |
| 961 |
('i', 'c', 'g', ST_GeomFromText('POINT(168 204)')), |
| 962 |
('k', 'h', 'i', ST_GeomFromText('POINT(93 243)')), |
| 963 |
('s', 'b', 's', ST_GeomFromText('POINT(157 13)')), |
| 964 |
('v', 'l', 'l', ST_GeomFromText('POINT(103 6)')), |
| 965 |
('r', 'b', 'k', ST_GeomFromText('POINT(244 137)')), |
| 966 |
('l', 'd', 'r', ST_GeomFromText('POINT(162 254)')), |
| 967 |
('q', 'b', 'z', ST_GeomFromText('POINT(136 246)')), |
| 968 |
('x', 'x', 'p', ST_GeomFromText('POINT(120 37)')), |
| 969 |
('m', 'e', 'z', ST_GeomFromText('POINT(203 167)')), |
| 970 |
('q', 'n', 'p', ST_GeomFromText('POINT(94 119)')), |
| 971 |
('b', 'g', 'u', ST_GeomFromText('POINT(93 248)')), |
| 972 |
('r', 'v', 'v', ST_GeomFromText('POINT(53 88)')), |
| 973 |
('y', 'a', 'i', ST_GeomFromText('POINT(98 219)')), |
| 974 |
('a', 's', 'g', ST_GeomFromText('POINT(173 138)')), |
| 975 |
('c', 'a', 't', ST_GeomFromText('POINT(235 135)')), |
| 976 |
('q', 'm', 'd', ST_GeomFromText('POINT(224 208)')), |
| 977 |
('e', 'p', 'k', ST_GeomFromText('POINT(161 238)')), |
| 978 |
('n', 'g', 'q', ST_GeomFromText('POINT(35 204)')), |
| 979 |
('t', 't', 'x', ST_GeomFromText('POINT(230 178)')), |
| 980 |
('w', 'f', 'a', ST_GeomFromText('POINT(150 221)')), |
| 981 |
('z', 'm', 'z', ST_GeomFromText('POINT(119 42)')), |
| 982 |
('l', 'j', 's', ST_GeomFromText('POINT(97 96)')), |
| 983 |
('f', 'z', 'x', ST_GeomFromText('POINT(208 65)')), |
| 984 |
('i', 'v', 'c', ST_GeomFromText('POINT(145 79)')), |
| 985 |
('l', 'f', 'k', ST_GeomFromText('POINT(83 234)')), |
| 986 |
('u', 'a', 's', ST_GeomFromText('POINT(250 49)')), |
| 987 |
('o', 'k', 'p', ST_GeomFromText('POINT(46 50)')), |
| 988 |
('d', 'e', 'z', ST_GeomFromText('POINT(30 198)')), |
| 989 |
('r', 'r', 'l', ST_GeomFromText('POINT(78 189)')), |
| 990 |
('y', 'l', 'f', ST_GeomFromText('POINT(188 132)')), |
| 991 |
('d', 'q', 'm', ST_GeomFromText('POINT(247 107)')), |
| 992 |
('p', 'j', 'n', ST_GeomFromText('POINT(148 227)')), |
| 993 |
('b', 'o', 'i', ST_GeomFromText('POINT(172 25)')), |
| 994 |
('e', 'v', 'd', ST_GeomFromText('POINT(94 248)')), |
| 995 |
('q', 'd', 'f', ST_GeomFromText('POINT(15 29)')), |
| 996 |
('w', 'b', 'b', ST_GeomFromText('POINT(74 111)')), |
| 997 |
('g', 'q', 'f', ST_GeomFromText('POINT(107 215)')), |
| 998 |
('o', 'h', 'r', ST_GeomFromText('POINT(25 168)')), |
| 999 |
('u', 't', 'w', ST_GeomFromText('POINT(251 188)')), |
| 1000 |
('h', 's', 'w', ST_GeomFromText('POINT(254 247)')), |
| 1001 |
('f', 'f', 'b', ST_GeomFromText('POINT(166 103)')); |
| 1002 |
SET @@RAND_SEED1=866613816, @@RAND_SEED2=92289615; |
| 1003 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 1004 |
('l', 'c', 'l', ST_GeomFromText('POINT(202 98)')), |
| 1005 |
('k', 'c', 'b', ST_GeomFromText('POINT(46 206)')), |
| 1006 |
('r', 'y', 'm', ST_GeomFromText('POINT(74 140)')), |
| 1007 |
('y', 'z', 'd', ST_GeomFromText('POINT(200 160)')), |
| 1008 |
('s', 'y', 's', ST_GeomFromText('POINT(156 205)')), |
| 1009 |
('u', 'v', 'p', ST_GeomFromText('POINT(86 82)')), |
| 1010 |
('j', 's', 's', ST_GeomFromText('POINT(91 233)')), |
| 1011 |
('x', 'j', 'f', ST_GeomFromText('POINT(3 14)')), |
| 1012 |
('l', 'z', 'v', ST_GeomFromText('POINT(123 156)')), |
| 1013 |
('h', 'i', 'o', ST_GeomFromText('POINT(145 229)')), |
| 1014 |
('o', 'r', 'd', ST_GeomFromText('POINT(15 22)')), |
| 1015 |
('f', 'x', 't', ST_GeomFromText('POINT(21 60)')), |
| 1016 |
('t', 'g', 'h', ST_GeomFromText('POINT(50 153)')), |
| 1017 |
('g', 'u', 'b', ST_GeomFromText('POINT(82 85)')), |
| 1018 |
('v', 'a', 'p', ST_GeomFromText('POINT(231 178)')), |
| 1019 |
('n', 'v', 'o', ST_GeomFromText('POINT(183 25)')), |
| 1020 |
('j', 'n', 'm', ST_GeomFromText('POINT(50 144)')), |
| 1021 |
('e', 'f', 'i', ST_GeomFromText('POINT(46 16)')), |
| 1022 |
('d', 'w', 'a', ST_GeomFromText('POINT(66 6)')), |
| 1023 |
('f', 'x', 'a', ST_GeomFromText('POINT(107 197)')), |
| 1024 |
('m', 'o', 'a', ST_GeomFromText('POINT(142 80)')), |
| 1025 |
('q', 'l', 'g', ST_GeomFromText('POINT(251 23)')), |
| 1026 |
('c', 's', 's', ST_GeomFromText('POINT(158 43)')), |
| 1027 |
('y', 'd', 'o', ST_GeomFromText('POINT(196 228)')), |
| 1028 |
('d', 'p', 'l', ST_GeomFromText('POINT(107 5)')), |
| 1029 |
('h', 'a', 'b', ST_GeomFromText('POINT(183 166)')), |
| 1030 |
('m', 'w', 'p', ST_GeomFromText('POINT(19 59)')), |
| 1031 |
('b', 'y', 'o', ST_GeomFromText('POINT(178 30)')), |
| 1032 |
('x', 'w', 'i', ST_GeomFromText('POINT(168 94)')), |
| 1033 |
('t', 'k', 'z', ST_GeomFromText('POINT(171 5)')), |
| 1034 |
('r', 'm', 'a', ST_GeomFromText('POINT(222 19)')), |
| 1035 |
('u', 'v', 'e', ST_GeomFromText('POINT(224 80)')), |
| 1036 |
('q', 'r', 'k', ST_GeomFromText('POINT(212 218)')), |
| 1037 |
('d', 'p', 'j', ST_GeomFromText('POINT(169 7)')), |
| 1038 |
('d', 'r', 'v', ST_GeomFromText('POINT(193 23)')), |
| 1039 |
('n', 'y', 'y', ST_GeomFromText('POINT(130 178)')), |
| 1040 |
('m', 'z', 'r', ST_GeomFromText('POINT(81 200)')), |
| 1041 |
('j', 'e', 'w', ST_GeomFromText('POINT(145 239)')), |
| 1042 |
('v', 'h', 'x', ST_GeomFromText('POINT(24 105)')), |
| 1043 |
('z', 'm', 'a', ST_GeomFromText('POINT(175 129)')), |
| 1044 |
('b', 'c', 'v', ST_GeomFromText('POINT(213 10)')), |
| 1045 |
('t', 't', 'u', ST_GeomFromText('POINT(2 129)')), |
| 1046 |
('r', 's', 'v', ST_GeomFromText('POINT(209 192)')), |
| 1047 |
('x', 'p', 'g', ST_GeomFromText('POINT(43 63)')), |
| 1048 |
('t', 'e', 'u', ST_GeomFromText('POINT(139 210)')), |
| 1049 |
('l', 'e', 't', ST_GeomFromText('POINT(245 148)')), |
| 1050 |
('a', 'i', 'k', ST_GeomFromText('POINT(167 195)')), |
| 1051 |
('m', 'o', 'h', ST_GeomFromText('POINT(206 120)')), |
| 1052 |
('g', 'z', 's', ST_GeomFromText('POINT(169 240)')), |
| 1053 |
('z', 'u', 's', ST_GeomFromText('POINT(202 120)')), |
| 1054 |
('i', 'b', 'a', ST_GeomFromText('POINT(216 18)')), |
| 1055 |
('w', 'y', 'g', ST_GeomFromText('POINT(119 236)')), |
| 1056 |
('h', 'y', 'p', ST_GeomFromText('POINT(161 24)')); |
| 1057 |
CHECK TABLE t1 EXTENDED; |
| 1058 |
Table Op Msg_type Msg_text |
| 1059 |
test.t1 check status OK |
| 1060 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(33 100)') where c1 like 't%'; |
| 1061 |
CHECK TABLE t1 EXTENDED; |
| 1062 |
Table Op Msg_type Msg_text |
| 1063 |
test.t1 check status OK |
| 1064 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(41 46)') where c1 like 'f%'; |
| 1065 |
CHECK TABLE t1 EXTENDED; |
| 1066 |
Table Op Msg_type Msg_text |
| 1067 |
test.t1 check status OK |
| 1068 |
DROP TABLE t1; |
| 1069 |
create table t1 (a geometry not null SRID 0, spatial index(a)); |
| 1070 |
insert into t1 values (POINT(1.1517219314031e+164, 131072)); |
| 1071 |
insert into t1 values (POINT(9.1248812352444e+192, 2.9740338169556e+284)); |
| 1072 |
insert into t1 values (POINT(4.7783097267365e-299, -0)); |
| 1073 |
insert into t1 values (POINT(1.49166814624e-154, 2.0880974297595e-53)); |
| 1074 |
insert into t1 values (POINT(4.0917382598702e+149, 1.2024538023802e+111)); |
| 1075 |
insert into t1 values (POINT(2.0349165139404e+236, 2.9993936277913e-241)); |
| 1076 |
insert into t1 values (POINT(2.5243548967072e-29, 1.2024538023802e+111)); |
| 1077 |
insert into t1 values (POINT(0, 6.9835074892995e-251)); |
| 1078 |
insert into t1 values (POINT(2.0880974297595e-53, 3.1050361846014e+231)); |
| 1079 |
insert into t1 values (POINT(2.8728483499323e-188, 2.4600631144627e+260)); |
| 1080 |
insert into t1 values (POINT(3.0517578125e-05, 2.0349165139404e+236)); |
| 1081 |
insert into t1 values (POINT(1.1517219314031e+164, 1.1818212630766e-125)); |
| 1082 |
insert into t1 values (POINT(2.481040258324e-265, 5.7766220027675e-275)); |
| 1083 |
insert into t1 values (POINT(2.0880974297595e-53, 2.5243548967072e-29)); |
| 1084 |
insert into t1 values (POINT(5.7766220027675e-275, 9.9464647281957e+86)); |
| 1085 |
insert into t1 values (POINT(2.2181357552967e+130, 3.7857669957337e-270)); |
| 1086 |
insert into t1 values (POINT(4.5767114681874e-246, 3.6893488147419e+19)); |
| 1087 |
insert into t1 values (POINT(4.5767114681874e-246, 3.7537584144024e+255)); |
| 1088 |
insert into t1 values (POINT(3.7857669957337e-270, 1.8033161362863e-130)); |
| 1089 |
insert into t1 values (POINT(0, 5.8774717541114e-39)); |
| 1090 |
insert into t1 values (POINT(1.1517219314031e+164, 2.2761049594727e-159)); |
| 1091 |
insert into t1 values (POINT(6.243497100632e+144, 3.7857669957337e-270)); |
| 1092 |
insert into t1 values (POINT(3.7857669957337e-270, 2.6355494858076e-82)); |
| 1093 |
insert into t1 values (POINT(2.0349165139404e+236, 3.8518598887745e-34)); |
| 1094 |
insert into t1 values (POINT(4.6566128730774e-10, 2.0880974297595e-53)); |
| 1095 |
insert into t1 values (POINT(2.0880974297595e-53, 1.8827498946116e-183)); |
| 1096 |
insert into t1 values (POINT(1.8033161362863e-130, 9.1248812352444e+192)); |
| 1097 |
insert into t1 values (POINT(4.7783097267365e-299, 2.2761049594727e-159)); |
| 1098 |
insert into t1 values (POINT(1.94906280228e+289, 1.2338789709327e-178)); |
| 1099 |
drop table t1; |
| 1100 |
CREATE TABLE t1(foo GEOMETRY NOT NULL SRID 0, SPATIAL INDEX(foo) ); |
| 1101 |
INSERT INTO t1(foo) VALUES (NULL); |
| 1102 |
ERROR 23000: Column 'foo' cannot be null |
| 1103 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 1104 |
INSERT INTO t1() VALUES (); |
| 1105 |
ERROR HY000: Field 'foo' doesn't have a default value |
| 1106 |
SET sql_mode = default; |
| 1107 |
INSERT INTO t1(foo) VALUES (''); |
| 1108 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 1109 |
DROP TABLE t1; |
| 1110 |
CREATE TABLE t1 (a INT AUTO_INCREMENT, b POINT NOT NULL SRID 0, KEY (a), SPATIAL KEY (b)); |
| 1111 |
INSERT INTO t1 (b) VALUES (ST_GeomFromText('POINT(1 2)')); |
| 1112 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1113 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1114 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1115 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1116 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 1117 |
OPTIMIZE TABLE t1; |
| 1118 |
Table Op Msg_type Msg_text |
| 1119 |
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead |
| 1120 |
test.t1 optimize status OK |
| 1121 |
DROP TABLE t1; |
| 1122 |
CREATE TABLE t1 (a INT, b GEOMETRY NOT NULL SRID 0, SPATIAL KEY b(b)); |
| 1123 |
INSERT INTO t1 VALUES (1, ST_GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)')); |
| 1124 |
INSERT INTO t1 VALUES (2, ST_GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)')); |
| 1125 |
SELECT COUNT(*) FROM t1 WHERE |
| 1126 |
MBRINTERSECTS(b, ST_GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') ); |
| 1127 |
COUNT(*) |
| 1128 |
2 |
| 1129 |
SELECT COUNT(*) FROM t1 IGNORE INDEX (b) WHERE |
| 1130 |
MBRINTERSECTS(b, ST_GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') ); |
| 1131 |
COUNT(*) |
| 1132 |
2 |
| 1133 |
DROP TABLE t1; |
| 1134 |
# |
| 1135 |
# Bug #48258: Assertion failed when using a spatial index |
| 1136 |
# |
| 1137 |
CREATE TABLE t1(a LINESTRING NOT NULL SRID 0, SPATIAL KEY(a)); |
| 1138 |
INSERT INTO t1 VALUES |
| 1139 |
(ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)')), |
| 1140 |
(ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)')); |
| 1141 |
EXPLAIN SELECT 1 FROM t1 WHERE a = ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1142 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 1143 |
1 SIMPLE t1 NULL ALL a NULL NULL NULL 2 50.00 Using where |
| 1144 |
Warnings: |
| 1145 |
Note 1003 /* select#1 */ select 1 AS `1` from `test`.`t1` where (`test`.`t1`.`a` = <cache>(st_geomfromtext('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'))) |
| 1146 |
SELECT 1 FROM t1 WHERE a = ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1147 |
1 |
| 1148 |
1 |
| 1149 |
1 |
| 1150 |
EXPLAIN SELECT 1 FROM t1 WHERE a < ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1151 |
ERROR HY000: Incorrect arguments to < |
| 1152 |
SELECT 1 FROM t1 WHERE a < ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1153 |
ERROR HY000: Incorrect arguments to < |
| 1154 |
EXPLAIN SELECT 1 FROM t1 WHERE a <= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1155 |
ERROR HY000: Incorrect arguments to <= |
| 1156 |
SELECT 1 FROM t1 WHERE a <= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1157 |
ERROR HY000: Incorrect arguments to <= |
| 1158 |
EXPLAIN SELECT 1 FROM t1 WHERE a > ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1159 |
ERROR HY000: Incorrect arguments to > |
| 1160 |
SELECT 1 FROM t1 WHERE a > ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1161 |
ERROR HY000: Incorrect arguments to > |
| 1162 |
EXPLAIN SELECT 1 FROM t1 WHERE a >= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1163 |
ERROR HY000: Incorrect arguments to >= |
| 1164 |
SELECT 1 FROM t1 WHERE a >= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 1165 |
ERROR HY000: Incorrect arguments to >= |
| 1166 |
DROP TABLE t1; |
| 1167 |
# |
| 1168 |
# Bug #51357: crash when using handler commands on spatial indexes |
| 1169 |
# |
| 1170 |
CREATE TABLE t1(a GEOMETRY NOT NULL SRID 0,SPATIAL INDEX a(a)); |
| 1171 |
HANDLER t1 OPEN; |
| 1172 |
HANDLER t1 READ a FIRST; |
| 1173 |
a |
| 1174 |
HANDLER t1 READ a NEXT; |
| 1175 |
a |
| 1176 |
HANDLER t1 READ a PREV; |
| 1177 |
a |
| 1178 |
HANDLER t1 READ a LAST; |
| 1179 |
a |
| 1180 |
HANDLER t1 CLOSE; |
| 1181 |
HANDLER t1 OPEN; |
| 1182 |
HANDLER t1 READ a FIRST; |
| 1183 |
a |
| 1184 |
INSERT INTO t1 VALUES (ST_GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')); |
| 1185 |
# should not crash |
| 1186 |
HANDLER t1 READ a NEXT; |
| 1187 |
HANDLER t1 CLOSE; |
| 1188 |
DROP TABLE t1; |
| 1189 |
End of 5.0 tests. |
| 1190 |
# |
| 1191 |
# Bug #57323/11764487: myisam corruption with insert ignore |
| 1192 |
# and invalid spatial data |
| 1193 |
# |
| 1194 |
CREATE TABLE t1(a LINESTRING NOT NULL SRID 0, b GEOMETRY NOT NULL SRID 0, |
| 1195 |
SPATIAL KEY(a), SPATIAL KEY(b)) ENGINE=InnoDB; |
| 1196 |
INSERT INTO t1 VALUES(ST_GEOMFROMTEXT("point (0 0)"), ST_GEOMFROMTEXT("point (1 1)")); |
| 1197 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 1198 |
INSERT IGNORE INTO t1 SET a=ST_GEOMFROMTEXT("point (-6 0)"), b=ST_GEOMFROMTEXT("error"); |
| 1199 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 1200 |
INSERT IGNORE INTO t1 SET a=ST_GEOMFROMTEXT("point (-6 0)"), b=NULL; |
| 1201 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 1202 |
SELECT ST_ASTEXT(a), ST_ASTEXT(b) FROM t1; |
| 1203 |
ST_ASTEXT(a) ST_ASTEXT(b) |
| 1204 |
DROP TABLE t1; |
| 1205 |
CREATE TABLE t1(a INT NOT NULL, b GEOMETRY NOT NULL SRID 0, |
| 1206 |
KEY(a), SPATIAL KEY(b)) ENGINE=InnoDB; |
| 1207 |
INSERT INTO t1 VALUES(0, ST_GEOMFROMTEXT("point (1 1)")); |
| 1208 |
INSERT IGNORE INTO t1 SET a=0, b=ST_GEOMFROMTEXT("error"); |
| 1209 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 1210 |
INSERT IGNORE INTO t1 SET a=1, b=NULL; |
| 1211 |
ERROR 23000: Column 'b' cannot be null |
| 1212 |
SELECT a, ST_ASTEXT(b) FROM t1; |
| 1213 |
a ST_ASTEXT(b) |
| 1214 |
0 POINT(1 1) |
| 1215 |
DROP TABLE t1; |
| 1216 |
End of 5.1 tests |