null+****@clear*****
null+****@clear*****
2011年 9月 1日 (木) 17:54:23 JST
Kouhei Sutou 2011-09-01 08:54:23 +0000 (Thu, 01 Sep 2011)
New Revision: 4f2ce55327c179b2f68ac27a28cc8fd8f3cf05cc
Log:
[test][wrapper][drop-index] add missing 'fulltext'.
Modified files:
test/sql/groonga_wrapper/r/fulltext_drop_index.result
test/sql/groonga_wrapper/t/fulltext_drop_index.test
Modified: test/sql/groonga_wrapper/r/fulltext_drop_index.result (+3 -5)
===================================================================
--- test/sql/groonga_wrapper/r/fulltext_drop_index.result 2011-09-01 08:35:24 +0000 (a4f7378)
+++ test/sql/groonga_wrapper/r/fulltext_drop_index.result 2011-09-01 08:54:23 +0000 (ce2389b)
@@ -4,9 +4,7 @@ create table diaries (
id int primary key,
title varchar(255),
content text,
-fulltext index (title, content),
-fulltext index (title),
-fulltext index (content)
+fulltext index (title)
) default charset utf8 COMMENT = 'engine "innodb"';
show create table diaries;
Table Create Table
@@ -31,10 +29,10 @@ id title content
1 Hello はじめました。
2 天気 明日の富士山の天気について
3 富士山 今日もきれい。
-id title content
-create index new_title_index on diaries (title);
+create fulltext index new_title_index on diaries (title);
select * from diaries where match(title) against("富士山");
id title content
+3 富士山 今日もきれい。
select * from diaries;
id title content
1 Hello はじめました。
Modified: test/sql/groonga_wrapper/t/fulltext_drop_index.test (+1 -1)
===================================================================
--- test/sql/groonga_wrapper/t/fulltext_drop_index.test 2011-09-01 08:35:24 +0000 (e57445d)
+++ test/sql/groonga_wrapper/t/fulltext_drop_index.test 2011-09-01 08:54:23 +0000 (8f57188)
@@ -36,7 +36,7 @@ drop index title on diaries;
--error 1191
select * from diaries where match(title) against("富士山");
select * from diaries;
-create index new_title_index on diaries (title);
+create fulltext index new_title_index on diaries (title);
select * from diaries where match(title) against("富士山");
select * from diaries;
drop table diaries;