null+****@clear*****
null+****@clear*****
2011年 9月 28日 (水) 17:53:04 JST
Kouhei Sutou 2011-09-28 08:53:04 +0000 (Wed, 28 Sep 2011)
New Revision: d2651bbce02c89a4ed3a4b3b1f713700c280fff9
Log:
[test][storage] split unique hash index'ed _id value update test.
Copied files:
test/sql/groonga_storage/r/update_id_unique_hash_index.result
(from test/sql/groonga_storage/r/update.result)
test/sql/groonga_storage/t/update_id_unique_hash_index.test
(from test/sql/groonga_storage/t/update.test)
Modified files:
test/sql/groonga_storage/r/update.result
test/sql/groonga_storage/t/update.test
Modified: test/sql/groonga_storage/r/update.result (+0 -19)
===================================================================
--- test/sql/groonga_storage/r/update.result 2011-09-28 08:50:56 +0000 (74864c4)
+++ test/sql/groonga_storage/r/update.result 2011-09-28 08:53:04 +0000 (35d8843)
@@ -1,23 +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
-update t1 set c1 = 200 where _id = 2;
-select * from t1;
-_id c1
-1 100
-2 200
-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);
Copied: test/sql/groonga_storage/r/update_id_unique_hash_index.result (+0 -19) 52%
===================================================================
--- test/sql/groonga_storage/r/update.result 2011-09-28 08:50:56 +0000 (74864c4)
+++ test/sql/groonga_storage/r/update_id_unique_hash_index.result 2011-09-28 08:53:04 +0000 (dba9c96)
@@ -18,22 +18,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
-update t1 set c1 = 200 where _id = 2;
-select * from t1;
-_id c1
-1 100
-2 200
-3 100
-4 100
-drop table t1;
Modified: test/sql/groonga_storage/t/update.test (+0 -11)
===================================================================
--- test/sql/groonga_storage/t/update.test 2011-09-28 08:50:56 +0000 (960b20d)
+++ test/sql/groonga_storage/t/update.test 2011-09-28 08:53:04 +0000 (1062c3f)
@@ -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;
-update t1 set c1 = 200 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);
Copied: test/sql/groonga_storage/t/update_id_unique_hash_index.test (+0 -11) 80%
===================================================================
--- test/sql/groonga_storage/t/update.test 2011-09-28 08:50:56 +0000 (960b20d)
+++ test/sql/groonga_storage/t/update_id_unique_hash_index.test 2011-09-28 08:53:04 +0000 (b9ffb59)
@@ -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;
update t1 set c1 = 200 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;
-update t1 set c1 = 200 where _id = 2;
-select * from t1;
-drop table t1;
--source suite/groonga_include/groonga_deinit.inc