Kouhei Sutou
null+****@clear*****
Sat May 16 18:43:18 JST 2015
Kouhei Sutou 2015-05-16 18:43:18 +0900 (Sat, 16 May 2015) New Revision: ecf9cab6e1fd66f052f218aadc8d7e9bd9799f62 https://github.com/mroonga/mroonga/commit/ecf9cab6e1fd66f052f218aadc8d7e9bd9799f62 Message: test: add ORDER BY to make result stable Modified files: mysql-test/mroonga/storage/replace/r/select_varchar.result mysql-test/mroonga/storage/replace/t/select_varchar.test Modified: mysql-test/mroonga/storage/replace/r/select_varchar.result (+2 -1) =================================================================== --- mysql-test/mroonga/storage/replace/r/select_varchar.result 2015-05-16 18:11:59 +0900 (9cbe11c) +++ mysql-test/mroonga/storage/replace/r/select_varchar.result 2015-05-16 18:43:18 +0900 (b9aebee) @@ -31,7 +31,8 @@ SELECT v.id, v.video_id, v.description, NULL FROM videos_master AS v WHERE v.video_id = (video_id); SELECT *, MATCH(description) AGAINST("my") FROM videos_groonga -WHERE MATCH(description) AGAINST("my"); +WHERE MATCH(description) AGAINST("my") +ORDER BY id; id video_id description tags_unpack MATCH(description) AGAINST("my") 1 video-1 My Familly 209716 2 video-2 My Cat 209716 Modified: mysql-test/mroonga/storage/replace/t/select_varchar.test (+2 -1) =================================================================== --- mysql-test/mroonga/storage/replace/t/select_varchar.test 2015-05-16 18:11:59 +0900 (a3403cc) +++ mysql-test/mroonga/storage/replace/t/select_varchar.test 2015-05-16 18:43:18 +0900 (68449e2) @@ -57,7 +57,8 @@ REPLACE INTO videos_groonga FROM videos_master AS v WHERE v.video_id = (video_id); SELECT *, MATCH(description) AGAINST("my") FROM videos_groonga - WHERE MATCH(description) AGAINST("my"); + WHERE MATCH(description) AGAINST("my") + ORDER BY id; DROP TABLE videos_master, videos_groonga; -------------- next part -------------- HTML����������������������������...Download