null+****@clear*****
null+****@clear*****
2010年 10月 18日 (月) 20:07:29 JST
Tetsuro IKEDA 2010-10-18 11:07:29 +0000 (Mon, 18 Oct 2010)
New Revision: db64eed5fb25fdf0a1e0fce8c387df881f951c87
Log:
fixed test case #444
Modified files:
test/sql/r/count_performance.result
test/sql/t/count_performance.test
Modified: test/sql/r/count_performance.result (+30 -30)
===================================================================
--- test/sql/r/count_performance.result 2010-10-18 10:05:03 +0000 (dd2fb64)
+++ test/sql/r/count_performance.result 2010-10-18 11:07:29 +0000 (66d0180)
@@ -7,9 +7,9 @@ insert into t1 values(2,20,"ka ki ku ke ko");
insert into t1 values(3,30,"sa si su se so");
insert into t1 values(4,40,"ta ti tu te to");
insert into t1 values(5,50,"aa ii uu ee oo");
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 0
+groonga_count_skip 0
select * from t1;
c1 c2 c3
1 10 aa ii uu ee oo
@@ -17,92 +17,92 @@ c1 c2 c3
3 30 sa si su se so
4 40 ta ti tu te to
5 50 aa ii uu ee oo
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 0
+groonga_count_skip 0
select count(*) from t1;
count(*)
5
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 0
+groonga_count_skip 0
select * from t1 force index(primary) where c1 between 2 and 4;
c1 c2 c3
2 20 ka ki ku ke ko
3 30 sa si su se so
4 40 ta ti tu te to
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 0
+groonga_count_skip 0
select count(*) from t1 force index(primary) where c1 between 2 and 4;
count(*)
3
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 1
+groonga_count_skip 1
select c1 from t1 force index(primary) where c1 < 3;
c1
1
2
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 1
+groonga_count_skip 1
select count(c1) from t1 force index(primary) where c1 < 3;
count(c1)
2
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 1
+groonga_count_skip 1
select 1 from t1 force index(primary) where c1 > 3;
1
1
1
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 1
+groonga_count_skip 1
select count(1) from t1 force index(primary) where c1 > 3;
count(1)
2
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 2
+groonga_count_skip 2
select * from t1 where match(c3) against("su");
c1 c2 c3
3 30 sa si su se so
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 2
+groonga_count_skip 2
select count(*) from t1 where match(c3) against("su");
count(*)
1
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 3
+groonga_count_skip 3
select * from t1 where match(c3) against("+su" in boolean mode);
c1 c2 c3
3 30 sa si su se so
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 3
+groonga_count_skip 3
select count(*) from t1 where match(c3) against("+su" in boolean mode);
count(*)
1
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 4
+groonga_count_skip 4
select * from t1 force index(idx1) where c2 between 20 and 40;
c1 c2 c3
2 20 ka ki ku ke ko
3 30 sa si su se so
4 40 ta ti tu te to
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 4
+groonga_count_skip 4
select count(*) from t1 force index(idx1) where c2 between 20 and 40;
count(*)
3
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
Variable_name Value
-grn_count_skip 5
+groonga_count_skip 5
drop table t1;
uninstall plugin groonga;
Modified: test/sql/t/count_performance.test (+15 -15)
===================================================================
--- test/sql/t/count_performance.test 2010-10-18 10:05:03 +0000 (b7ce61a)
+++ test/sql/t/count_performance.test 2010-10-18 11:07:29 +0000 (91ef829)
@@ -26,35 +26,35 @@ insert into t1 values(2,20,"ka ki ku ke ko");
insert into t1 values(3,30,"sa si su se so");
insert into t1 values(4,40,"ta ti tu te to");
insert into t1 values(5,50,"aa ii uu ee oo");
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select * from t1;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(*) from t1;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select * from t1 force index(primary) where c1 between 2 and 4;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(*) from t1 force index(primary) where c1 between 2 and 4;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select c1 from t1 force index(primary) where c1 < 3;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(c1) from t1 force index(primary) where c1 < 3;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select 1 from t1 force index(primary) where c1 > 3;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(1) from t1 force index(primary) where c1 > 3;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select * from t1 where match(c3) against("su");
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(*) from t1 where match(c3) against("su");
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select * from t1 where match(c3) against("+su" in boolean mode);
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(*) from t1 where match(c3) against("+su" in boolean mode);
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select * from t1 force index(idx1) where c2 between 20 and 40;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
select count(*) from t1 force index(idx1) where c2 between 20 and 40;
-show status like 'grn_count_skip';
+show status like 'groonga_count_skip';
drop table t1;
--disable_warnings