null+****@clear*****
null+****@clear*****
2011年 9月 1日 (木) 17:35:24 JST
Kouhei Sutou 2011-09-01 08:35:24 +0000 (Thu, 01 Sep 2011)
New Revision: 9ccbff26fb7c3f0c2fc29ef997ae92bcf2e9b5d0
Log:
[test][wrapper][drop-index] add a test recreate index but not work...
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 (+9 -0)
===================================================================
--- test/sql/groonga_wrapper/r/fulltext_drop_index.result 2011-09-01 08:10:20 +0000 (6a5025b)
+++ test/sql/groonga_wrapper/r/fulltext_drop_index.result 2011-09-01 08:35:24 +0000 (a4f7378)
@@ -25,6 +25,15 @@ id title content
3 富士山 今日もきれい。
drop index title on diaries;
select * from diaries where match(title) against("富士山");
+ERROR HY000: Can't find FULLTEXT index matching the column list
+select * from diaries;
+id title content
+1 Hello はじめました。
+2 天気 明日の富士山の天気について
+3 富士山 今日もきれい。
+id title content
+create index new_title_index on diaries (title);
+select * from diaries where match(title) against("富士山");
id title content
select * from diaries;
id title content
Modified: test/sql/groonga_wrapper/t/fulltext_drop_index.test (+4 -0)
===================================================================
--- test/sql/groonga_wrapper/t/fulltext_drop_index.test 2011-09-01 08:10:20 +0000 (b2e72ba)
+++ test/sql/groonga_wrapper/t/fulltext_drop_index.test 2011-09-01 08:35:24 +0000 (e57445d)
@@ -33,6 +33,10 @@ insert into diaries values(2, "天気", "明日の富士山の天気について
insert into diaries values(3, "富士山", "今日もきれい。");
select * from diaries where match(title) against("富士山");
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);
select * from diaries where match(title) against("富士山");
select * from diaries;
drop table diaries;