null+****@clear*****
null+****@clear*****
2011年 9月 23日 (金) 14:42:59 JST
Kouhei Sutou 2011-09-23 05:42:59 +0000 (Fri, 23 Sep 2011)
New Revision: 28bb8fdebaa56bdead9bf4756d5ccf5aa6c9b433
Log:
[storage][test] split tests for delete for _id column.
Copied files:
test/sql/groonga_storage/r/delete_id_index_hash_no_unique.result
(from test/sql/groonga_storage/r/delete.result)
test/sql/groonga_storage/t/delete_id_index_hash_no_unique.test
(from test/sql/groonga_storage/t/delete.test)
Renamed files:
test/sql/groonga_storage/r/delete_id_index_hash_unique.result
(from test/sql/groonga_storage/r/delete.result)
test/sql/groonga_storage/t/delete_id_index_hash_unique.test
(from test/sql/groonga_storage/t/delete.test)
Copied: test/sql/groonga_storage/r/delete_id_index_hash_no_unique.result (+0 -18) 51%
===================================================================
--- test/sql/groonga_storage/r/delete.result 2011-09-23 05:34:41 +0000 (19fc4e7)
+++ test/sql/groonga_storage/r/delete_id_index_hash_no_unique.result 2011-09-23 05:42:59 +0000 (76a4ed8)
@@ -1,22 +1,4 @@
drop table if exists t1, t2, t3;
-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;
-_id c1
-1 100
-2 100
-3 100
-4 100
-delete from t1 where _id = 2;
-select * from t1;
-_id c1
-1 100
-3 100
-4 100
-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);
Renamed: test/sql/groonga_storage/r/delete_id_index_hash_unique.result (+0 -18) 52%
===================================================================
--- test/sql/groonga_storage/r/delete.result 2011-09-23 05:34:41 +0000 (19fc4e7)
+++ test/sql/groonga_storage/r/delete_id_index_hash_unique.result 2011-09-23 05:42:59 +0000 (6307c55)
@@ -17,21 +17,3 @@ _id c1
3 100
4 100
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;
-_id c1
-1 100
-2 100
-3 100
-4 100
-delete from t1 where _id = 2;
-select * from t1;
-_id c1
-1 100
-3 100
-4 100
-drop table t1;
Copied: test/sql/groonga_storage/t/delete_id_index_hash_no_unique.test (+0 -11) 79%
===================================================================
--- test/sql/groonga_storage/t/delete.test 2011-09-23 05:34:41 +0000 (77e3781)
+++ test/sql/groonga_storage/t/delete_id_index_hash_no_unique.test 2011-09-23 05:42:59 +0000 (85a0b47)
@@ -20,17 +20,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-# _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);
Renamed: test/sql/groonga_storage/t/delete_id_index_hash_unique.test (+0 -11) 80%
===================================================================
--- test/sql/groonga_storage/t/delete.test 2011-09-23 05:34:41 +0000 (77e3781)
+++ test/sql/groonga_storage/t/delete_id_index_hash_unique.test 2011-09-23 05:42:59 +0000 (2ead433)
@@ -20,7 +20,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-# _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);
@@ -30,15 +29,5 @@ 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