Kouhei Sutou
null+****@clear*****
Tue Oct 23 22:56:34 JST 2012
Kouhei Sutou 2012-10-23 22:56:34 +0900 (Tue, 23 Oct 2012) New Revision: ca3c36a6707bb677e741553038249b23af426e54 https://github.com/mroonga/mroonga/commit/ca3c36a6707bb677e741553038249b23af426e54 Log: test: add ORDER BY to make resultset stable Modified files: test/sql/suite/mroonga/storage/alter_table/r/spatial.result test/sql/suite/mroonga/storage/alter_table/t/spatial.test Modified: test/sql/suite/mroonga/storage/alter_table/r/spatial.result (+2 -1) =================================================================== --- test/sql/suite/mroonga/storage/alter_table/r/spatial.result 2012-10-23 22:52:12 +0900 (fedfcb1) +++ test/sql/suite/mroonga/storage/alter_table/r/spatial.result 2012-10-23 22:56:34 +0900 (f9675cb) @@ -114,7 +114,8 @@ VALUES ('hiiragi', GeomFromText('POINT(139.711517 35.647701)')); ALTER TABLE shops ADD SPATIAL KEY location_index (location); SELECT id, name, AsText(location) AS location_text FROM shops -WHERE MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location); +WHERE MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) +ORDER BY id; id name location_text 14 tetsuji POINT(139.76857 35.680911944444446) 19 daruma POINT(139.7705988888889 35.68146111111111) Modified: test/sql/suite/mroonga/storage/alter_table/t/spatial.test (+2 -1) =================================================================== --- test/sql/suite/mroonga/storage/alter_table/t/spatial.test 2012-10-23 22:52:12 +0900 (7769a80) +++ test/sql/suite/mroonga/storage/alter_table/t/spatial.test 2012-10-23 22:56:34 +0900 (ca07361) @@ -140,7 +140,8 @@ INSERT INTO shops (name, location) ALTER TABLE shops ADD SPATIAL KEY location_index (location); SELECT id, name, AsText(location) AS location_text FROM shops - WHERE MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location); + WHERE MBRContains(GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) + ORDER BY id; SHOW CREATE TABLE shops; -------------- next part -------------- HTML����������������������������...Download