null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 11:33:53 JST
Kouhei Sutou 2012-03-28 11:33:53 +0900 (Wed, 28 Mar 2012)
New Revision: 60524303c2006bef99a2201b5cfa2578edf6e247
Log:
test: use UPPERCASE for keywords
Modified files:
test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result
test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test
Modified: test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result (+18 -18)
===================================================================
--- test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:30:43 +0900 (43d99e9)
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:33:53 +0900 (046ad3b)
@@ -1,28 +1,28 @@
-drop table if exists t1, t2, t3;
-flush status;
-create table t1 (c1 int primary key, c2 int, c3 text, key idx1(c2), fulltext index ft(c3));
-insert into t1 values(1,10,"aa ii uu ee oo");
-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 'mroonga_count_skip';
+DROP TABLE IF EXISTS t1, t2, t3;
+FLUSH STATUS;
+CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT, c3 TEXT, KEY idx1(c2), FULLTEXT INDEX ft(c3));
+INSERT INTO t1 VALUES(1,10,"aa ii uu ee oo");
+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 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 0
-select count(*) from t1 where match(c3) against("+su" in boolean mode);
-count(*)
+SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+COUNT(*)
1
-show status like 'mroonga_count_skip';
+SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-insert into t1 values(6,60,"");
-show status like 'mroonga_count_skip';
+INSERT INTO t1 VALUES(6,60,"");
+SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-select count(*) from t1 where match(c3) against("+su" in boolean mode);
-count(*)
+SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+COUNT(*)
1
-show status like 'mroonga_count_skip';
+SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 2
-drop table t1;
+DROP TABLE t1;
Modified: test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test (+20 -20)
===================================================================
--- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:30:43 +0900 (6e43051)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:33:53 +0900 (d7b85d5)
@@ -17,27 +17,27 @@
--source include/have_mroonga.inc
--disable_warnings
-drop table if exists t1, t2, t3;
+DROP TABLE IF EXISTS t1, t2, t3;
--enable_warnings
-flush status;
-create table t1 (c1 int primary key, c2 int, c3 text, key idx1(c2), fulltext index ft(c3));
-insert into t1 values(1,10,"aa ii uu ee oo");
-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 'mroonga_count_skip';
-select count(*) from t1 where match(c3) against("+su" in boolean mode);
-show status like 'mroonga_count_skip';
-connect (thread2, localhost, root,,);
-connection thread2;
-insert into t1 values(6,60,"");
-disconnect thread2;
-connection default;
-show status like 'mroonga_count_skip';
-select count(*) from t1 where match(c3) against("+su" in boolean mode);
-show status like 'mroonga_count_skip';
-drop table t1;
+FLUSH STATUS;
+CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT, c3 TEXT, KEY idx1(c2), FULLTEXT INDEX ft(c3));
+INSERT INTO t1 VALUES(1,10,"aa ii uu ee oo");
+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 'mroonga_count_skip';
+SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+SHOW STATUS LIKE 'mroonga_count_skip';
+CONNECT (thread2, localhost, root,,);
+CONNECTION thread2;
+INSERT INTO t1 VALUES(6,60,"");
+DISCONNECT thread2;
+CONNECTION default;
+SHOW STATUS LIKE 'mroonga_count_skip';
+SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+SHOW STATUS LIKE 'mroonga_count_skip';
+DROP TABLE t1;
--source include/have_mroonga_deinit.inc