diff options
| author | unknown <igor@olga.mysql.com> | 2007-07-13 19:05:30 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-07-13 19:05:30 -0700 |
| commit | 8c56d8e89ce04745e21a0aac8e2f7dd704b83a19 (patch) | |
| tree | 10fb10faaeac7b7677d02d00ed8eabf38fd6dc42 /mysql-test/t/gis-rtree.test | |
| parent | b15bd3086e6385f7d057d5db4766844734dcf30f (diff) | |
| parent | 85603b2e0b6b51c57de7019f451461e676c458de (diff) | |
| download | mariadb-git-8c56d8e89ce04745e21a0aac8e2f7dd704b83a19.tar.gz | |
Merge olga.mysql.com:/home/igor/mysql-5.0-rpl
into olga.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-merge
Diffstat (limited to 'mysql-test/t/gis-rtree.test')
| -rw-r--r-- | mysql-test/t/gis-rtree.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/gis-rtree.test b/mysql-test/t/gis-rtree.test index 3368aea9741..74b12caca41 100644 --- a/mysql-test/t/gis-rtree.test +++ b/mysql-test/t/gis-rtree.test @@ -827,3 +827,22 @@ 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. |