null+****@clear*****
null+****@clear*****
2011年 9月 23日 (金) 14:34:41 JST
Kouhei Sutou 2011-09-23 05:34:41 +0000 (Fri, 23 Sep 2011)
New Revision: 364df51598f4bd1531f1694b2714bc99b6a4ad9c
Log:
[storage][test] split tests for delete for fulltext column.
Added files:
test/sql/groonga_storage/r/delete_fulltext_column.result
Copied files:
test/sql/groonga_storage/t/delete_fulltext_column.test
(from test/sql/groonga_storage/t/delete.test)
Modified files:
test/sql/groonga_storage/r/delete.result
test/sql/groonga_storage/t/delete.test
Modified: test/sql/groonga_storage/r/delete.result (+0 -20)
===================================================================
--- test/sql/groonga_storage/r/delete.result 2011-09-23 05:31:08 +0000 (9fca0db)
+++ test/sql/groonga_storage/r/delete.result 2011-09-23 05:34:41 +0000 (19fc4e7)
@@ -1,24 +1,4 @@
drop table if exists t1, t2, t3;
-create table t1 (c1 int primary key, c2 text, fulltext index (c2));
-insert into t1 values(10, "aa ii uu ee");
-insert into t1 values(20, "ka ki ku ke");
-insert into t1 values(30, "sa si su se");
-select * from t1;
-c1 c2
-10 aa ii uu ee
-20 ka ki ku ke
-30 sa si su se
-select * from t1 where match(c2) against("ki");
-c1 c2
-20 ka ki ku ke
-delete from t1 where c1=20;
-select * from t1;
-c1 c2
-10 aa ii uu ee
-30 sa si su se
-select * from t1 where match(c2) against("ki");
-c1 c2
-drop table t1;
create table t1 (_id int, c1 int, unique key (_id) using hash);
insert into t1 values(null, 100);
insert into t1 values(null, 100);
Added: test/sql/groonga_storage/r/delete_fulltext_column.result (+21 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/groonga_storage/r/delete_fulltext_column.result 2011-09-23 05:34:41 +0000 (5fb5229)
@@ -0,0 +1,21 @@
+drop table if exists t1, t2, t3;
+create table t1 (c1 int primary key, c2 text, fulltext index (c2));
+insert into t1 values(10, "aa ii uu ee");
+insert into t1 values(20, "ka ki ku ke");
+insert into t1 values(30, "sa si su se");
+select * from t1;
+c1 c2
+10 aa ii uu ee
+20 ka ki ku ke
+30 sa si su se
+select * from t1 where match(c2) against("ki");
+c1 c2
+20 ka ki ku ke
+delete from t1 where c1=20;
+select * from t1;
+c1 c2
+10 aa ii uu ee
+30 sa si su se
+select * from t1 where match(c2) against("ki");
+c1 c2
+drop table t1;
Modified: test/sql/groonga_storage/t/delete.test (+0 -13)
===================================================================
--- test/sql/groonga_storage/t/delete.test 2011-09-23 05:31:08 +0000 (a01cb23)
+++ test/sql/groonga_storage/t/delete.test 2011-09-23 05:34:41 +0000 (77e3781)
@@ -20,19 +20,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-create table t1 (c1 int primary key, c2 text, fulltext index (c2));
-insert into t1 values(10, "aa ii uu ee");
-insert into t1 values(20, "ka ki ku ke");
-insert into t1 values(30, "sa si su se");
-
-select * from t1;
-select * from t1 where match(c2) against("ki");
-delete from t1 where c1=20;
-select * from t1;
-select * from t1 where match(c2) against("ki");
-
-drop table t1;
-
# _id and hash index
create table t1 (_id int, c1 int, unique key (_id) using hash);
insert into t1 values(null, 100);
Copied: test/sql/groonga_storage/t/delete_fulltext_column.test (+0 -21) 69%
===================================================================
--- test/sql/groonga_storage/t/delete.test 2011-09-23 05:31:08 +0000 (a01cb23)
+++ test/sql/groonga_storage/t/delete_fulltext_column.test 2011-09-23 05:34:41 +0000 (4323741)
@@ -33,25 +33,4 @@ select * from t1 where match(c2) against("ki");
drop table t1;
-# _id and hash index
-create table t1 (_id int, c1 int, unique key (_id) using hash);
-insert into t1 values(null, 100);
-insert into t1 values(null, 100);
-insert into t1 values(null, 100);
-insert into t1 values(null, 100);
-select * from t1;
-delete from t1 where _id = 2;
-select * from t1;
-drop table t1;
-
-create table t1 (_id int, c1 int, key (_id) using hash);
-insert into t1 values(null, 100);
-insert into t1 values(null, 100);
-insert into t1 values(null, 100);
-insert into t1 values(null, 100);
-select * from t1;
-delete from t1 where _id = 2;
-select * from t1;
-drop table t1;
-
--source suite/groonga_include/groonga_deinit.inc