Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:32:24 JST 2012
Kouhei Sutou 2011-11-24 15:23:11 +0900 (Thu, 24 Nov 2011) New Revision: cf8fb14c3cf1824be7d06565b225545426faed59 https://github.com/mroonga/mroonga/commit/cf8fb14c3cf1824be7d06565b225545426faed59 Log: [test] add an expected result for full text search with no such key. refs #1181. Added files: test/sql/suite/groonga_storage/r/fulltext_no_such_key.result Added: test/sql/suite/groonga_storage/r/fulltext_no_such_key.result (+25 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/groonga_storage/r/fulltext_no_such_key.result 2011-11-24 15:23:11 +0900 (aff4291) @@ -0,0 +1,25 @@ +DROP TABLE IF EXISTS diaries; +CREATE TABLE diaries ( +id INT PRIMARY KEY AUTO_INCREMENT, +title TEXT, +body TEXT, +FULLTEXT INDEX title_index (title), +FULLTEXT INDEX body_index (body) +) DEFAULT CHARSET UTF8; +SHOW CREATE TABLE diaries; +Table Create Table +diaries CREATE TABLE `diaries` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text, + `body` text, + PRIMARY KEY (`id`), + FULLTEXT KEY `title_index` (`title`), + FULLTEXT KEY `body_index` (`body`) +) ENGINE=groonga DEFAULT CHARSET=utf8 +INSERT INTO diaries (title, body) VALUES ("survey", "will start groonga!"); +INSERT INTO diaries (title, body) VALUES ("groonga (1)", "starting groonga..."); +INSERT INTO diaries (title, body) VALUES ("groonga (2)", "started groonga."); +SELECT * FROM diaries FORCE INDEX(primary) +WHERE MATCH(title) AGAINST("survey" IN BOOLEAN MODE); +id title body +DROP TABLE diaries; -------------- next part -------------- HTML����������������������������...Download