null+****@clear*****
null+****@clear*****
2011年 9月 25日 (日) 09:38:44 JST
Kouhei Sutou 2011-09-25 00:38:44 +0000 (Sun, 25 Sep 2011)
New Revision: 7d216eaf10de73341908366d19be32dcb2d29af9
Log:
[wrapper][test] split fulltext not against match search.
Copied files:
test/sql/groonga_wrapper/r/fulltext_not_match_against.result
(from test/sql/groonga_wrapper/r/fulltext.result)
test/sql/groonga_wrapper/t/fulltext_not_match_against.test
(from test/sql/groonga_wrapper/t/fulltext.test)
Modified files:
test/sql/groonga_wrapper/r/fulltext.result
test/sql/groonga_wrapper/t/fulltext.test
Modified: test/sql/groonga_wrapper/r/fulltext.result (+0 -67)
===================================================================
--- test/sql/groonga_wrapper/r/fulltext.result 2011-09-25 00:36:31 +0000 (c0ffd4c)
+++ test/sql/groonga_wrapper/r/fulltext.result 2011-09-25 00:38:44 +0000 (8e01f78)
@@ -64,70 +64,3 @@ c1 c2 match(c2) against("ii")
3 aa ii ii ii oo 3
5 ta ti ii ii to 2
drop table t1,t2;
-create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3)) COMMENT = 'engine "innodb"';
-insert into t1 values(1,10,"aa ii uu ee oo");
-insert into t1 values(2,10,"ka ki ku ke ko");
-insert into t1 values(3,10,"aa ii uu ee oo");
-insert into t1 values(4,10,"ka ki ku ke ko");
-insert into t1 values(5,20,"aa ii uu ee oo");
-insert into t1 values(6,20,"ka ki ku ke ko");
-insert into t1 values(7,20,"aa ii uu ee oo");
-insert into t1 values(8,20,"ka ki ku ke ko");
-select * from t1;
-c1 c2 c3
-1 10 aa ii uu ee oo
-2 10 ka ki ku ke ko
-3 10 aa ii uu ee oo
-4 10 ka ki ku ke ko
-5 20 aa ii uu ee oo
-6 20 ka ki ku ke ko
-7 20 aa ii uu ee oo
-8 20 ka ki ku ke ko
-select *,match(c3) against("uu") from t1 where match(c3) against("uu");
-c1 c2 c3 match(c3) against("uu")
-1 10 aa ii uu ee oo 1
-3 10 aa ii uu ee oo 1
-5 20 aa ii uu ee oo 1
-7 20 aa ii uu ee oo 1
-select * from t1 where not match(c3) against("uu");
-c1 c2 c3
-2 10 ka ki ku ke ko
-4 10 ka ki ku ke ko
-6 20 ka ki ku ke ko
-8 20 ka ki ku ke ko
-select *,match(c3) against("dummy") from t1 where match(c3) against("dummy");
-c1 c2 c3 match(c3) against("dummy")
-select * from t1 where not match(c3) against("dummy");
-c1 c2 c3
-1 10 aa ii uu ee oo
-2 10 ka ki ku ke ko
-3 10 aa ii uu ee oo
-4 10 ka ki ku ke ko
-5 20 aa ii uu ee oo
-6 20 ka ki ku ke ko
-7 20 aa ii uu ee oo
-8 20 ka ki ku ke ko
-select * from t1 where c1 = 4 and not match(c3) against("uu");
-c1 c2 c3
-4 10 ka ki ku ke ko
-select * from t1 where c1 <= 4 and not match(c3) against("uu");
-c1 c2 c3
-2 10 ka ki ku ke ko
-4 10 ka ki ku ke ko
-select * from t1 where c1 > 4 and not match(c3) against("uu");
-c1 c2 c3
-6 20 ka ki ku ke ko
-8 20 ka ki ku ke ko
-select * from t1 where c2 = 10 and not match(c3) against("uu");
-c1 c2 c3
-2 10 ka ki ku ke ko
-4 10 ka ki ku ke ko
-select * from t1 where c2 >= 15 and not match(c3) against("uu");
-c1 c2 c3
-6 20 ka ki ku ke ko
-8 20 ka ki ku ke ko
-select * from t1 where c2 < 15 and not match(c3) against("uu");
-c1 c2 c3
-2 10 ka ki ku ke ko
-4 10 ka ki ku ke ko
-drop table t1;
Copied: test/sql/groonga_wrapper/r/fulltext_not_match_against.result (+0 -65) 51%
===================================================================
--- test/sql/groonga_wrapper/r/fulltext.result 2011-09-25 00:36:31 +0000 (c0ffd4c)
+++ test/sql/groonga_wrapper/r/fulltext_not_match_against.result 2011-09-25 00:38:44 +0000 (4b7ee5a)
@@ -1,69 +1,4 @@
drop table if exists t1, t2, t3;
-create table t1 (c1 int primary key, c2 varchar(100), fulltext index(c2)) default charset utf8 COMMENT = 'engine "innodb"';
-create table t2 (c1 int primary key, c2 text, fulltext index(c2)) default charset utf8 COMMENT = 'engine "innodb"';
-insert into t1 values (1, "aa ii uu ee oo");
-insert into t1 values (2, "ka ki ku ke ko");
-insert into t1 values (3, "aa ii ii ii oo");
-insert into t1 values (4, "sa si su se so");
-insert into t1 values (5, "ta ti ii ii to");
-insert into t2 (c1,c2) select c1,c2 from t1;
-select * from t1;
-c1 c2
-1 aa ii uu ee oo
-2 ka ki ku ke ko
-3 aa ii ii ii oo
-4 sa si su se so
-5 ta ti ii ii to
-select * from t2;
-c1 c2
-1 aa ii uu ee oo
-2 ka ki ku ke ko
-3 aa ii ii ii oo
-4 sa si su se so
-5 ta ti ii ii to
-select * from t1 where c1=3;
-c1 c2
-3 aa ii ii ii oo
-select * from t2 where c1=3;
-c1 c2
-3 aa ii ii ii oo
-select * from t1 where c1>3 order by c1 desc;
-c1 c2
-5 ta ti ii ii to
-4 sa si su se so
-select * from t2 where c1>3 order by c1 asc;
-c1 c2
-4 sa si su se so
-5 ta ti ii ii to
-select * from t1 where c2>"s" order by c2 desc;
-c1 c2
-5 ta ti ii ii to
-4 sa si su se so
-select * from t2 where c2>"s" order by c1 asc;
-c1 c2
-4 sa si su se so
-5 ta ti ii ii to
-select *,match(c2) against("ii") from t1 where match(c2) against("ii") order by match(c2) against("ii") desc;
-c1 c2 match(c2) against("ii")
-3 aa ii ii ii oo 3
-5 ta ti ii ii to 2
-1 aa ii uu ee oo 1
-select *,match(c2) against("ii") from t2 where match(c2) against("ii") order by match(c2) against("ii") asc;
-c1 c2 match(c2) against("ii")
-1 aa ii uu ee oo 1
-5 ta ti ii ii to 2
-3 aa ii ii ii oo 3
-select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");
-c1 c2 match(c2) against("ii")
-1 aa ii uu ee oo 1
-3 aa ii ii ii oo 3
-5 ta ti ii ii to 2
-select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");
-c1 c2 match(c2) against("ii")
-1 aa ii uu ee oo 1
-3 aa ii ii ii oo 3
-5 ta ti ii ii to 2
-drop table t1,t2;
create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3)) COMMENT = 'engine "innodb"';
insert into t1 values(1,10,"aa ii uu ee oo");
insert into t1 values(2,10,"ka ki ku ke ko");
Modified: test/sql/groonga_wrapper/t/fulltext.test (+0 -23)
===================================================================
--- test/sql/groonga_wrapper/t/fulltext.test 2011-09-25 00:36:31 +0000 (fc0a195)
+++ test/sql/groonga_wrapper/t/fulltext.test 2011-09-25 00:38:44 +0000 (ab72c09)
@@ -43,27 +43,4 @@ select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");
select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");
drop table t1,t2;
-# for "not match against"
-create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3)) COMMENT = 'engine "innodb"';
-insert into t1 values(1,10,"aa ii uu ee oo");
-insert into t1 values(2,10,"ka ki ku ke ko");
-insert into t1 values(3,10,"aa ii uu ee oo");
-insert into t1 values(4,10,"ka ki ku ke ko");
-insert into t1 values(5,20,"aa ii uu ee oo");
-insert into t1 values(6,20,"ka ki ku ke ko");
-insert into t1 values(7,20,"aa ii uu ee oo");
-insert into t1 values(8,20,"ka ki ku ke ko");
-select * from t1;
-select *,match(c3) against("uu") from t1 where match(c3) against("uu");
-select * from t1 where not match(c3) against("uu");
-select *,match(c3) against("dummy") from t1 where match(c3) against("dummy");
-select * from t1 where not match(c3) against("dummy");
-select * from t1 where c1 = 4 and not match(c3) against("uu");
-select * from t1 where c1 <= 4 and not match(c3) against("uu");
-select * from t1 where c1 > 4 and not match(c3) against("uu");
-select * from t1 where c2 = 10 and not match(c3) against("uu");
-select * from t1 where c2 >= 15 and not match(c3) against("uu");
-select * from t1 where c2 < 15 and not match(c3) against("uu");
-drop table t1;
-
--source suite/groonga_include/groonga_deinit.inc
Copied: test/sql/groonga_wrapper/t/fulltext_not_match_against.test (+0 -23) 63%
===================================================================
--- test/sql/groonga_wrapper/t/fulltext.test 2011-09-25 00:36:31 +0000 (fc0a195)
+++ test/sql/groonga_wrapper/t/fulltext_not_match_against.test 2011-09-25 00:38:44 +0000 (d0641e8)
@@ -21,29 +21,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-create table t1 (c1 int primary key, c2 varchar(100), fulltext index(c2)) default charset utf8 COMMENT = 'engine "innodb"';
-create table t2 (c1 int primary key, c2 text, fulltext index(c2)) default charset utf8 COMMENT = 'engine "innodb"';
-insert into t1 values (1, "aa ii uu ee oo");
-insert into t1 values (2, "ka ki ku ke ko");
-insert into t1 values (3, "aa ii ii ii oo");
-insert into t1 values (4, "sa si su se so");
-insert into t1 values (5, "ta ti ii ii to");
-insert into t2 (c1,c2) select c1,c2 from t1;
-select * from t1;
-select * from t2;
-select * from t1 where c1=3;
-select * from t2 where c1=3;
-select * from t1 where c1>3 order by c1 desc;
-select * from t2 where c1>3 order by c1 asc;
-select * from t1 where c2>"s" order by c2 desc;
-select * from t2 where c2>"s" order by c1 asc;
-select *,match(c2) against("ii") from t1 where match(c2) against("ii") order by match(c2) against("ii") desc;
-select *,match(c2) against("ii") from t2 where match(c2) against("ii") order by match(c2) against("ii") asc;
-select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");
-select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii");
-drop table t1,t2;
-
-# for "not match against"
create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3)) COMMENT = 'engine "innodb"';
insert into t1 values(1,10,"aa ii uu ee oo");
insert into t1 values(2,10,"ka ki ku ke ko");