Kouhei Sutou
null+****@clear*****
Tue Oct 23 22:09:11 JST 2012
Kouhei Sutou 2012-10-23 22:09:11 +0900 (Tue, 23 Oct 2012) New Revision: 77846f650873c12b128cbb11dffb003c862c6bc7 https://github.com/mroonga/mroonga/commit/77846f650873c12b128cbb11dffb003c862c6bc7 Log: test: add ORDER BY to make resultset stable Modified files: test/sql/suite/mroonga/storage/geometry/r/contains.result test/sql/suite/mroonga/storage/geometry/t/contains.test Modified: test/sql/suite/mroonga/storage/geometry/r/contains.result (+2 -1) =================================================================== --- test/sql/suite/mroonga/storage/geometry/r/contains.result 2012-10-23 21:49:35 +0900 (8aa7bb6) +++ test/sql/suite/mroonga/storage/geometry/r/contains.result 2012-10-23 22:09:11 +0900 (8ee3a94) @@ -161,7 +161,8 @@ id name location_text 35 nishimi-ya POINT(139.77462805555555 35.671825) 36 hiiragi POINT(139.71151694444444 35.64770111111111) 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/geometry/t/contains.test (+2 -1) =================================================================== --- test/sql/suite/mroonga/storage/geometry/t/contains.test 2012-10-23 21:49:35 +0900 (47a5812) +++ test/sql/suite/mroonga/storage/geometry/t/contains.test 2012-10-23 22:09:11 +0900 (da0a617) @@ -138,7 +138,8 @@ insert into shops (name, location) GeomFromText('POINT(139.711517 35.647701)')); select id, name, AsText(location) as location_text from shops; 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; drop table shops; --source include/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Download