summaryrefslogtreecommitdiff
path: root/mysql-test/r/gis-rtree.result
diff options
context:
space:
mode:
authorunknown <holyfoot/hf@mysql.com/deer.(none)>2006-09-29 17:57:16 +0500
committerunknown <holyfoot/hf@mysql.com/deer.(none)>2006-09-29 17:57:16 +0500
commit55aa43fe35473f428c2de4ea883267f8655c4433 (patch)
tree390cac59044c1e4ae0fd58ccc2d1221426147e4f /mysql-test/r/gis-rtree.result
parentca5e29475c8ae52035214c710be04bcb1ed13177 (diff)
parent01fe277cc6e0863ca03ab11d1f12bd9b52dc180e (diff)
downloadmariadb-git-55aa43fe35473f428c2de4ea883267f8655c4433.tar.gz
Merge mysql.com:/home/hf/work/21888/my41-21888
into mysql.com:/home/hf/work/21888/my50-21888 myisam/mi_range.c: Auto merged mysql-test/r/gis-rtree.result: Auto merged mysql-test/t/gis-rtree.test: Auto merged
Diffstat (limited to 'mysql-test/r/gis-rtree.result')
-rw-r--r--mysql-test/r/gis-rtree.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/gis-rtree.result b/mysql-test/r/gis-rtree.result
index b283d64395d..e017a31f24b 100644
--- a/mysql-test/r/gis-rtree.result
+++ b/mysql-test/r/gis-rtree.result
@@ -862,3 +862,14 @@ CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
test.t1 check status OK
DROP TABLE t1;
+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));
+1
+1
+1
+1
+DROP TABLE t1;