null+****@clear*****
null+****@clear*****
2011年 9月 23日 (金) 14:31:08 JST
Kouhei Sutou 2011-09-23 05:31:08 +0000 (Fri, 23 Sep 2011)
New Revision: d2cbe2df5409272a7fec6adc9be6ac05814e0a0d
Log:
[storage][test] split tests for delete for normal column.
Added files:
test/sql/groonga_storage/r/delete_normal_column.result
Copied files:
test/sql/groonga_storage/t/delete_normal_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 -33)
===================================================================
--- test/sql/groonga_storage/r/delete.result 2011-09-22 10:44:51 +0000 (e3092d6)
+++ test/sql/groonga_storage/r/delete.result 2011-09-23 05:31:08 +0000 (9fca0db)
@@ -1,37 +1,4 @@
drop table if exists t1, t2, t3;
-create table t1 (c1 int, c2 int);
-show create table t1;
-Table Create Table
-t1 CREATE TABLE `t1` (
- `c1` int(11) DEFAULT NULL,
- `c2` int(11) DEFAULT NULL
-) ENGINE=groonga DEFAULT CHARSET=latin1
-insert into t1 values (1, 100);
-insert into t1 values (2, 101);
-insert into t1 values (3, 102);
-insert into t1 values (4, 102);
-select * from t1;
-c1 c2
-1 100
-2 101
-3 102
-4 102
-delete from t1 where c1=3;
-select * from t1;
-c1 c2
-1 100
-2 101
-4 102
-flush tables;
-delete from t1 where c1=2;
-select * from t1;
-c1 c2
-1 100
-4 102
-delete from t1;
-select * from t1;
-c1 c2
-drop table t1;
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");
Added: test/sql/groonga_storage/r/delete_normal_column.result (+34 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/groonga_storage/r/delete_normal_column.result 2011-09-23 05:31:08 +0000 (0c7a34f)
@@ -0,0 +1,34 @@
+drop table if exists t1, t2, t3;
+create table t1 (c1 int, c2 int);
+show create table t1;
+Table Create Table
+t1 CREATE TABLE `t1` (
+ `c1` int(11) DEFAULT NULL,
+ `c2` int(11) DEFAULT NULL
+) ENGINE=groonga DEFAULT CHARSET=latin1
+insert into t1 values (1, 100);
+insert into t1 values (2, 101);
+insert into t1 values (3, 102);
+insert into t1 values (4, 102);
+select * from t1;
+c1 c2
+1 100
+2 101
+3 102
+4 102
+delete from t1 where c1=3;
+select * from t1;
+c1 c2
+1 100
+2 101
+4 102
+flush tables;
+delete from t1 where c1=2;
+select * from t1;
+c1 c2
+1 100
+4 102
+delete from t1;
+select * from t1;
+c1 c2
+drop table t1;
Modified: test/sql/groonga_storage/t/delete.test (+0 -21)
===================================================================
--- test/sql/groonga_storage/t/delete.test 2011-09-22 10:44:51 +0000 (93a8d0a)
+++ test/sql/groonga_storage/t/delete.test 2011-09-23 05:31:08 +0000 (a01cb23)
@@ -20,27 +20,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-create table t1 (c1 int, c2 int);
-show create table t1;
-insert into t1 values (1, 100);
-insert into t1 values (2, 101);
-insert into t1 values (3, 102);
-insert into t1 values (4, 102);
-select * from t1;
-
-delete from t1 where c1=3;
-select * from t1;
-
-flush tables;
-
-delete from t1 where c1=2;
-select * from t1;
-
-delete from t1;
-select * from t1;
-
-drop table t1;
-
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");
Copied: test/sql/groonga_storage/t/delete_normal_column.test (+0 -34) 57%
===================================================================
--- test/sql/groonga_storage/t/delete.test 2011-09-22 10:44:51 +0000 (93a8d0a)
+++ test/sql/groonga_storage/t/delete_normal_column.test 2011-09-23 05:31:08 +0000 (39d0ad0)
@@ -41,38 +41,4 @@ select * from t1;
drop table t1;
-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);
-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