diff options
| author | holyfoot/hf@mysql.com/deer.(none) <> | 2006-09-29 17:57:16 +0500 |
|---|---|---|
| committer | holyfoot/hf@mysql.com/deer.(none) <> | 2006-09-29 17:57:16 +0500 |
| commit | 348e3570ce0aa0252247f971683fa5d25e606865 (patch) | |
| tree | 390cac59044c1e4ae0fd58ccc2d1221426147e4f /mysql-test/t/gis-rtree.test | |
| parent | 903387afc00fbc367aefbc32f973ea3b52d85fd9 (diff) | |
| parent | 8190b7231b14a4d8773730405edeb7fb07784650 (diff) | |
| download | mariadb-git-348e3570ce0aa0252247f971683fa5d25e606865.tar.gz | |
Merge mysql.com:/home/hf/work/21888/my41-21888
into mysql.com:/home/hf/work/21888/my50-21888
Diffstat (limited to 'mysql-test/t/gis-rtree.test')
| -rw-r--r-- | mysql-test/t/gis-rtree.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/gis-rtree.test b/mysql-test/t/gis-rtree.test index 163f2806ad2..09cdcb2435e 100644 --- a/mysql-test/t/gis-rtree.test +++ b/mysql-test/t/gis-rtree.test @@ -231,4 +231,14 @@ INSERT INTO t1 (c1) VALUES ( CHECK TABLE t1 EXTENDED; DROP TABLE t1; +# +# Bug #21888: Query on GEOMETRY field using PointFromWKB() results in lost connection +# +CREATE TABLE t1 (foo GEOMETRY NOT NULL, SPATIAL INDEX(foo) ); +INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(1,1))); +INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(1,0))); +INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(0,1))); +INSERT INTO t1 (foo) VALUES (PointFromWKB(POINT(0,0))); +SELECT 1 FROM t1 WHERE foo != PointFromWKB(POINT(0,0)); +DROP TABLE t1; # End of 4.1 tests |