diff options
author | unknown <holyfoot/hf@mysql.com/deer.(none)> | 2006-09-29 17:57:16 +0500 |
---|---|---|
committer | unknown <holyfoot/hf@mysql.com/deer.(none)> | 2006-09-29 17:57:16 +0500 |
commit | 55aa43fe35473f428c2de4ea883267f8655c4433 (patch) | |
tree | 390cac59044c1e4ae0fd58ccc2d1221426147e4f /mysql-test/r/gis-rtree.result | |
parent | ca5e29475c8ae52035214c710be04bcb1ed13177 (diff) | |
parent | 01fe277cc6e0863ca03ab11d1f12bd9b52dc180e (diff) | |
download | mariadb-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.result | 11 |
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; |