Kouhei Sutou
null+****@clear*****
Tue Nov 20 17:03:28 JST 2012
Kouhei Sutou 2012-11-20 17:03:28 +0900 (Tue, 20 Nov 2012) New Revision: 87ed9896cf80fdd1840f410a0e2b00479e1d10e5 https://github.com/mroonga/mroonga/commit/87ed9896cf80fdd1840f410a0e2b00479e1d10e5 Log: test: add a space before "(" Modified files: test/sql/suite/mroonga/wrapper/fulltext/r/index_recreate.result test/sql/suite/mroonga/wrapper/fulltext/t/index_recreate.test Modified: test/sql/suite/mroonga/wrapper/fulltext/r/index_recreate.result (+6 -6) =================================================================== --- test/sql/suite/mroonga/wrapper/fulltext/r/index_recreate.result 2012-11-20 17:02:35 +0900 (ef8d761) +++ test/sql/suite/mroonga/wrapper/fulltext/r/index_recreate.result 2012-11-20 17:03:28 +0900 (4d4fa26) @@ -15,14 +15,14 @@ diaries CREATE TABLE `diaries` ( PRIMARY KEY (`id`), FULLTEXT KEY `title` (`title`) ) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"' -INSERT INTO diaries VALUES(1, "Hello", "はじめました。"); -INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について"); -INSERT INTO diaries VALUES(3, "富士山", "今日もきれい。"); -SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山"); +INSERT INTO diaries VALUES (1, "Hello", "はじめました。"); +INSERT INTO diaries VALUES (2, "天気", "明日の富士山の天気について"); +INSERT INTO diaries VALUES (3, "富士山", "今日もきれい。"); +SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山"); id title content 3 富士山 今日もきれい。 DROP INDEX title ON diaries; -SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山"); +SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山"); ERROR HY000: Can't find FULLTEXT index matching the column list SELECT * FROM diaries; id title content @@ -30,7 +30,7 @@ id title content 2 天気 明日の富士山の天気について 3 富士山 今日もきれい。 CREATE FULLTEXT INDEX new_title_index ON diaries (title); -SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山"); +SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山"); id title content 3 富士山 今日もきれい。 SELECT * FROM diaries; Modified: test/sql/suite/mroonga/wrapper/fulltext/t/index_recreate.test (+6 -6) =================================================================== --- test/sql/suite/mroonga/wrapper/fulltext/t/index_recreate.test 2012-11-20 17:02:35 +0900 (3c8b8f2) +++ test/sql/suite/mroonga/wrapper/fulltext/t/index_recreate.test 2012-11-20 17:03:28 +0900 (70ee281) @@ -30,20 +30,20 @@ CREATE TABLE diaries ( ) DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"'; SHOW CREATE TABLE diaries; -INSERT INTO diaries VALUES(1, "Hello", "はじめました。"); -INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について"); -INSERT INTO diaries VALUES(3, "富士山", "今日もきれい。"); +INSERT INTO diaries VALUES (1, "Hello", "はじめました。"); +INSERT INTO diaries VALUES (2, "天気", "明日の富士山の天気について"); +INSERT INTO diaries VALUES (3, "富士山", "今日もきれい。"); -SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山"); +SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山"); DROP INDEX title ON diaries; --error ER_FT_MATCHING_KEY_NOT_FOUND -SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山"); +SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山"); SELECT * FROM diaries; CREATE FULLTEXT INDEX new_title_index ON diaries (title); -SELECT * FROM diaries WHERE MATCH(title) AGAINST("富士山"); +SELECT * FROM diaries WHERE MATCH (title) AGAINST ("富士山"); SELECT * FROM diaries; DROP TABLE diaries; -------------- next part -------------- HTML����������������������������...Download