[Groonga-mysql-commit] mroonga/mroonga [master] test: add ORDER BY to make resultset stable

Back to archive index

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 



More information about the Groonga-mysql-commit mailing list
Back to archive index