null+****@clear*****
null+****@clear*****
2011年 9月 23日 (金) 17:14:17 JST
Kouhei Sutou 2011-09-23 08:14:17 +0000 (Fri, 23 Sep 2011)
New Revision: e13c2e8bc32a758569f2d16f36e5fadfa5047869
Log:
[storage][test] split unique hash index test for _id.
Copied files:
test/sql/groonga_storage/r/hash_index_id_unique.result
(from test/sql/groonga_storage/r/hash.result)
test/sql/groonga_storage/t/hash_index_id_unique.test
(from test/sql/groonga_storage/t/hash.test)
Modified files:
test/sql/groonga_storage/r/hash.result
test/sql/groonga_storage/t/hash.test
Modified: test/sql/groonga_storage/r/hash.result (+0 -17)
===================================================================
--- test/sql/groonga_storage/r/hash.result 2011-09-23 08:08:09 +0000 (cbde2a9)
+++ test/sql/groonga_storage/r/hash.result 2011-09-23 08:14:17 +0000 (5f92c08)
@@ -1,21 +1,4 @@
drop table if exists t1, t2, t3;
-create table t1 (_id int, a 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 a
-1 100
-2 100
-3 100
-4 100
-select * from t1 where _id = 2;
-_id a
-2 100
-select * from t1 where _id = 20;
-_id a
-drop table t1;
create table t1 (_id int, a int, key (_id) using hash);
insert into t1 values(null, 100);
insert into t1 values(null, 100);
Copied: test/sql/groonga_storage/r/hash_index_id_unique.result (+0 -17) 52%
===================================================================
--- test/sql/groonga_storage/r/hash.result 2011-09-23 08:08:09 +0000 (cbde2a9)
+++ test/sql/groonga_storage/r/hash_index_id_unique.result 2011-09-23 08:14:17 +0000 (1a30a1e)
@@ -16,20 +16,3 @@ _id a
select * from t1 where _id = 20;
_id a
drop table t1;
-create table t1 (_id int, a 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 a
-1 100
-2 100
-3 100
-4 100
-select * from t1 where _id = 2;
-_id a
-2 100
-select * from t1 where _id = 20;
-_id a
-drop table t1;
Modified: test/sql/groonga_storage/t/hash.test (+0 -11)
===================================================================
--- test/sql/groonga_storage/t/hash.test 2011-09-23 08:08:09 +0000 (5a2bbe8)
+++ test/sql/groonga_storage/t/hash.test 2011-09-23 08:14:17 +0000 (541a15a)
@@ -20,17 +20,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-create table t1 (_id int, a 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;
-select * from t1 where _id = 2;
-select * from t1 where _id = 20;
-drop table t1;
-
-
create table t1 (_id int, a int, key (_id) using hash);
insert into t1 values(null, 100);
insert into t1 values(null, 100);
Copied: test/sql/groonga_storage/t/hash_index_id_unique.test (+0 -11) 80%
===================================================================
--- test/sql/groonga_storage/t/hash.test 2011-09-23 08:08:09 +0000 (5a2bbe8)
+++ test/sql/groonga_storage/t/hash_index_id_unique.test 2011-09-23 08:14:17 +0000 (0b1ff9e)
@@ -30,15 +30,4 @@ select * from t1 where _id = 2;
select * from t1 where _id = 20;
drop table t1;
-
-create table t1 (_id int, a 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;
-select * from t1 where _id = 2;
-select * from t1 where _id = 20;
-drop table t1;
-
--source suite/groonga_include/groonga_deinit.inc