diff options
| author | unknown <holyfoot/hf@mysql.com/deer.(none)> | 2006-10-01 19:04:08 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/deer.(none)> | 2006-10-01 19:04:08 +0500 |
| commit | 602343262f4d83ad587619e0cd6db92fa2b3c183 (patch) | |
| tree | 13ae127f22a5783757a4ddfb2f98e6c33948360e /mysql-test/r/gis-rtree.result | |
| parent | da9f990b5480645014f982fe5c2b1880ce54b314 (diff) | |
| parent | 01fe277cc6e0863ca03ab11d1f12bd9b52dc180e (diff) | |
| download | mariadb-git-602343262f4d83ad587619e0cd6db92fa2b3c183.tar.gz | |
Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-4.1-opt
into mysql.com:/home/hf/work/21888/my41-21888
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 3fcae8843c0..bdb3de4de75 100644 --- a/mysql-test/r/gis-rtree.result +++ b/mysql-test/r/gis-rtree.result @@ -857,3 +857,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; |