| 1 |
# This is a testcase ported from mysql-test/t/gis-rtree.test |
| 2 |
|
| 3 |
|
| 4 |
# |
| 5 |
# test of rtree (using with spatial data) |
| 6 |
# |
| 7 |
--disable_warnings |
| 8 |
DROP TABLE IF EXISTS t1, t2; |
| 9 |
--enable_warnings |
| 10 |
|
| 11 |
CREATE TABLE t1 ( |
| 12 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 13 |
g GEOMETRY NOT NULL SRID 0, |
| 14 |
SPATIAL KEY(g) |
| 15 |
) ENGINE=InnoDB; |
| 16 |
|
| 17 |
SHOW CREATE TABLE t1; |
| 18 |
|
| 19 |
let $1=150; |
| 20 |
let $2=150; |
| 21 |
while ($1) |
| 22 |
{ |
| 23 |
eval INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString($1 $1, $2 $2)')); |
| 24 |
dec $1; |
| 25 |
inc $2; |
| 26 |
} |
| 27 |
|
| 28 |
SELECT count(*) FROM t1; |
| 29 |
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; |
| 30 |
|
| 31 |
DROP TABLE t1; |
| 32 |
|
| 33 |
CREATE TABLE t2 ( |
| 34 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 35 |
g GEOMETRY NOT NULL SRID 0 |
| 36 |
) ENGINE=InnoDB; |
| 37 |
|
| 38 |
let $1=10; |
| 39 |
while ($1) |
| 40 |
{ |
| 41 |
let $2=10; |
| 42 |
while ($2) |
| 43 |
{ |
| 44 |
eval INSERT INTO t2 (g) VALUES (LineString(Point($1 * 10 - 9, $2 * 10 - 9), Point($1 * 10, $2 * 10))); |
| 45 |
dec $2; |
| 46 |
} |
| 47 |
dec $1; |
| 48 |
} |
| 49 |
|
| 50 |
ALTER TABLE t2 ADD SPATIAL KEY(g); |
| 51 |
SHOW CREATE TABLE t2; |
| 52 |
SELECT count(*) FROM t2; |
| 53 |
SELECT fid, ST_AsText(g) FROM t2 WHERE MBRWithin(g, |
| 54 |
ST_GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')) ORDER BY fid; |
| 55 |
|
| 56 |
DROP TABLE t2; |
| 57 |
|
| 58 |
drop table if exists t1; |
| 59 |
CREATE TABLE t1 (a geometry NOT NULL SRID 0, SPATIAL (a)); |
| 60 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 61 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 62 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 63 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 64 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 65 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 66 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 67 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 68 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 69 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 70 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 71 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 72 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 73 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 74 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 75 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 76 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 77 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 78 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 79 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 80 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 81 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 82 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 83 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 84 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 85 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 86 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 87 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 88 |
INSERT INTO t1 VALUES (ST_GeomFromText("LINESTRING(100 100, 200 200, 300 300)")); |
| 89 |
check table t1; |
| 90 |
analyze table t1; |
| 91 |
drop table t1; |
| 92 |
|
| 93 |
# |
| 94 |
# The following crashed gis |
| 95 |
# |
| 96 |
|
| 97 |
CREATE TABLE t1 ( |
| 98 |
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 99 |
g GEOMETRY NOT NULL SRID 0, |
| 100 |
SPATIAL KEY(g) |
| 101 |
) ENGINE=InnoDB; |
| 102 |
|
| 103 |
INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString(1 2, 2 3)')),(ST_GeomFromText('LineString(1 2, 2 4)')); |
| 104 |
#select * from t1 where g<ST_GeomFromText('LineString(1 2, 2 3)'); |
| 105 |
drop table t1; |
| 106 |
|
| 107 |
CREATE TABLE t1 ( |
| 108 |
line LINESTRING NOT NULL SRID 0, |
| 109 |
kind ENUM('po', 'pp', 'rr', 'dr', 'rd', 'ts', 'cl') NOT NULL DEFAULT 'po', |
| 110 |
name VARCHAR(32), |
| 111 |
|
| 112 |
SPATIAL KEY (line) |
| 113 |
|
| 114 |
|
| 115 |
) engine=InnoDB; |
| 116 |
|
| 117 |
ALTER TABLE t1 DISABLE KEYS; |
| 118 |
--error ER_CANT_CREATE_GEOMETRY_OBJECT |
| 119 |
INSERT INTO t1 (name, kind, line) VALUES |
| 120 |
("Aadaouane", "pp", ST_GeomFromText("POINT(32.816667 35.983333)")), |
| 121 |
("Aadassiye", "pp", ST_GeomFromText("POINT(35.816667 36.216667)")), |
| 122 |
("Aadbel", "pp", ST_GeomFromText("POINT(34.533333 36.100000)")), |
| 123 |
("Aadchit", "pp", ST_GeomFromText("POINT(33.347222 35.423611)")), |
| 124 |
("Aadchite", "pp", ST_GeomFromText("POINT(33.347222 35.423611)")), |
| 125 |
("Aadchit el Qoussair", "pp", ST_GeomFromText("POINT(33.283333 35.483333)")), |
| 126 |
("Aaddaye", "pp", ST_GeomFromText("POINT(36.716667 40.833333)")), |
| 127 |
("'Aadeissa", "pp", ST_GeomFromText("POINT(32.823889 35.698889)")), |
| 128 |
("Aaderup", "pp", ST_GeomFromText("POINT(55.216667 11.766667)")), |
| 129 |
("Qalaat Aades", "pp", ST_GeomFromText("POINT(33.503333 35.377500)")), |
| 130 |
("A ad'ino", "pp", ST_GeomFromText("POINT(54.812222 38.209167)")), |
| 131 |
("Aadi Noia", "pp", ST_GeomFromText("POINT(13.800000 39.833333)")), |
| 132 |
("Aad La Macta", "pp", ST_GeomFromText("POINT(35.779444 -0.129167)")), |
| 133 |
("Aadland", "pp", ST_GeomFromText("POINT(60.366667 5.483333)")), |
| 134 |
("Aadliye", "pp", ST_GeomFromText("POINT(33.366667 36.333333)")), |
| 135 |
("Aadloun", "pp", ST_GeomFromText("POINT(33.403889 35.273889)")), |
| 136 |
("Aadma", "pp", ST_GeomFromText("POINT(58.798333 22.663889)")), |
| 137 |
("Aadma Asundus", "pp", ST_GeomFromText("POINT(58.798333 22.663889)")), |
| 138 |
("Aadmoun", "pp", ST_GeomFromText("POINT(34.150000 35.650000)")), |
| 139 |
("Aadneram", "pp", ST_GeomFromText("POINT(59.016667 6.933333)")), |
| 140 |
("Aadneskaar", "pp", ST_GeomFromText("POINT(58.083333 6.983333)")), |
| 141 |
("Aadorf", "pp", ST_GeomFromText("POINT(47.483333 8.900000)")), |
| 142 |
("Aadorp", "pp", ST_GeomFromText("POINT(52.366667 6.633333)")), |
| 143 |
("Aadouane", "pp", ST_GeomFromText("POINT(32.816667 35.983333)")), |
| 144 |
("Aadoui", "pp", ST_GeomFromText("POINT(34.450000 35.983333)")), |
| 145 |
("Aadouiye", "pp", ST_GeomFromText("POINT(34.583333 36.183333)")), |
| 146 |
("Aadouss", "pp", ST_GeomFromText("POINT(33.512500 35.601389)")), |
| 147 |
("Aadra", "pp", ST_GeomFromText("POINT(33.616667 36.500000)")), |
| 148 |
("Aadzi", "pp", ST_GeomFromText("POINT(38.100000 64.850000)")); |
| 149 |
|
| 150 |
ALTER TABLE t1 ENABLE KEYS; |
| 151 |
INSERT INTO t1 (name, kind, line) VALUES ("austria", "pp", ST_GeomFromText('LINESTRING(14.9906 48.9887,14.9946 48.9904,14.9947 48.9916)')); |
| 152 |
drop table t1; |
| 153 |
|
| 154 |
CREATE TABLE t1 (st varchar(100)); |
| 155 |
INSERT INTO t1 VALUES ("Fake string"); |
| 156 |
CREATE TABLE t2 (geom GEOMETRY NOT NULL SRID 0, SPATIAL KEY gk(geom)); |
| 157 |
--error ER_GIS_INVALID_DATA |
| 158 |
INSERT INTO t2 SELECT ST_GeomFromText(st) FROM t1; |
| 159 |
drop table t1, t2; |
| 160 |
|
| 161 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 162 |
CREATE TABLE t1 (`geometry` geometry NOT NULL SRID 0,SPATIAL KEY `gndx` (`geometry`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 163 |
|
| 164 |
INSERT INTO t1 (geometry) VALUES |
| 165 |
(ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, -18.6055555000 |
| 166 |
-66.8158332999, -18.7186111000 -66.8102777000, -18.7211111000 -66.9269443999, |
| 167 |
-18.6086111000 -66.9327777000))')); |
| 168 |
|
| 169 |
INSERT INTO t1 (geometry) VALUES |
| 170 |
(ST_PolygonFromText('POLYGON((-65.7402776999 -96.6686111000, -65.7372222000 |
| 171 |
-96.5516666000, -65.8502777000 -96.5461111000, -65.8527777000 -96.6627777000, |
| 172 |
-65.7402776999 -96.6686111000))')); |
| 173 |
check table t1 extended; |
| 174 |
|
| 175 |
drop table t1; |
| 176 |
|
| 177 |
CREATE TABLE t1 (`geometry` geometry NOT NULL SRID 0,SPATIAL KEY `gndx` (`geometry`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 178 |
|
| 179 |
INSERT INTO t1 (geometry) VALUES |
| 180 |
(ST_PolygonFromText('POLYGON((2 2, 2 8, 10 8, 10 2, 2 2))')); |
| 181 |
|
| 182 |
INSERT INTO t1 (geometry) VALUES |
| 183 |
(ST_PolygonFromText('POLYGON((2 12, 15 12, 15 18, 2 18, 2 12))')); |
| 184 |
|
| 185 |
INSERT INTO t1 (geometry) VALUES |
| 186 |
(ST_PolygonFromText('POLYGON((3 5, 3 18, 10 18, 10 5, 3 5))')); |
| 187 |
|
| 188 |
INSERT INTO t1 (geometry) VALUES |
| 189 |
(ST_PolygonFromText('POLYGON((4 6, 4 8, 10 8, 10 4, 4 6))')); |
| 190 |
|
| 191 |
set @g1 = ST_GeomFromText('Polygon((0 0,0 1000,1000 1000,1000 0,0 0))'); |
| 192 |
|
| 193 |
select count(*) from t1 where MBRWithin(t1.geometry, @g1); |
| 194 |
|
| 195 |
start transaction; |
| 196 |
|
| 197 |
INSERT INTO t1 (geometry) VALUES |
| 198 |
(ST_PolygonFromText('POLYGON((4 6, 4 8, 10 8, 10 4, 4 6))')); |
| 199 |
|
| 200 |
select count(*) from t1 where MBRWithin(t1.geometry, @g1); |
| 201 |
|
| 202 |
rollback; |
| 203 |
|
| 204 |
select count(*) from t1 where MBRWithin(t1.geometry, @g1); |
| 205 |
|
| 206 |
set @g2 = ST_GeomFromText('POINT(2 2)'); |
| 207 |
|
| 208 |
select count(*) from t1 where MBRcontains(t1.geometry, @g2); |
| 209 |
|
| 210 |
select count(*) from t1 where MBRintersects(t1.geometry, @g2); |
| 211 |
|
| 212 |
set @g3 = ST_GeomFromText('LINESTRING(2 2, 2 12)'); |
| 213 |
|
| 214 |
select count(*) from t1 where MBRintersects(t1.geometry, @g3); |
| 215 |
|
| 216 |
DROP TABLE t1; |
| 217 |
|
| 218 |
# |
| 219 |
# Bug#17877 - Corrupted spatial index |
| 220 |
# |
| 221 |
CREATE TABLE t1 ( |
| 222 |
c1 geometry NOT NULL SRID 0, |
| 223 |
SPATIAL KEY i1 (c1) |
| 224 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 225 |
INSERT INTO t1 (c1) VALUES ( |
| 226 |
ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 227 |
-18.6055555000 -66.8158332999, |
| 228 |
-18.7186111000 -66.8102777000, |
| 229 |
-18.7211111000 -66.9269443999, |
| 230 |
-18.6086111000 -66.9327777000))')); |
| 231 |
# This showed a missing key. |
| 232 |
CHECK TABLE t1 EXTENDED; |
| 233 |
DROP TABLE t1; |
| 234 |
# |
| 235 |
CREATE TABLE t1 ( |
| 236 |
c1 geometry NOT NULL SRID 0, |
| 237 |
SPATIAL KEY i1 (c1) |
| 238 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 239 |
INSERT INTO t1 (c1) VALUES ( |
| 240 |
ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 241 |
-18.6055555000 -66.8158332999, |
| 242 |
-18.7186111000 -66.8102777000, |
| 243 |
-18.7211111000 -66.9269443999, |
| 244 |
-18.6086111000 -66.9327777000))')); |
| 245 |
INSERT INTO t1 (c1) VALUES ( |
| 246 |
ST_PolygonFromText('POLYGON((-65.7402776999 -96.6686111000, |
| 247 |
-65.7372222000 -96.5516666000, |
| 248 |
-65.8502777000 -96.5461111000, |
| 249 |
-65.8527777000 -96.6627777000, |
| 250 |
-65.7402776999 -96.6686111000))')); |
| 251 |
# This is the same as the first insert to get a non-unique key. |
| 252 |
INSERT INTO t1 (c1) VALUES ( |
| 253 |
ST_PolygonFromText('POLYGON((-18.6086111000 -66.9327777000, |
| 254 |
-18.6055555000 -66.8158332999, |
| 255 |
-18.7186111000 -66.8102777000, |
| 256 |
-18.7211111000 -66.9269443999, |
| 257 |
-18.6086111000 -66.9327777000))')); |
| 258 |
# This showed (and still shows) OK. |
| 259 |
CHECK TABLE t1 EXTENDED; |
| 260 |
DROP TABLE t1; |
| 261 |
SET sql_mode = default; |
| 262 |
|
| 263 |
# |
| 264 |
# Bug #21888: Query on GEOMETRY field using PointFromWKB() results in lost connection |
| 265 |
# |
| 266 |
CREATE TABLE t1 (foo GEOMETRY NOT NULL SRID 0, SPATIAL INDEX(foo) ); |
| 267 |
INSERT INTO t1 (foo) VALUES (POINT(1,1)); |
| 268 |
INSERT INTO t1 (foo) VALUES (POINT(1,0)); |
| 269 |
INSERT INTO t1 (foo) VALUES (POINT(0,1)); |
| 270 |
INSERT INTO t1 (foo) VALUES (POINT(0,0)); |
| 271 |
SELECT 1 FROM t1 WHERE foo != POINT(0,0); |
| 272 |
DROP TABLE t1; |
| 273 |
|
| 274 |
# |
| 275 |
# Bug#25673 - spatial index corruption, error 126 incorrect key file for table |
| 276 |
# |
| 277 |
CREATE TABLE t1 (id bigint(12) unsigned NOT NULL auto_increment, |
| 278 |
c2 varchar(15) collate utf8_bin default NULL, |
| 279 |
c1 varchar(15) collate utf8_bin default NULL, |
| 280 |
c3 varchar(10) collate utf8_bin default NULL, |
| 281 |
spatial_point point NOT NULL SRID 0, |
| 282 |
PRIMARY KEY(id), |
| 283 |
SPATIAL KEY (spatial_point) |
| 284 |
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 285 |
# |
| 286 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 287 |
('y', 's', 'j', ST_GeomFromText('POINT(167 74)')), |
| 288 |
('r', 'n', 'd', ST_GeomFromText('POINT(215 118)')), |
| 289 |
('g', 'n', 'e', ST_GeomFromText('POINT(203 98)')), |
| 290 |
('h', 'd', 'd', ST_GeomFromText('POINT(54 193)')), |
| 291 |
('r', 'x', 'y', ST_GeomFromText('POINT(47 69)')), |
| 292 |
('t', 'q', 'r', ST_GeomFromText('POINT(109 42)')), |
| 293 |
('a', 'z', 'd', ST_GeomFromText('POINT(0 154)')), |
| 294 |
('x', 'v', 'o', ST_GeomFromText('POINT(174 131)')), |
| 295 |
('b', 'r', 'a', ST_GeomFromText('POINT(114 253)')), |
| 296 |
('x', 'z', 'i', ST_GeomFromText('POINT(163 21)')), |
| 297 |
('w', 'p', 'i', ST_GeomFromText('POINT(42 102)')), |
| 298 |
('g', 'j', 'j', ST_GeomFromText('POINT(170 133)')), |
| 299 |
('m', 'g', 'n', ST_GeomFromText('POINT(28 22)')), |
| 300 |
('b', 'z', 'h', ST_GeomFromText('POINT(174 28)')), |
| 301 |
('q', 'k', 'f', ST_GeomFromText('POINT(233 73)')), |
| 302 |
('w', 'w', 'a', ST_GeomFromText('POINT(124 200)')), |
| 303 |
('t', 'j', 'w', ST_GeomFromText('POINT(252 101)')), |
| 304 |
('d', 'r', 'd', ST_GeomFromText('POINT(98 18)')), |
| 305 |
('w', 'o', 'y', ST_GeomFromText('POINT(165 31)')), |
| 306 |
('y', 'h', 't', ST_GeomFromText('POINT(14 220)')), |
| 307 |
('d', 'p', 'u', ST_GeomFromText('POINT(223 196)')), |
| 308 |
('g', 'y', 'g', ST_GeomFromText('POINT(207 96)')), |
| 309 |
('x', 'm', 'n', ST_GeomFromText('POINT(214 3)')), |
| 310 |
('g', 'v', 'e', ST_GeomFromText('POINT(140 205)')), |
| 311 |
('g', 'm', 'm', ST_GeomFromText('POINT(10 236)')), |
| 312 |
('i', 'r', 'j', ST_GeomFromText('POINT(137 228)')), |
| 313 |
('w', 's', 'p', ST_GeomFromText('POINT(115 6)')), |
| 314 |
('o', 'n', 'k', ST_GeomFromText('POINT(158 129)')), |
| 315 |
('j', 'h', 'l', ST_GeomFromText('POINT(129 72)')), |
| 316 |
('f', 'x', 'l', ST_GeomFromText('POINT(139 207)')), |
| 317 |
('u', 'd', 'n', ST_GeomFromText('POINT(125 109)')), |
| 318 |
('b', 'a', 'z', ST_GeomFromText('POINT(30 32)')), |
| 319 |
('m', 'h', 'o', ST_GeomFromText('POINT(251 251)')), |
| 320 |
('f', 'r', 'd', ST_GeomFromText('POINT(243 211)')), |
| 321 |
('b', 'd', 'r', ST_GeomFromText('POINT(232 80)')), |
| 322 |
('g', 'k', 'v', ST_GeomFromText('POINT(15 100)')), |
| 323 |
('i', 'f', 'c', ST_GeomFromText('POINT(109 66)')), |
| 324 |
('r', 't', 'j', ST_GeomFromText('POINT(178 6)')), |
| 325 |
('y', 'n', 'f', ST_GeomFromText('POINT(233 211)')), |
| 326 |
('f', 'y', 'm', ST_GeomFromText('POINT(99 16)')), |
| 327 |
('z', 'q', 'l', ST_GeomFromText('POINT(39 49)')), |
| 328 |
('j', 'c', 'r', ST_GeomFromText('POINT(75 187)')), |
| 329 |
('c', 'y', 'y', ST_GeomFromText('POINT(246 253)')), |
| 330 |
('w', 'u', 'd', ST_GeomFromText('POINT(56 190)')), |
| 331 |
('n', 'q', 'm', ST_GeomFromText('POINT(73 149)')), |
| 332 |
('d', 'y', 'a', ST_GeomFromText('POINT(134 6)')), |
| 333 |
('z', 's', 'w', ST_GeomFromText('POINT(216 225)')), |
| 334 |
('d', 'u', 'k', ST_GeomFromText('POINT(132 70)')), |
| 335 |
('f', 'v', 't', ST_GeomFromText('POINT(187 141)')), |
| 336 |
('r', 'r', 'a', ST_GeomFromText('POINT(152 39)')), |
| 337 |
('y', 'p', 'o', ST_GeomFromText('POINT(45 27)')), |
| 338 |
('p', 'n', 'm', ST_GeomFromText('POINT(228 148)')), |
| 339 |
('e', 'g', 'e', ST_GeomFromText('POINT(88 81)')), |
| 340 |
('m', 'a', 'h', ST_GeomFromText('POINT(35 29)')), |
| 341 |
('m', 'h', 'f', ST_GeomFromText('POINT(30 71)')), |
| 342 |
('h', 'k', 'i', ST_GeomFromText('POINT(244 78)')), |
| 343 |
('z', 'v', 'd', ST_GeomFromText('POINT(241 38)')), |
| 344 |
('q', 'l', 'j', ST_GeomFromText('POINT(13 71)')), |
| 345 |
('s', 'p', 'g', ST_GeomFromText('POINT(108 38)')), |
| 346 |
('q', 's', 'j', ST_GeomFromText('POINT(92 101)')), |
| 347 |
('l', 'h', 'g', ST_GeomFromText('POINT(120 78)')), |
| 348 |
('w', 't', 'b', ST_GeomFromText('POINT(193 109)')), |
| 349 |
('b', 's', 's', ST_GeomFromText('POINT(223 211)')), |
| 350 |
('w', 'w', 'y', ST_GeomFromText('POINT(122 42)')), |
| 351 |
('q', 'c', 'c', ST_GeomFromText('POINT(104 102)')), |
| 352 |
('w', 'g', 'n', ST_GeomFromText('POINT(213 120)')), |
| 353 |
('p', 'q', 'a', ST_GeomFromText('POINT(247 148)')), |
| 354 |
('c', 'z', 'e', ST_GeomFromText('POINT(18 106)')), |
| 355 |
('z', 'u', 'n', ST_GeomFromText('POINT(70 133)')), |
| 356 |
('j', 'n', 'x', ST_GeomFromText('POINT(232 13)')), |
| 357 |
('e', 'h', 'f', ST_GeomFromText('POINT(22 135)')), |
| 358 |
('w', 'l', 'f', ST_GeomFromText('POINT(9 180)')), |
| 359 |
('a', 'v', 'q', ST_GeomFromText('POINT(163 228)')), |
| 360 |
('i', 'z', 'o', ST_GeomFromText('POINT(180 100)')), |
| 361 |
('e', 'c', 'l', ST_GeomFromText('POINT(182 231)')), |
| 362 |
('c', 'k', 'o', ST_GeomFromText('POINT(19 60)')), |
| 363 |
('q', 'f', 'p', ST_GeomFromText('POINT(79 95)')), |
| 364 |
('m', 'd', 'r', ST_GeomFromText('POINT(3 127)')), |
| 365 |
('m', 'e', 't', ST_GeomFromText('POINT(136 154)')), |
| 366 |
('w', 'w', 'w', ST_GeomFromText('POINT(102 15)')), |
| 367 |
('l', 'n', 'q', ST_GeomFromText('POINT(71 196)')), |
| 368 |
('p', 'k', 'c', ST_GeomFromText('POINT(47 139)')), |
| 369 |
('j', 'o', 'r', ST_GeomFromText('POINT(177 128)')), |
| 370 |
('j', 'q', 'a', ST_GeomFromText('POINT(170 6)')), |
| 371 |
('b', 'a', 'o', ST_GeomFromText('POINT(63 211)')), |
| 372 |
('g', 's', 'o', ST_GeomFromText('POINT(144 251)')), |
| 373 |
('w', 'u', 'w', ST_GeomFromText('POINT(221 214)')), |
| 374 |
('g', 'a', 'm', ST_GeomFromText('POINT(14 102)')), |
| 375 |
('u', 'q', 'z', ST_GeomFromText('POINT(86 200)')), |
| 376 |
('k', 'a', 'm', ST_GeomFromText('POINT(144 222)')), |
| 377 |
('j', 'u', 'r', ST_GeomFromText('POINT(216 142)')), |
| 378 |
('q', 'k', 'v', ST_GeomFromText('POINT(121 236)')), |
| 379 |
('p', 'o', 'r', ST_GeomFromText('POINT(108 102)')), |
| 380 |
('b', 'd', 'x', ST_GeomFromText('POINT(127 198)')), |
| 381 |
('k', 's', 'a', ST_GeomFromText('POINT(2 150)')), |
| 382 |
('f', 'm', 'f', ST_GeomFromText('POINT(160 191)')), |
| 383 |
('q', 'y', 'x', ST_GeomFromText('POINT(98 111)')), |
| 384 |
('o', 'f', 'm', ST_GeomFromText('POINT(232 218)')), |
| 385 |
('c', 'w', 'j', ST_GeomFromText('POINT(156 165)')), |
| 386 |
('s', 'q', 'v', ST_GeomFromText('POINT(98 161)')); |
| 387 |
SET @@RAND_SEED1=692635050, @@RAND_SEED2=297339954; |
| 388 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 389 |
SET @@RAND_SEED1=159925977, @@RAND_SEED2=942570618; |
| 390 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 391 |
SET @@RAND_SEED1=328169745, @@RAND_SEED2=410451954; |
| 392 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 393 |
SET @@RAND_SEED1=178507359, @@RAND_SEED2=332493072; |
| 394 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 395 |
SET @@RAND_SEED1=1034033013, @@RAND_SEED2=558966507; |
| 396 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 397 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(230 9)') where c1 like 'y%'; |
| 398 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(95 35)') where c1 like 'j%'; |
| 399 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(93 99)') where c1 like 'a%'; |
| 400 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(19 81)') where c1 like 'r%'; |
| 401 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(20 177)') where c1 like 'h%'; |
| 402 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(221 193)') where c1 like 'u%'; |
| 403 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(195 205)') where c1 like 'd%'; |
| 404 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(15 213)') where c1 like 'u%'; |
| 405 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(214 63)') where c1 like 'n%'; |
| 406 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(243 171)') where c1 like 'c%'; |
| 407 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(198 82)') where c1 like 'y%'; |
| 408 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 409 |
('f', 'y', 'p', ST_GeomFromText('POINT(109 235)')), |
| 410 |
('b', 'e', 'v', ST_GeomFromText('POINT(20 48)')), |
| 411 |
('i', 'u', 'f', ST_GeomFromText('POINT(15 55)')), |
| 412 |
('o', 'r', 'z', ST_GeomFromText('POINT(105 64)')), |
| 413 |
('a', 'p', 'a', ST_GeomFromText('POINT(142 236)')), |
| 414 |
('g', 'i', 'k', ST_GeomFromText('POINT(10 49)')), |
| 415 |
('x', 'z', 'x', ST_GeomFromText('POINT(192 200)')), |
| 416 |
('c', 'v', 'r', ST_GeomFromText('POINT(94 168)')), |
| 417 |
('y', 'z', 'e', ST_GeomFromText('POINT(141 51)')), |
| 418 |
('h', 'm', 'd', ST_GeomFromText('POINT(35 251)')), |
| 419 |
('v', 'm', 'q', ST_GeomFromText('POINT(44 90)')), |
| 420 |
('j', 'l', 'z', ST_GeomFromText('POINT(67 237)')), |
| 421 |
('i', 'v', 'a', ST_GeomFromText('POINT(75 14)')), |
| 422 |
('b', 'q', 't', ST_GeomFromText('POINT(153 33)')), |
| 423 |
('e', 'm', 'a', ST_GeomFromText('POINT(247 49)')), |
| 424 |
('l', 'y', 'g', ST_GeomFromText('POINT(56 203)')), |
| 425 |
('v', 'o', 'r', ST_GeomFromText('POINT(90 54)')), |
| 426 |
('r', 'n', 'd', ST_GeomFromText('POINT(135 83)')), |
| 427 |
('j', 't', 'u', ST_GeomFromText('POINT(174 239)')), |
| 428 |
('u', 'n', 'g', ST_GeomFromText('POINT(104 191)')), |
| 429 |
('p', 'q', 'y', ST_GeomFromText('POINT(63 171)')), |
| 430 |
('o', 'q', 'p', ST_GeomFromText('POINT(192 103)')), |
| 431 |
('f', 'x', 'e', ST_GeomFromText('POINT(244 30)')), |
| 432 |
('n', 'x', 'c', ST_GeomFromText('POINT(92 103)')), |
| 433 |
('r', 'q', 'z', ST_GeomFromText('POINT(166 20)')), |
| 434 |
('s', 'a', 'j', ST_GeomFromText('POINT(137 205)')), |
| 435 |
('z', 't', 't', ST_GeomFromText('POINT(99 134)')), |
| 436 |
('o', 'm', 'j', ST_GeomFromText('POINT(217 3)')), |
| 437 |
('n', 'h', 'j', ST_GeomFromText('POINT(211 17)')), |
| 438 |
('v', 'v', 'a', ST_GeomFromText('POINT(41 137)')), |
| 439 |
('q', 'o', 'j', ST_GeomFromText('POINT(5 92)')), |
| 440 |
('z', 'y', 'e', ST_GeomFromText('POINT(175 212)')), |
| 441 |
('j', 'z', 'h', ST_GeomFromText('POINT(224 194)')), |
| 442 |
('a', 'g', 'm', ST_GeomFromText('POINT(31 119)')), |
| 443 |
('p', 'c', 'f', ST_GeomFromText('POINT(17 221)')), |
| 444 |
('t', 'h', 'k', ST_GeomFromText('POINT(26 203)')), |
| 445 |
('u', 'w', 'p', ST_GeomFromText('POINT(47 185)')), |
| 446 |
('z', 'a', 'c', ST_GeomFromText('POINT(61 133)')), |
| 447 |
('u', 'k', 'a', ST_GeomFromText('POINT(210 115)')), |
| 448 |
('k', 'f', 'h', ST_GeomFromText('POINT(125 113)')), |
| 449 |
('t', 'v', 'y', ST_GeomFromText('POINT(12 239)')), |
| 450 |
('u', 'v', 'd', ST_GeomFromText('POINT(90 24)')), |
| 451 |
('m', 'y', 'w', ST_GeomFromText('POINT(25 243)')), |
| 452 |
('d', 'n', 'g', ST_GeomFromText('POINT(122 92)')), |
| 453 |
('z', 'm', 'f', ST_GeomFromText('POINT(235 110)')), |
| 454 |
('q', 'd', 'f', ST_GeomFromText('POINT(233 217)')), |
| 455 |
('a', 'v', 'u', ST_GeomFromText('POINT(69 59)')), |
| 456 |
('x', 'k', 'p', ST_GeomFromText('POINT(240 14)')), |
| 457 |
('i', 'v', 'r', ST_GeomFromText('POINT(154 42)')), |
| 458 |
('w', 'h', 'l', ST_GeomFromText('POINT(178 156)')), |
| 459 |
('d', 'h', 'n', ST_GeomFromText('POINT(65 157)')), |
| 460 |
('c', 'k', 'z', ST_GeomFromText('POINT(62 33)')), |
| 461 |
('e', 'l', 'w', ST_GeomFromText('POINT(162 1)')), |
| 462 |
('r', 'f', 'i', ST_GeomFromText('POINT(127 71)')), |
| 463 |
('q', 'm', 'c', ST_GeomFromText('POINT(63 118)')), |
| 464 |
('c', 'h', 'u', ST_GeomFromText('POINT(205 203)')), |
| 465 |
('d', 't', 'p', ST_GeomFromText('POINT(234 87)')), |
| 466 |
('s', 'g', 'h', ST_GeomFromText('POINT(149 34)')), |
| 467 |
('o', 'b', 'q', ST_GeomFromText('POINT(159 179)')), |
| 468 |
('k', 'u', 'f', ST_GeomFromText('POINT(202 254)')), |
| 469 |
('u', 'f', 'g', ST_GeomFromText('POINT(70 15)')), |
| 470 |
('x', 's', 'b', ST_GeomFromText('POINT(25 181)')), |
| 471 |
('s', 'c', 'g', ST_GeomFromText('POINT(252 17)')), |
| 472 |
('a', 'c', 'f', ST_GeomFromText('POINT(89 67)')), |
| 473 |
('r', 'e', 'q', ST_GeomFromText('POINT(55 54)')), |
| 474 |
('f', 'i', 'k', ST_GeomFromText('POINT(178 230)')), |
| 475 |
('p', 'e', 'l', ST_GeomFromText('POINT(198 28)')), |
| 476 |
('w', 'o', 'd', ST_GeomFromText('POINT(204 189)')), |
| 477 |
('c', 'a', 'g', ST_GeomFromText('POINT(230 178)')), |
| 478 |
('r', 'o', 'e', ST_GeomFromText('POINT(61 116)')), |
| 479 |
('w', 'a', 'a', ST_GeomFromText('POINT(178 237)')), |
| 480 |
('v', 'd', 'e', ST_GeomFromText('POINT(70 85)')), |
| 481 |
('k', 'c', 'e', ST_GeomFromText('POINT(147 118)')), |
| 482 |
('d', 'q', 't', ST_GeomFromText('POINT(218 77)')), |
| 483 |
('k', 'g', 'f', ST_GeomFromText('POINT(192 113)')), |
| 484 |
('w', 'n', 'e', ST_GeomFromText('POINT(92 124)')), |
| 485 |
('r', 'm', 'q', ST_GeomFromText('POINT(130 65)')), |
| 486 |
('o', 'r', 'r', ST_GeomFromText('POINT(174 233)')), |
| 487 |
('k', 'n', 't', ST_GeomFromText('POINT(175 147)')), |
| 488 |
('q', 'm', 'r', ST_GeomFromText('POINT(18 208)')), |
| 489 |
('l', 'd', 'i', ST_GeomFromText('POINT(13 104)')), |
| 490 |
('w', 'o', 'y', ST_GeomFromText('POINT(207 39)')), |
| 491 |
('p', 'u', 'o', ST_GeomFromText('POINT(114 31)')), |
| 492 |
('y', 'a', 'p', ST_GeomFromText('POINT(106 59)')), |
| 493 |
('a', 'x', 'z', ST_GeomFromText('POINT(17 57)')), |
| 494 |
('v', 'h', 'x', ST_GeomFromText('POINT(170 13)')), |
| 495 |
('t', 's', 'u', ST_GeomFromText('POINT(84 18)')), |
| 496 |
('z', 'z', 'f', ST_GeomFromText('POINT(250 197)')), |
| 497 |
('l', 'z', 't', ST_GeomFromText('POINT(59 80)')), |
| 498 |
('j', 'g', 's', ST_GeomFromText('POINT(54 26)')), |
| 499 |
('g', 'v', 'm', ST_GeomFromText('POINT(89 98)')), |
| 500 |
('q', 'v', 'b', ST_GeomFromText('POINT(39 240)')), |
| 501 |
('x', 'k', 'v', ST_GeomFromText('POINT(246 207)')), |
| 502 |
('k', 'u', 'i', ST_GeomFromText('POINT(105 111)')), |
| 503 |
('w', 'z', 's', ST_GeomFromText('POINT(235 8)')), |
| 504 |
('d', 'd', 'd', ST_GeomFromText('POINT(105 4)')), |
| 505 |
('c', 'z', 'q', ST_GeomFromText('POINT(13 140)')), |
| 506 |
('m', 'k', 'i', ST_GeomFromText('POINT(208 120)')), |
| 507 |
('g', 'a', 'g', ST_GeomFromText('POINT(9 182)')), |
| 508 |
('z', 'j', 'r', ST_GeomFromText('POINT(149 153)')), |
| 509 |
('h', 'f', 'g', ST_GeomFromText('POINT(81 236)')), |
| 510 |
('m', 'e', 'q', ST_GeomFromText('POINT(209 215)')), |
| 511 |
('c', 'h', 'y', ST_GeomFromText('POINT(235 70)')), |
| 512 |
('i', 'e', 'g', ST_GeomFromText('POINT(138 26)')), |
| 513 |
('m', 't', 'u', ST_GeomFromText('POINT(119 237)')), |
| 514 |
('o', 'w', 's', ST_GeomFromText('POINT(193 166)')), |
| 515 |
('f', 'm', 'q', ST_GeomFromText('POINT(85 96)')), |
| 516 |
('x', 'l', 'x', ST_GeomFromText('POINT(58 115)')), |
| 517 |
('x', 'q', 'u', ST_GeomFromText('POINT(108 210)')), |
| 518 |
('b', 'h', 'i', ST_GeomFromText('POINT(250 139)')), |
| 519 |
('y', 'd', 'x', ST_GeomFromText('POINT(199 135)')), |
| 520 |
('w', 'h', 'p', ST_GeomFromText('POINT(247 233)')), |
| 521 |
('p', 'z', 't', ST_GeomFromText('POINT(148 249)')), |
| 522 |
('q', 'a', 'u', ST_GeomFromText('POINT(174 78)')), |
| 523 |
('v', 't', 'm', ST_GeomFromText('POINT(70 228)')), |
| 524 |
('t', 'n', 'f', ST_GeomFromText('POINT(123 2)')), |
| 525 |
('x', 't', 'b', ST_GeomFromText('POINT(35 50)')), |
| 526 |
('r', 'j', 'f', ST_GeomFromText('POINT(200 51)')), |
| 527 |
('s', 'q', 'o', ST_GeomFromText('POINT(23 184)')), |
| 528 |
('u', 'v', 'z', ST_GeomFromText('POINT(7 113)')), |
| 529 |
('v', 'u', 'l', ST_GeomFromText('POINT(145 190)')), |
| 530 |
('o', 'k', 'i', ST_GeomFromText('POINT(161 122)')), |
| 531 |
('l', 'y', 'e', ST_GeomFromText('POINT(17 232)')), |
| 532 |
('t', 'b', 'e', ST_GeomFromText('POINT(120 50)')), |
| 533 |
('e', 's', 'u', ST_GeomFromText('POINT(254 1)')), |
| 534 |
('d', 'd', 'u', ST_GeomFromText('POINT(167 140)')), |
| 535 |
('o', 'b', 'x', ST_GeomFromText('POINT(186 237)')), |
| 536 |
('m', 's', 's', ST_GeomFromText('POINT(172 149)')), |
| 537 |
('t', 'y', 'a', ST_GeomFromText('POINT(149 85)')), |
| 538 |
('x', 't', 'r', ST_GeomFromText('POINT(10 165)')), |
| 539 |
('g', 'c', 'e', ST_GeomFromText('POINT(95 165)')), |
| 540 |
('e', 'e', 'z', ST_GeomFromText('POINT(98 65)')), |
| 541 |
('f', 'v', 'i', ST_GeomFromText('POINT(149 144)')), |
| 542 |
('o', 'p', 'm', ST_GeomFromText('POINT(233 67)')), |
| 543 |
('t', 'u', 'b', ST_GeomFromText('POINT(109 215)')), |
| 544 |
('o', 'o', 'b', ST_GeomFromText('POINT(130 48)')), |
| 545 |
('e', 'm', 'h', ST_GeomFromText('POINT(88 189)')), |
| 546 |
('e', 'v', 'y', ST_GeomFromText('POINT(55 29)')), |
| 547 |
('e', 't', 'm', ST_GeomFromText('POINT(129 55)')), |
| 548 |
('p', 'p', 'i', ST_GeomFromText('POINT(126 222)')), |
| 549 |
('c', 'i', 'c', ST_GeomFromText('POINT(19 158)')), |
| 550 |
('c', 'b', 's', ST_GeomFromText('POINT(13 19)')), |
| 551 |
('u', 'y', 'a', ST_GeomFromText('POINT(114 5)')), |
| 552 |
('a', 'o', 'f', ST_GeomFromText('POINT(227 232)')), |
| 553 |
('t', 'c', 'z', ST_GeomFromText('POINT(63 62)')), |
| 554 |
('d', 'o', 'k', ST_GeomFromText('POINT(48 228)')), |
| 555 |
('x', 'c', 'e', ST_GeomFromText('POINT(204 2)')), |
| 556 |
('e', 'e', 'g', ST_GeomFromText('POINT(125 43)')), |
| 557 |
('o', 'r', 'f', ST_GeomFromText('POINT(171 140)')); |
| 558 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(163 157)') where c1 like 'w%'; |
| 559 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(53 151)') where c1 like 'd%'; |
| 560 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(96 183)') where c1 like 'r%'; |
| 561 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(57 91)') where c1 like 'q%'; |
| 562 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(202 110)') where c1 like 'c%'; |
| 563 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(120 137)') where c1 like 'w%'; |
| 564 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(207 147)') where c1 like 'c%'; |
| 565 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(31 125)') where c1 like 'e%'; |
| 566 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(27 36)') where c1 like 'r%'; |
| 567 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 568 |
('b', 'c', 'e', ST_GeomFromText('POINT(41 137)')), |
| 569 |
('p', 'y', 'k', ST_GeomFromText('POINT(50 22)')), |
| 570 |
('s', 'c', 'h', ST_GeomFromText('POINT(208 173)')), |
| 571 |
('x', 'u', 'l', ST_GeomFromText('POINT(199 175)')), |
| 572 |
('s', 'r', 'h', ST_GeomFromText('POINT(85 192)')), |
| 573 |
('j', 'k', 'u', ST_GeomFromText('POINT(18 25)')), |
| 574 |
('p', 'w', 'h', ST_GeomFromText('POINT(152 197)')), |
| 575 |
('e', 'd', 'c', ST_GeomFromText('POINT(229 3)')), |
| 576 |
('o', 'x', 'k', ST_GeomFromText('POINT(187 155)')), |
| 577 |
('o', 'b', 'k', ST_GeomFromText('POINT(208 150)')), |
| 578 |
('d', 'a', 'j', ST_GeomFromText('POINT(70 87)')), |
| 579 |
('f', 'e', 'k', ST_GeomFromText('POINT(156 96)')), |
| 580 |
('u', 'y', 'p', ST_GeomFromText('POINT(239 193)')), |
| 581 |
('n', 'v', 'p', ST_GeomFromText('POINT(223 98)')), |
| 582 |
('z', 'j', 'r', ST_GeomFromText('POINT(87 89)')), |
| 583 |
('h', 'x', 'x', ST_GeomFromText('POINT(92 0)')), |
| 584 |
('r', 'v', 'r', ST_GeomFromText('POINT(159 139)')), |
| 585 |
('v', 'g', 'g', ST_GeomFromText('POINT(16 229)')), |
| 586 |
('z', 'k', 'u', ST_GeomFromText('POINT(99 52)')), |
| 587 |
('p', 'p', 'o', ST_GeomFromText('POINT(105 125)')), |
| 588 |
('w', 'h', 'y', ST_GeomFromText('POINT(105 154)')), |
| 589 |
('v', 'y', 'z', ST_GeomFromText('POINT(134 238)')), |
| 590 |
('x', 'o', 'o', ST_GeomFromText('POINT(178 88)')), |
| 591 |
('z', 'w', 'd', ST_GeomFromText('POINT(123 60)')), |
| 592 |
('q', 'f', 'u', ST_GeomFromText('POINT(64 90)')), |
| 593 |
('s', 'n', 't', ST_GeomFromText('POINT(50 138)')), |
| 594 |
('v', 'p', 't', ST_GeomFromText('POINT(114 91)')), |
| 595 |
('a', 'o', 'n', ST_GeomFromText('POINT(78 43)')), |
| 596 |
('k', 'u', 'd', ST_GeomFromText('POINT(185 161)')), |
| 597 |
('w', 'd', 'n', ST_GeomFromText('POINT(25 92)')), |
| 598 |
('k', 'w', 'a', ST_GeomFromText('POINT(59 238)')), |
| 599 |
('t', 'c', 'f', ST_GeomFromText('POINT(65 87)')), |
| 600 |
('g', 's', 'p', ST_GeomFromText('POINT(238 126)')), |
| 601 |
('d', 'n', 'y', ST_GeomFromText('POINT(107 173)')), |
| 602 |
('l', 'a', 'w', ST_GeomFromText('POINT(125 152)')), |
| 603 |
('m', 'd', 'j', ST_GeomFromText('POINT(146 53)')), |
| 604 |
('q', 'm', 'c', ST_GeomFromText('POINT(217 187)')), |
| 605 |
('i', 'r', 'r', ST_GeomFromText('POINT(6 113)')), |
| 606 |
('e', 'j', 'b', ST_GeomFromText('POINT(37 83)')), |
| 607 |
('w', 'w', 'h', ST_GeomFromText('POINT(83 199)')), |
| 608 |
('k', 'b', 's', ST_GeomFromText('POINT(170 64)')), |
| 609 |
('s', 'b', 'c', ST_GeomFromText('POINT(163 130)')), |
| 610 |
('c', 'h', 'a', ST_GeomFromText('POINT(141 3)')), |
| 611 |
('k', 'j', 'u', ST_GeomFromText('POINT(143 76)')), |
| 612 |
('r', 'h', 'o', ST_GeomFromText('POINT(243 92)')), |
| 613 |
('i', 'd', 'b', ST_GeomFromText('POINT(205 13)')), |
| 614 |
('r', 'y', 'q', ST_GeomFromText('POINT(138 8)')), |
| 615 |
('m', 'o', 'i', ST_GeomFromText('POINT(36 45)')), |
| 616 |
('v', 'g', 'm', ST_GeomFromText('POINT(0 40)')), |
| 617 |
('f', 'e', 'i', ST_GeomFromText('POINT(76 6)')), |
| 618 |
('c', 'q', 'q', ST_GeomFromText('POINT(115 248)')), |
| 619 |
('x', 'c', 'i', ST_GeomFromText('POINT(29 74)')), |
| 620 |
('l', 's', 't', ST_GeomFromText('POINT(83 18)')), |
| 621 |
('t', 't', 'a', ST_GeomFromText('POINT(26 168)')), |
| 622 |
('u', 'n', 'x', ST_GeomFromText('POINT(200 110)')), |
| 623 |
('j', 'b', 'd', ST_GeomFromText('POINT(216 136)')), |
| 624 |
('s', 'p', 'w', ST_GeomFromText('POINT(38 156)')), |
| 625 |
('f', 'b', 'v', ST_GeomFromText('POINT(29 186)')), |
| 626 |
('v', 'e', 'r', ST_GeomFromText('POINT(149 40)')), |
| 627 |
('v', 't', 'm', ST_GeomFromText('POINT(184 24)')), |
| 628 |
('y', 'g', 'a', ST_GeomFromText('POINT(219 105)')), |
| 629 |
('s', 'f', 'i', ST_GeomFromText('POINT(114 130)')), |
| 630 |
('e', 'q', 'h', ST_GeomFromText('POINT(203 135)')), |
| 631 |
('h', 'g', 'b', ST_GeomFromText('POINT(9 208)')), |
| 632 |
('o', 'l', 'r', ST_GeomFromText('POINT(245 79)')), |
| 633 |
('s', 's', 'v', ST_GeomFromText('POINT(238 198)')), |
| 634 |
('w', 'w', 'z', ST_GeomFromText('POINT(209 232)')), |
| 635 |
('v', 'd', 'n', ST_GeomFromText('POINT(30 193)')), |
| 636 |
('q', 'w', 'k', ST_GeomFromText('POINT(133 18)')), |
| 637 |
('o', 'h', 'o', ST_GeomFromText('POINT(42 140)')), |
| 638 |
('f', 'f', 'h', ST_GeomFromText('POINT(145 1)')), |
| 639 |
('u', 's', 'r', ST_GeomFromText('POINT(70 62)')), |
| 640 |
('x', 'n', 'q', ST_GeomFromText('POINT(33 86)')), |
| 641 |
('u', 'p', 'v', ST_GeomFromText('POINT(232 220)')), |
| 642 |
('z', 'e', 'a', ST_GeomFromText('POINT(130 69)')), |
| 643 |
('r', 'u', 'z', ST_GeomFromText('POINT(243 241)')), |
| 644 |
('b', 'n', 't', ST_GeomFromText('POINT(120 12)')), |
| 645 |
('u', 'f', 's', ST_GeomFromText('POINT(190 212)')), |
| 646 |
('a', 'd', 'q', ST_GeomFromText('POINT(235 191)')), |
| 647 |
('f', 'q', 'm', ST_GeomFromText('POINT(176 2)')), |
| 648 |
('n', 'c', 's', ST_GeomFromText('POINT(218 163)')), |
| 649 |
('e', 'm', 'h', ST_GeomFromText('POINT(163 108)')), |
| 650 |
('c', 'f', 'l', ST_GeomFromText('POINT(220 115)')), |
| 651 |
('c', 'v', 'q', ST_GeomFromText('POINT(66 45)')), |
| 652 |
('w', 'v', 'x', ST_GeomFromText('POINT(251 220)')), |
| 653 |
('f', 'w', 'z', ST_GeomFromText('POINT(146 149)')), |
| 654 |
('h', 'n', 'h', ST_GeomFromText('POINT(148 128)')), |
| 655 |
('y', 'k', 'v', ST_GeomFromText('POINT(28 110)')), |
| 656 |
('c', 'x', 'q', ST_GeomFromText('POINT(13 13)')), |
| 657 |
('e', 'd', 's', ST_GeomFromText('POINT(91 190)')), |
| 658 |
('c', 'w', 'c', ST_GeomFromText('POINT(10 231)')), |
| 659 |
('u', 'j', 'n', ST_GeomFromText('POINT(250 21)')), |
| 660 |
('w', 'n', 'x', ST_GeomFromText('POINT(141 69)')), |
| 661 |
('f', 'p', 'y', ST_GeomFromText('POINT(228 246)')), |
| 662 |
('d', 'q', 'f', ST_GeomFromText('POINT(194 22)')), |
| 663 |
('d', 'z', 'l', ST_GeomFromText('POINT(233 181)')), |
| 664 |
('c', 'a', 'q', ST_GeomFromText('POINT(183 96)')), |
| 665 |
('m', 'i', 'd', ST_GeomFromText('POINT(117 226)')), |
| 666 |
('z', 'y', 'y', ST_GeomFromText('POINT(62 81)')), |
| 667 |
('g', 'v', 'm', ST_GeomFromText('POINT(66 158)')); |
| 668 |
SET @@RAND_SEED1=481064922, @@RAND_SEED2=438133497; |
| 669 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 670 |
SET @@RAND_SEED1=280535103, @@RAND_SEED2=444518646; |
| 671 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 672 |
SET @@RAND_SEED1=1072017234, @@RAND_SEED2=484203885; |
| 673 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 674 |
SET @@RAND_SEED1=358851897, @@RAND_SEED2=358495224; |
| 675 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 676 |
SET @@RAND_SEED1=509031459, @@RAND_SEED2=675962925; |
| 677 |
DELETE FROM t1 ORDER BY RAND() LIMIT 10; |
| 678 |
#UPDATE t1 set spatial_point=ST_GeomFromText('POINT(61 203)') where c1 like 'y%'; |
| 679 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(202 194)') where c1 like 'f%'; |
| 680 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(228 18)') where c1 like 'h%'; |
| 681 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(88 18)') where c1 like 'l%'; |
| 682 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(176 94)') where c1 like 'e%'; |
| 683 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(44 47)') where c1 like 'g%'; |
| 684 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(95 191)') where c1 like 'b%'; |
| 685 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(179 218)') where c1 like 'y%'; |
| 686 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(239 40)') where c1 like 'g%'; |
| 687 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(248 41)') where c1 like 'q%'; |
| 688 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(167 82)') where c1 like 't%'; |
| 689 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(13 104)') where c1 like 'u%'; |
| 690 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(139 84)') where c1 like 'a%'; |
| 691 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(145 108)') where c1 like 'p%'; |
| 692 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(147 57)') where c1 like 't%'; |
| 693 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(217 144)') where c1 like 'n%'; |
| 694 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(160 224)') where c1 like 'w%'; |
| 695 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(38 28)') where c1 like 'j%'; |
| 696 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(104 114)') where c1 like 'q%'; |
| 697 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(88 19)') where c1 like 'c%'; |
| 698 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 699 |
('f', 'x', 'p', ST_GeomFromText('POINT(92 181)')), |
| 700 |
('s', 'i', 'c', ST_GeomFromText('POINT(49 60)')), |
| 701 |
('c', 'c', 'i', ST_GeomFromText('POINT(7 57)')), |
| 702 |
('n', 'g', 'k', ST_GeomFromText('POINT(252 105)')), |
| 703 |
('g', 'b', 'm', ST_GeomFromText('POINT(180 11)')), |
| 704 |
('u', 'l', 'r', ST_GeomFromText('POINT(32 90)')), |
| 705 |
('c', 'x', 'e', ST_GeomFromText('POINT(143 24)')), |
| 706 |
('x', 'u', 'a', ST_GeomFromText('POINT(123 92)')), |
| 707 |
('s', 'b', 'h', ST_GeomFromText('POINT(190 108)')), |
| 708 |
('c', 'x', 'b', ST_GeomFromText('POINT(104 100)')), |
| 709 |
('i', 'd', 't', ST_GeomFromText('POINT(214 104)')), |
| 710 |
('r', 'w', 'g', ST_GeomFromText('POINT(29 67)')), |
| 711 |
('b', 'f', 'g', ST_GeomFromText('POINT(149 46)')), |
| 712 |
('r', 'r', 'd', ST_GeomFromText('POINT(242 196)')), |
| 713 |
('j', 'l', 'a', ST_GeomFromText('POINT(90 196)')), |
| 714 |
('e', 't', 'b', ST_GeomFromText('POINT(190 64)')), |
| 715 |
('l', 'x', 'w', ST_GeomFromText('POINT(250 73)')), |
| 716 |
('q', 'y', 'r', ST_GeomFromText('POINT(120 182)')), |
| 717 |
('s', 'j', 'a', ST_GeomFromText('POINT(180 175)')), |
| 718 |
('n', 'i', 'y', ST_GeomFromText('POINT(124 136)')), |
| 719 |
('s', 'x', 's', ST_GeomFromText('POINT(176 209)')), |
| 720 |
('u', 'f', 's', ST_GeomFromText('POINT(215 173)')), |
| 721 |
('m', 'j', 'x', ST_GeomFromText('POINT(44 140)')), |
| 722 |
('v', 'g', 'x', ST_GeomFromText('POINT(177 233)')), |
| 723 |
('u', 't', 'b', ST_GeomFromText('POINT(136 197)')), |
| 724 |
('f', 'g', 'b', ST_GeomFromText('POINT(10 8)')), |
| 725 |
('v', 'c', 'j', ST_GeomFromText('POINT(13 81)')), |
| 726 |
('d', 's', 'q', ST_GeomFromText('POINT(200 100)')), |
| 727 |
('a', 'p', 'j', ST_GeomFromText('POINT(33 40)')), |
| 728 |
('i', 'c', 'g', ST_GeomFromText('POINT(168 204)')), |
| 729 |
('k', 'h', 'i', ST_GeomFromText('POINT(93 243)')), |
| 730 |
('s', 'b', 's', ST_GeomFromText('POINT(157 13)')), |
| 731 |
('v', 'l', 'l', ST_GeomFromText('POINT(103 6)')), |
| 732 |
('r', 'b', 'k', ST_GeomFromText('POINT(244 137)')), |
| 733 |
('l', 'd', 'r', ST_GeomFromText('POINT(162 254)')), |
| 734 |
('q', 'b', 'z', ST_GeomFromText('POINT(136 246)')), |
| 735 |
('x', 'x', 'p', ST_GeomFromText('POINT(120 37)')), |
| 736 |
('m', 'e', 'z', ST_GeomFromText('POINT(203 167)')), |
| 737 |
('q', 'n', 'p', ST_GeomFromText('POINT(94 119)')), |
| 738 |
('b', 'g', 'u', ST_GeomFromText('POINT(93 248)')), |
| 739 |
('r', 'v', 'v', ST_GeomFromText('POINT(53 88)')), |
| 740 |
('y', 'a', 'i', ST_GeomFromText('POINT(98 219)')), |
| 741 |
('a', 's', 'g', ST_GeomFromText('POINT(173 138)')), |
| 742 |
('c', 'a', 't', ST_GeomFromText('POINT(235 135)')), |
| 743 |
('q', 'm', 'd', ST_GeomFromText('POINT(224 208)')), |
| 744 |
('e', 'p', 'k', ST_GeomFromText('POINT(161 238)')), |
| 745 |
('n', 'g', 'q', ST_GeomFromText('POINT(35 204)')), |
| 746 |
('t', 't', 'x', ST_GeomFromText('POINT(230 178)')), |
| 747 |
('w', 'f', 'a', ST_GeomFromText('POINT(150 221)')), |
| 748 |
('z', 'm', 'z', ST_GeomFromText('POINT(119 42)')), |
| 749 |
('l', 'j', 's', ST_GeomFromText('POINT(97 96)')), |
| 750 |
('f', 'z', 'x', ST_GeomFromText('POINT(208 65)')), |
| 751 |
('i', 'v', 'c', ST_GeomFromText('POINT(145 79)')), |
| 752 |
('l', 'f', 'k', ST_GeomFromText('POINT(83 234)')), |
| 753 |
('u', 'a', 's', ST_GeomFromText('POINT(250 49)')), |
| 754 |
('o', 'k', 'p', ST_GeomFromText('POINT(46 50)')), |
| 755 |
('d', 'e', 'z', ST_GeomFromText('POINT(30 198)')), |
| 756 |
('r', 'r', 'l', ST_GeomFromText('POINT(78 189)')), |
| 757 |
('y', 'l', 'f', ST_GeomFromText('POINT(188 132)')), |
| 758 |
('d', 'q', 'm', ST_GeomFromText('POINT(247 107)')), |
| 759 |
('p', 'j', 'n', ST_GeomFromText('POINT(148 227)')), |
| 760 |
('b', 'o', 'i', ST_GeomFromText('POINT(172 25)')), |
| 761 |
('e', 'v', 'd', ST_GeomFromText('POINT(94 248)')), |
| 762 |
('q', 'd', 'f', ST_GeomFromText('POINT(15 29)')), |
| 763 |
('w', 'b', 'b', ST_GeomFromText('POINT(74 111)')), |
| 764 |
('g', 'q', 'f', ST_GeomFromText('POINT(107 215)')), |
| 765 |
('o', 'h', 'r', ST_GeomFromText('POINT(25 168)')), |
| 766 |
('u', 't', 'w', ST_GeomFromText('POINT(251 188)')), |
| 767 |
('h', 's', 'w', ST_GeomFromText('POINT(254 247)')), |
| 768 |
('f', 'f', 'b', ST_GeomFromText('POINT(166 103)')); |
| 769 |
SET @@RAND_SEED1=866613816, @@RAND_SEED2=92289615; |
| 770 |
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES |
| 771 |
('l', 'c', 'l', ST_GeomFromText('POINT(202 98)')), |
| 772 |
('k', 'c', 'b', ST_GeomFromText('POINT(46 206)')), |
| 773 |
('r', 'y', 'm', ST_GeomFromText('POINT(74 140)')), |
| 774 |
('y', 'z', 'd', ST_GeomFromText('POINT(200 160)')), |
| 775 |
('s', 'y', 's', ST_GeomFromText('POINT(156 205)')), |
| 776 |
('u', 'v', 'p', ST_GeomFromText('POINT(86 82)')), |
| 777 |
('j', 's', 's', ST_GeomFromText('POINT(91 233)')), |
| 778 |
('x', 'j', 'f', ST_GeomFromText('POINT(3 14)')), |
| 779 |
('l', 'z', 'v', ST_GeomFromText('POINT(123 156)')), |
| 780 |
('h', 'i', 'o', ST_GeomFromText('POINT(145 229)')), |
| 781 |
('o', 'r', 'd', ST_GeomFromText('POINT(15 22)')), |
| 782 |
('f', 'x', 't', ST_GeomFromText('POINT(21 60)')), |
| 783 |
('t', 'g', 'h', ST_GeomFromText('POINT(50 153)')), |
| 784 |
('g', 'u', 'b', ST_GeomFromText('POINT(82 85)')), |
| 785 |
('v', 'a', 'p', ST_GeomFromText('POINT(231 178)')), |
| 786 |
('n', 'v', 'o', ST_GeomFromText('POINT(183 25)')), |
| 787 |
('j', 'n', 'm', ST_GeomFromText('POINT(50 144)')), |
| 788 |
('e', 'f', 'i', ST_GeomFromText('POINT(46 16)')), |
| 789 |
('d', 'w', 'a', ST_GeomFromText('POINT(66 6)')), |
| 790 |
('f', 'x', 'a', ST_GeomFromText('POINT(107 197)')), |
| 791 |
('m', 'o', 'a', ST_GeomFromText('POINT(142 80)')), |
| 792 |
('q', 'l', 'g', ST_GeomFromText('POINT(251 23)')), |
| 793 |
('c', 's', 's', ST_GeomFromText('POINT(158 43)')), |
| 794 |
('y', 'd', 'o', ST_GeomFromText('POINT(196 228)')), |
| 795 |
('d', 'p', 'l', ST_GeomFromText('POINT(107 5)')), |
| 796 |
('h', 'a', 'b', ST_GeomFromText('POINT(183 166)')), |
| 797 |
('m', 'w', 'p', ST_GeomFromText('POINT(19 59)')), |
| 798 |
('b', 'y', 'o', ST_GeomFromText('POINT(178 30)')), |
| 799 |
('x', 'w', 'i', ST_GeomFromText('POINT(168 94)')), |
| 800 |
('t', 'k', 'z', ST_GeomFromText('POINT(171 5)')), |
| 801 |
('r', 'm', 'a', ST_GeomFromText('POINT(222 19)')), |
| 802 |
('u', 'v', 'e', ST_GeomFromText('POINT(224 80)')), |
| 803 |
('q', 'r', 'k', ST_GeomFromText('POINT(212 218)')), |
| 804 |
('d', 'p', 'j', ST_GeomFromText('POINT(169 7)')), |
| 805 |
('d', 'r', 'v', ST_GeomFromText('POINT(193 23)')), |
| 806 |
('n', 'y', 'y', ST_GeomFromText('POINT(130 178)')), |
| 807 |
('m', 'z', 'r', ST_GeomFromText('POINT(81 200)')), |
| 808 |
('j', 'e', 'w', ST_GeomFromText('POINT(145 239)')), |
| 809 |
('v', 'h', 'x', ST_GeomFromText('POINT(24 105)')), |
| 810 |
('z', 'm', 'a', ST_GeomFromText('POINT(175 129)')), |
| 811 |
('b', 'c', 'v', ST_GeomFromText('POINT(213 10)')), |
| 812 |
('t', 't', 'u', ST_GeomFromText('POINT(2 129)')), |
| 813 |
('r', 's', 'v', ST_GeomFromText('POINT(209 192)')), |
| 814 |
('x', 'p', 'g', ST_GeomFromText('POINT(43 63)')), |
| 815 |
('t', 'e', 'u', ST_GeomFromText('POINT(139 210)')), |
| 816 |
('l', 'e', 't', ST_GeomFromText('POINT(245 148)')), |
| 817 |
('a', 'i', 'k', ST_GeomFromText('POINT(167 195)')), |
| 818 |
('m', 'o', 'h', ST_GeomFromText('POINT(206 120)')), |
| 819 |
('g', 'z', 's', ST_GeomFromText('POINT(169 240)')), |
| 820 |
('z', 'u', 's', ST_GeomFromText('POINT(202 120)')), |
| 821 |
('i', 'b', 'a', ST_GeomFromText('POINT(216 18)')), |
| 822 |
('w', 'y', 'g', ST_GeomFromText('POINT(119 236)')), |
| 823 |
('h', 'y', 'p', ST_GeomFromText('POINT(161 24)')); |
| 824 |
CHECK TABLE t1 EXTENDED; |
| 825 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(33 100)') where c1 like 't%'; |
| 826 |
CHECK TABLE t1 EXTENDED; |
| 827 |
UPDATE t1 set spatial_point=ST_GeomFromText('POINT(41 46)') where c1 like 'f%'; |
| 828 |
CHECK TABLE t1 EXTENDED; |
| 829 |
DROP TABLE t1; |
| 830 |
|
| 831 |
# |
| 832 |
# Bug #30286 spatial index cause corruption and server crash! |
| 833 |
# |
| 834 |
|
| 835 |
create table t1 (a geometry not null SRID 0, spatial index(a)); |
| 836 |
insert into t1 values (POINT(1.1517219314031e+164, 131072)); |
| 837 |
insert into t1 values (POINT(9.1248812352444e+192, 2.9740338169556e+284)); |
| 838 |
insert into t1 values (POINT(4.7783097267365e-299, -0)); |
| 839 |
insert into t1 values (POINT(1.49166814624e-154, 2.0880974297595e-53)); |
| 840 |
insert into t1 values (POINT(4.0917382598702e+149, 1.2024538023802e+111)); |
| 841 |
insert into t1 values (POINT(2.0349165139404e+236, 2.9993936277913e-241)); |
| 842 |
insert into t1 values (POINT(2.5243548967072e-29, 1.2024538023802e+111)); |
| 843 |
insert into t1 values (POINT(0, 6.9835074892995e-251)); |
| 844 |
insert into t1 values (POINT(2.0880974297595e-53, 3.1050361846014e+231)); |
| 845 |
insert into t1 values (POINT(2.8728483499323e-188, 2.4600631144627e+260)); |
| 846 |
insert into t1 values (POINT(3.0517578125e-05, 2.0349165139404e+236)); |
| 847 |
insert into t1 values (POINT(1.1517219314031e+164, 1.1818212630766e-125)); |
| 848 |
insert into t1 values (POINT(2.481040258324e-265, 5.7766220027675e-275)); |
| 849 |
insert into t1 values (POINT(2.0880974297595e-53, 2.5243548967072e-29)); |
| 850 |
insert into t1 values (POINT(5.7766220027675e-275, 9.9464647281957e+86)); |
| 851 |
insert into t1 values (POINT(2.2181357552967e+130, 3.7857669957337e-270)); |
| 852 |
insert into t1 values (POINT(4.5767114681874e-246, 3.6893488147419e+19)); |
| 853 |
insert into t1 values (POINT(4.5767114681874e-246, 3.7537584144024e+255)); |
| 854 |
insert into t1 values (POINT(3.7857669957337e-270, 1.8033161362863e-130)); |
| 855 |
insert into t1 values (POINT(0, 5.8774717541114e-39)); |
| 856 |
insert into t1 values (POINT(1.1517219314031e+164, 2.2761049594727e-159)); |
| 857 |
insert into t1 values (POINT(6.243497100632e+144, 3.7857669957337e-270)); |
| 858 |
insert into t1 values (POINT(3.7857669957337e-270, 2.6355494858076e-82)); |
| 859 |
insert into t1 values (POINT(2.0349165139404e+236, 3.8518598887745e-34)); |
| 860 |
insert into t1 values (POINT(4.6566128730774e-10, 2.0880974297595e-53)); |
| 861 |
insert into t1 values (POINT(2.0880974297595e-53, 1.8827498946116e-183)); |
| 862 |
insert into t1 values (POINT(1.8033161362863e-130, 9.1248812352444e+192)); |
| 863 |
insert into t1 values (POINT(4.7783097267365e-299, 2.2761049594727e-159)); |
| 864 |
insert into t1 values (POINT(1.94906280228e+289, 1.2338789709327e-178)); |
| 865 |
drop table t1; |
| 866 |
|
| 867 |
# End of 4.1 tests |
| 868 |
|
| 869 |
# |
| 870 |
# bug #21790 (UNKNOWN ERROR on NULLs in RTree) |
| 871 |
# |
| 872 |
CREATE TABLE t1(foo GEOMETRY NOT NULL SRID 0, SPATIAL INDEX(foo) ); |
| 873 |
--error ER_BAD_NULL_ERROR_NOT_IGNORED |
| 874 |
INSERT INTO t1(foo) VALUES (NULL); |
| 875 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 876 |
--error ER_NO_DEFAULT_FOR_FIELD |
| 877 |
INSERT INTO t1() VALUES (); |
| 878 |
SET sql_mode = default; |
| 879 |
--error 1416 |
| 880 |
INSERT INTO t1(foo) VALUES (''); |
| 881 |
DROP TABLE t1; |
| 882 |
|
| 883 |
# |
| 884 |
# Bug #23578: Corruption prevents Optimize table from working properly with a |
| 885 |
# spatial index |
| 886 |
# |
| 887 |
|
| 888 |
CREATE TABLE t1 (a INT AUTO_INCREMENT, b POINT NOT NULL SRID 0, KEY (a), SPATIAL KEY (b)); |
| 889 |
|
| 890 |
INSERT INTO t1 (b) VALUES (ST_GeomFromText('POINT(1 2)')); |
| 891 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 892 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 893 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 894 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 895 |
INSERT INTO t1 (b) SELECT b FROM t1; |
| 896 |
|
| 897 |
OPTIMIZE TABLE t1; |
| 898 |
DROP TABLE t1; |
| 899 |
|
| 900 |
|
| 901 |
# |
| 902 |
# Bug #29070: Error in spatial index |
| 903 |
# |
| 904 |
|
| 905 |
CREATE TABLE t1 (a INT, b GEOMETRY NOT NULL SRID 0, SPATIAL KEY b(b)); |
| 906 |
INSERT INTO t1 VALUES (1, ST_GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)')); |
| 907 |
INSERT INTO t1 VALUES (2, ST_GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)')); |
| 908 |
|
| 909 |
# must return the same number as the next select |
| 910 |
SELECT COUNT(*) FROM t1 WHERE |
| 911 |
MBRINTERSECTS(b, ST_GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') ); |
| 912 |
SELECT COUNT(*) FROM t1 IGNORE INDEX (b) WHERE |
| 913 |
MBRINTERSECTS(b, ST_GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') ); |
| 914 |
|
| 915 |
DROP TABLE t1; |
| 916 |
|
| 917 |
|
| 918 |
--echo # |
| 919 |
--echo # Bug #48258: Assertion failed when using a spatial index |
| 920 |
--echo # |
| 921 |
CREATE TABLE t1(a LINESTRING NOT NULL SRID 0, SPATIAL KEY(a)); |
| 922 |
INSERT INTO t1 VALUES |
| 923 |
(ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)')), |
| 924 |
(ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)')); |
| 925 |
EXPLAIN SELECT 1 FROM t1 WHERE a = ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 926 |
SELECT 1 FROM t1 WHERE a = ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 927 |
--error ER_WRONG_ARGUMENTS |
| 928 |
EXPLAIN SELECT 1 FROM t1 WHERE a < ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 929 |
--error ER_WRONG_ARGUMENTS |
| 930 |
SELECT 1 FROM t1 WHERE a < ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 931 |
--error ER_WRONG_ARGUMENTS |
| 932 |
EXPLAIN SELECT 1 FROM t1 WHERE a <= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 933 |
--error ER_WRONG_ARGUMENTS |
| 934 |
SELECT 1 FROM t1 WHERE a <= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 935 |
--error ER_WRONG_ARGUMENTS |
| 936 |
EXPLAIN SELECT 1 FROM t1 WHERE a > ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 937 |
--error ER_WRONG_ARGUMENTS |
| 938 |
SELECT 1 FROM t1 WHERE a > ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 939 |
--error ER_WRONG_ARGUMENTS |
| 940 |
EXPLAIN SELECT 1 FROM t1 WHERE a >= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 941 |
--error ER_WRONG_ARGUMENTS |
| 942 |
SELECT 1 FROM t1 WHERE a >= ST_GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'); |
| 943 |
DROP TABLE t1; |
| 944 |
|
| 945 |
|
| 946 |
--echo # |
| 947 |
--echo # Bug #51357: crash when using handler commands on spatial indexes |
| 948 |
--echo # |
| 949 |
|
| 950 |
CREATE TABLE t1(a GEOMETRY NOT NULL SRID 0,SPATIAL INDEX a(a)); |
| 951 |
HANDLER t1 OPEN; |
| 952 |
HANDLER t1 READ a FIRST; |
| 953 |
HANDLER t1 READ a NEXT; |
| 954 |
HANDLER t1 READ a PREV; |
| 955 |
HANDLER t1 READ a LAST; |
| 956 |
HANDLER t1 CLOSE; |
| 957 |
|
| 958 |
# second crash fixed when the tree has changed since the last search. |
| 959 |
HANDLER t1 OPEN; |
| 960 |
HANDLER t1 READ a FIRST; |
| 961 |
INSERT INTO t1 VALUES (ST_GeomFromText('Polygon((40 40,60 40,60 60,40 60,40 40))')); |
| 962 |
--echo # should not crash |
| 963 |
--disable_result_log |
| 964 |
HANDLER t1 READ a NEXT; |
| 965 |
--enable_result_log |
| 966 |
HANDLER t1 CLOSE; |
| 967 |
|
| 968 |
DROP TABLE t1; |
| 969 |
|
| 970 |
|
| 971 |
--echo End of 5.0 tests. |
| 972 |
|
| 973 |
|
| 974 |
--echo # |
| 975 |
--echo # Bug #57323/11764487: myisam corruption with insert ignore |
| 976 |
--echo # and invalid spatial data |
| 977 |
--echo # |
| 978 |
|
| 979 |
CREATE TABLE t1(a LINESTRING NOT NULL SRID 0, b GEOMETRY NOT NULL SRID 0, |
| 980 |
SPATIAL KEY(a), SPATIAL KEY(b)) ENGINE=InnoDB; |
| 981 |
--error ER_CANT_CREATE_GEOMETRY_OBJECT |
| 982 |
INSERT INTO t1 VALUES(ST_GEOMFROMTEXT("point (0 0)"), ST_GEOMFROMTEXT("point (1 1)")); |
| 983 |
--error ER_CANT_CREATE_GEOMETRY_OBJECT |
| 984 |
INSERT IGNORE INTO t1 SET a=ST_GEOMFROMTEXT("point (-6 0)"), b=ST_GEOMFROMTEXT("error"); |
| 985 |
--error ER_CANT_CREATE_GEOMETRY_OBJECT |
| 986 |
INSERT IGNORE INTO t1 SET a=ST_GEOMFROMTEXT("point (-6 0)"), b=NULL; |
| 987 |
SELECT ST_ASTEXT(a), ST_ASTEXT(b) FROM t1; |
| 988 |
DROP TABLE t1; |
| 989 |
|
| 990 |
CREATE TABLE t1(a INT NOT NULL, b GEOMETRY NOT NULL SRID 0, |
| 991 |
KEY(a), SPATIAL KEY(b)) ENGINE=InnoDB; |
| 992 |
INSERT INTO t1 VALUES(0, ST_GEOMFROMTEXT("point (1 1)")); |
| 993 |
--error ER_GIS_INVALID_DATA |
| 994 |
INSERT IGNORE INTO t1 SET a=0, b=ST_GEOMFROMTEXT("error"); |
| 995 |
--error ER_BAD_NULL_ERROR_NOT_IGNORED |
| 996 |
INSERT IGNORE INTO t1 SET a=1, b=NULL; |
| 997 |
SELECT a, ST_ASTEXT(b) FROM t1; |
| 998 |
DROP TABLE t1; |
| 999 |
|
| 1000 |
--echo End of 5.1 tests |