gis-rtree.test

视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.

  ('k', 'u', 'd', GeomFromText('POINT(185 161)')),
  ('w', 'd', 'n', GeomFromText('POINT(25 92)')),
  ('k', 'w', 'a', GeomFromText('POINT(59 238)')),
  ('t', 'c', 'f', GeomFromText('POINT(65 87)')),
  ('g', 's', 'p', GeomFromText('POINT(238 126)')),
  ('d', 'n', 'y', GeomFromText('POINT(107 173)')),
  ('l', 'a', 'w', GeomFromText('POINT(125 152)')),
  ('m', 'd', 'j', GeomFromText('POINT(146 53)')),
  ('q', 'm', 'c', GeomFromText('POINT(217 187)')),
  ('i', 'r', 'r', GeomFromText('POINT(6 113)')),
  ('e', 'j', 'b', GeomFromText('POINT(37 83)')),
  ('w', 'w', 'h', GeomFromText('POINT(83 199)')),
  ('k', 'b', 's', GeomFromText('POINT(170 64)')),
  ('s', 'b', 'c', GeomFromText('POINT(163 130)')),
  ('c', 'h', 'a', GeomFromText('POINT(141 3)')),
  ('k', 'j', 'u', GeomFromText('POINT(143 76)')),
  ('r', 'h', 'o', GeomFromText('POINT(243 92)')),
  ('i', 'd', 'b', GeomFromText('POINT(205 13)')),
  ('r', 'y', 'q', GeomFromText('POINT(138 8)')),
  ('m', 'o', 'i', GeomFromText('POINT(36 45)')),
  ('v', 'g', 'm', GeomFromText('POINT(0 40)')),
  ('f', 'e', 'i', GeomFromText('POINT(76 6)')),
  ('c', 'q', 'q', GeomFromText('POINT(115 248)')),
  ('x', 'c', 'i', GeomFromText('POINT(29 74)')),
  ('l', 's', 't', GeomFromText('POINT(83 18)')),
  ('t', 't', 'a', GeomFromText('POINT(26 168)')),
  ('u', 'n', 'x', GeomFromText('POINT(200 110)')),
  ('j', 'b', 'd', GeomFromText('POINT(216 136)')),
  ('s', 'p', 'w', GeomFromText('POINT(38 156)')),
  ('f', 'b', 'v', GeomFromText('POINT(29 186)')),
  ('v', 'e', 'r', GeomFromText('POINT(149 40)')),
  ('v', 't', 'm', GeomFromText('POINT(184 24)')),
  ('y', 'g', 'a', GeomFromText('POINT(219 105)')),
  ('s', 'f', 'i', GeomFromText('POINT(114 130)')),
  ('e', 'q', 'h', GeomFromText('POINT(203 135)')),
  ('h', 'g', 'b', GeomFromText('POINT(9 208)')),
  ('o', 'l', 'r', GeomFromText('POINT(245 79)')),
  ('s', 's', 'v', GeomFromText('POINT(238 198)')),
  ('w', 'w', 'z', GeomFromText('POINT(209 232)')),
  ('v', 'd', 'n', GeomFromText('POINT(30 193)')),
  ('q', 'w', 'k', GeomFromText('POINT(133 18)')),
  ('o', 'h', 'o', GeomFromText('POINT(42 140)')),
  ('f', 'f', 'h', GeomFromText('POINT(145 1)')),
  ('u', 's', 'r', GeomFromText('POINT(70 62)')),
  ('x', 'n', 'q', GeomFromText('POINT(33 86)')),
  ('u', 'p', 'v', GeomFromText('POINT(232 220)')),
  ('z', 'e', 'a', GeomFromText('POINT(130 69)')),
  ('r', 'u', 'z', GeomFromText('POINT(243 241)')),
  ('b', 'n', 't', GeomFromText('POINT(120 12)')),
  ('u', 'f', 's', GeomFromText('POINT(190 212)')),
  ('a', 'd', 'q', GeomFromText('POINT(235 191)')),
  ('f', 'q', 'm', GeomFromText('POINT(176 2)')),
  ('n', 'c', 's', GeomFromText('POINT(218 163)')),
  ('e', 'm', 'h', GeomFromText('POINT(163 108)')),
  ('c', 'f', 'l', GeomFromText('POINT(220 115)')),
  ('c', 'v', 'q', GeomFromText('POINT(66 45)')),
  ('w', 'v', 'x', GeomFromText('POINT(251 220)')),
  ('f', 'w', 'z', GeomFromText('POINT(146 149)')),
  ('h', 'n', 'h', GeomFromText('POINT(148 128)')),
  ('y', 'k', 'v', GeomFromText('POINT(28 110)')),
  ('c', 'x', 'q', GeomFromText('POINT(13 13)')),
  ('e', 'd', 's', GeomFromText('POINT(91 190)')),
  ('c', 'w', 'c', GeomFromText('POINT(10 231)')),
  ('u', 'j', 'n', GeomFromText('POINT(250 21)')),
  ('w', 'n', 'x', GeomFromText('POINT(141 69)')),
  ('f', 'p', 'y', GeomFromText('POINT(228 246)')),
  ('d', 'q', 'f', GeomFromText('POINT(194 22)')),
  ('d', 'z', 'l', GeomFromText('POINT(233 181)')),
  ('c', 'a', 'q', GeomFromText('POINT(183 96)')),
  ('m', 'i', 'd', GeomFromText('POINT(117 226)')),
  ('z', 'y', 'y', GeomFromText('POINT(62 81)')),
  ('g', 'v', 'm', GeomFromText('POINT(66 158)'));
SET @@RAND_SEED1=481064922, @@RAND_SEED2=438133497;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=280535103, @@RAND_SEED2=444518646;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=1072017234, @@RAND_SEED2=484203885;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=358851897, @@RAND_SEED2=358495224;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=509031459, @@RAND_SEED2=675962925;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
UPDATE t1 set spatial_point=GeomFromText('POINT(61 203)') where  c1 like 'y%';
UPDATE t1 set spatial_point=GeomFromText('POINT(202 194)') where  c1 like 'f%';
UPDATE t1 set spatial_point=GeomFromText('POINT(228 18)') where  c1 like 'h%';
UPDATE t1 set spatial_point=GeomFromText('POINT(88 18)') where  c1 like 'l%';
UPDATE t1 set spatial_point=GeomFromText('POINT(176 94)') where  c1 like 'e%';
UPDATE t1 set spatial_point=GeomFromText('POINT(44 47)') where  c1 like 'g%';
UPDATE t1 set spatial_point=GeomFromText('POINT(95 191)') where  c1 like 'b%';
UPDATE t1 set spatial_point=GeomFromText('POINT(179 218)') where  c1 like 'y%';
UPDATE t1 set spatial_point=GeomFromText('POINT(239 40)') where  c1 like 'g%';
UPDATE t1 set spatial_point=GeomFromText('POINT(248 41)') where  c1 like 'q%';
UPDATE t1 set spatial_point=GeomFromText('POINT(167 82)') where  c1 like 't%';
UPDATE t1 set spatial_point=GeomFromText('POINT(13 104)') where  c1 like 'u%';
UPDATE t1 set spatial_point=GeomFromText('POINT(139 84)') where  c1 like 'a%';
UPDATE t1 set spatial_point=GeomFromText('POINT(145 108)') where  c1 like 'p%';
UPDATE t1 set spatial_point=GeomFromText('POINT(147 57)') where  c1 like 't%';
UPDATE t1 set spatial_point=GeomFromText('POINT(217 144)') where  c1 like 'n%';
UPDATE t1 set spatial_point=GeomFromText('POINT(160 224)') where  c1 like 'w%';
UPDATE t1 set spatial_point=GeomFromText('POINT(38 28)') where  c1 like 'j%';
UPDATE t1 set spatial_point=GeomFromText('POINT(104 114)') where  c1 like 'q%';
UPDATE t1 set spatial_point=GeomFromText('POINT(88 19)') where  c1 like 'c%';
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
  ('f', 'x', 'p', GeomFromText('POINT(92 181)')),
  ('s', 'i', 'c', GeomFromText('POINT(49 60)')),
  ('c', 'c', 'i', GeomFromText('POINT(7 57)')),
  ('n', 'g', 'k', GeomFromText('POINT(252 105)')),
  ('g', 'b', 'm', GeomFromText('POINT(180 11)')),
  ('u', 'l', 'r', GeomFromText('POINT(32 90)')),
  ('c', 'x', 'e', GeomFromText('POINT(143 24)')),
  ('x', 'u', 'a', GeomFromText('POINT(123 92)')),
  ('s', 'b', 'h', GeomFromText('POINT(190 108)')),
  ('c', 'x', 'b', GeomFromText('POINT(104 100)')),
  ('i', 'd', 't', GeomFromText('POINT(214 104)')),
  ('r', 'w', 'g', GeomFromText('POINT(29 67)')),
  ('b', 'f', 'g', GeomFromText('POINT(149 46)')),
  ('r', 'r', 'd', GeomFromText('POINT(242 196)')),
  ('j', 'l', 'a', GeomFromText('POINT(90 196)')),
  ('e', 't', 'b', GeomFromText('POINT(190 64)')),
  ('l', 'x', 'w', GeomFromText('POINT(250 73)')),
  ('q', 'y', 'r', GeomFromText('POINT(120 182)')),
  ('s', 'j', 'a', GeomFromText('POINT(180 175)')),
  ('n', 'i', 'y', GeomFromText('POINT(124 136)')),
  ('s', 'x', 's', GeomFromText('POINT(176 209)')),
  ('u', 'f', 's', GeomFromText('POINT(215 173)')),
  ('m', 'j', 'x', GeomFromText('POINT(44 140)')),
  ('v', 'g', 'x', GeomFromText('POINT(177 233)')),
  ('u', 't', 'b', GeomFromText('POINT(136 197)')),
  ('f', 'g', 'b', GeomFromText('POINT(10 8)')),
  ('v', 'c', 'j', GeomFromText('POINT(13 81)')),
  ('d', 's', 'q', GeomFromText('POINT(200 100)')),
  ('a', 'p', 'j', GeomFromText('POINT(33 40)')),
  ('i', 'c', 'g', GeomFromText('POINT(168 204)')),
  ('k', 'h', 'i', GeomFromText('POINT(93 243)')),
  ('s', 'b', 's', GeomFromText('POINT(157 13)')),
  ('v', 'l', 'l', GeomFromText('POINT(103 6)')),
  ('r', 'b', 'k', GeomFromText('POINT(244 137)')),
  ('l', 'd', 'r', GeomFromText('POINT(162 254)')),
  ('q', 'b', 'z', GeomFromText('POINT(136 246)')),
  ('x', 'x', 'p', GeomFromText('POINT(120 37)')),
  ('m', 'e', 'z', GeomFromText('POINT(203 167)')),
  ('q', 'n', 'p', GeomFromText('POINT(94 119)')),
  ('b', 'g', 'u', GeomFromText('POINT(93 248)')),
  ('r', 'v', 'v', GeomFromText('POINT(53 88)')),
  ('y', 'a', 'i', GeomFromText('POINT(98 219)')),
  ('a', 's', 'g', GeomFromText('POINT(173 138)')),
  ('c', 'a', 't', GeomFromText('POINT(235 135)')),
  ('q', 'm', 'd', GeomFromText('POINT(224 208)')),
  ('e', 'p', 'k', GeomFromText('POINT(161 238)')),
  ('n', 'g', 'q', GeomFromText('POINT(35 204)')),
  ('t', 't', 'x', GeomFromText('POINT(230 178)')),
  ('w', 'f', 'a', GeomFromText('POINT(150 221)')),
  ('z', 'm', 'z', GeomFromText('POINT(119 42)')),
  ('l', 'j', 's', GeomFromText('POINT(97 96)')),
  ('f', 'z', 'x', GeomFromText('POINT(208 65)')),
  ('i', 'v', 'c', GeomFromText('POINT(145 79)')),
  ('l', 'f', 'k', GeomFromText('POINT(83 234)')),
  ('u', 'a', 's', GeomFromText('POINT(250 49)')),
  ('o', 'k', 'p', GeomFromText('POINT(46 50)')),
  ('d', 'e', 'z', GeomFromText('POINT(30 198)')),
  ('r', 'r', 'l', GeomFromText('POINT(78 189)')),
  ('y', 'l', 'f', GeomFromText('POINT(188 132)')),
  ('d', 'q', 'm', GeomFromText('POINT(247 107)')),
  ('p', 'j', 'n', GeomFromText('POINT(148 227)')),
  ('b', 'o', 'i', GeomFromText('POINT(172 25)')),
  ('e', 'v', 'd', GeomFromText('POINT(94 248)')),
  ('q', 'd', 'f', GeomFromText('POINT(15 29)')),
  ('w', 'b', 'b', GeomFromText('POINT(74 111)')),
  ('g', 'q', 'f', GeomFromText('POINT(107 215)')),
  ('o', 'h', 'r', GeomFromText('POINT(25 168)')),
  ('u', 't', 'w', GeomFromText('POINT(251 188)')),
  ('h', 's', 'w', GeomFromText('POINT(254 247)')),
  ('f', 'f', 'b', GeomFromText('POINT(166 103)'));
SET @@RAND_SEED1=866613816, @@RAND_SEED2=92289615;
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
  ('l', 'c', 'l', GeomFromText('POINT(202 98)')),
  ('k', 'c', 'b', GeomFromText('POINT(46 206)')),
  ('r', 'y', 'm', GeomFromText('POINT(74 140)')),
  ('y', 'z', 'd', GeomFromText('POINT(200 160)')),
  ('s', 'y', 's', GeomFromText('POINT(156 205)')),
  ('u', 'v', 'p', GeomFromText('POINT(86 82)')),
  ('j', 's', 's', GeomFromText('POINT(91 233)')),
  ('x', 'j', 'f', GeomFromText('POINT(3 14)')),
  ('l', 'z', 'v', GeomFromText('POINT(123 156)')),
  ('h', 'i', 'o', GeomFromText('POINT(145 229)')),
  ('o', 'r', 'd', GeomFromText('POINT(15 22)')),
  ('f', 'x', 't', GeomFromText('POINT(21 60)')),
  ('t', 'g', 'h', GeomFromText('POINT(50 153)')),
  ('g', 'u', 'b', GeomFromText('POINT(82 85)')),
  ('v', 'a', 'p', GeomFromText('POINT(231 178)')),
  ('n', 'v', 'o', GeomFromText('POINT(183 25)')),
  ('j', 'n', 'm', GeomFromText('POINT(50 144)')),
  ('e', 'f', 'i', GeomFromText('POINT(46 16)')),
  ('d', 'w', 'a', GeomFromText('POINT(66 6)')),
  ('f', 'x', 'a', GeomFromText('POINT(107 197)')),
  ('m', 'o', 'a', GeomFromText('POINT(142 80)')),
  ('q', 'l', 'g', GeomFromText('POINT(251 23)')),
  ('c', 's', 's', GeomFromText('POINT(158 43)')),
  ('y', 'd', 'o', GeomFromText('POINT(196 228)')),
  ('d', 'p', 'l', GeomFromText('POINT(107 5)')),
  ('h', 'a', 'b', GeomFromText('POINT(183 166)')),
  ('m', 'w', 'p', GeomFromText('POINT(19 59)')),
  ('b', 'y', 'o', GeomFromText('POINT(178 30)')),
  ('x', 'w', 'i', GeomFromText('POINT(168 94)')),
  ('t', 'k', 'z', GeomFromText('POINT(171 5)')),
  ('r', 'm', 'a', GeomFromText('POINT(222 19)')),
  ('u', 'v', 'e', GeomFromText('POINT(224 80)')),
  ('q', 'r', 'k', GeomFromText('POINT(212 218)')),
  ('d', 'p', 'j', GeomFromText('POINT(169 7)')),
  ('d', 'r', 'v', GeomFromText('POINT(193 23)')),
  ('n', 'y', 'y', GeomFromText('POINT(130 178)')),
  ('m', 'z', 'r', GeomFromText('POINT(81 200)')),
  ('j', 'e', 'w', GeomFromText('POINT(145 239)')),
  ('v', 'h', 'x', GeomFromText('POINT(24 105)')),
  ('z', 'm', 'a', GeomFromText('POINT(175 129)')),
  ('b', 'c', 'v', GeomFromText('POINT(213 10)')),
  ('t', 't', 'u', GeomFromText('POINT(2 129)')),
  ('r', 's', 'v', GeomFromText('POINT(209 192)')),
  ('x', 'p', 'g', GeomFromText('POINT(43 63)')),
  ('t', 'e', 'u', GeomFromText('POINT(139 210)')),
  ('l', 'e', 't', GeomFromText('POINT(245 148)')),
  ('a', 'i', 'k', GeomFromText('POINT(167 195)')),
  ('m', 'o', 'h', GeomFromText('POINT(206 120)')),
  ('g', 'z', 's', GeomFromText('POINT(169 240)')),
  ('z', 'u', 's', GeomFromText('POINT(202 120)')),
  ('i', 'b', 'a', GeomFromText('POINT(216 18)')),
  ('w', 'y', 'g', GeomFromText('POINT(119 236)')),
  ('h', 'y', 'p', GeomFromText('POINT(161 24)'));
UPDATE t1 set spatial_point=GeomFromText('POINT(33 100)') where  c1 like 't%';
UPDATE t1 set spatial_point=GeomFromText('POINT(41 46)') where  c1 like 'f%';
CHECK TABLE t1 EXTENDED;
DROP TABLE t1;

# End of 4.1 tests

#
# bug #21790 (UNKNOWN ERROR on NULLs in RTree)
#
CREATE TABLE t1(foo GEOMETRY NOT NULL, SPATIAL INDEX(foo) );
--error 1048
INSERT INTO t1(foo) VALUES (NULL);
--error 1416
INSERT INTO t1() VALUES ();
--error 1416
INSERT INTO t1(foo) VALUES ('');
DROP TABLE t1;

#
# Bug #23578: Corruption prevents Optimize table from working properly with a 
#             spatial index
#

CREATE TABLE t1 (a INT AUTO_INCREMENT, b POINT NOT NULL, KEY (a), SPATIAL KEY (b));

INSERT INTO t1 (b) VALUES (GeomFromText('POINT(1 2)'));
INSERT INTO t1 (b) SELECT b FROM t1;
INSERT INTO t1 (b) SELECT b FROM t1;
INSERT INTO t1 (b) SELECT b FROM t1;
INSERT INTO t1 (b) SELECT b FROM t1;
INSERT INTO t1 (b) SELECT b FROM t1;

OPTIMIZE TABLE t1;
DROP TABLE t1;


#
# Bug #29070: Error in spatial index
#

CREATE TABLE t1 (a INT, b GEOMETRY NOT NULL, SPATIAL KEY b(b));
INSERT INTO t1 VALUES (1, GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)'));
INSERT INTO t1 VALUES (2, GEOMFROMTEXT('LINESTRING(1102218.456 1,2000000 2)'));

# must return the same number as the next select
SELECT COUNT(*) FROM t1 WHERE
  MBRINTERSECTS(b, GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') );
SELECT COUNT(*) FROM t1 IGNORE INDEX (b) WHERE
  MBRINTERSECTS(b, GEOMFROMTEXT('LINESTRING(1 1,1102219 2)') );

DROP TABLE t1;

--echo End of 5.0 tests.