null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 11:47:00 JST
Kouhei Sutou 2012-03-28 11:47:00 +0900 (Wed, 28 Mar 2012)
New Revision: 380fac8a0972b09bc7cabee645d1994a2e535698
Log:
test: remove a needless column
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 (+6 -7)
===================================================================
--- test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:45:35 +0900 (92b9e1b)
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:47:00 +0900 (53a6ec5)
@@ -1,15 +1,14 @@
DROP TABLE IF EXISTS t1;
FLUSH STATUS;
CREATE TABLE t1 (
-c1 INT PRIMARY KEY,
c3 TEXT,
FULLTEXT INDEX ft(c3)
);
-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, "sa si su se so");
-INSERT INTO t1 VALUES(4, "ta ti tu te to");
-INSERT INTO t1 VALUES(5, "aa ii uu ee oo");
+INSERT INTO t1 VALUES("aa ii uu ee oo");
+INSERT INTO t1 VALUES("ka ki ku ke ko");
+INSERT INTO t1 VALUES("sa si su se so");
+INSERT INTO t1 VALUES("ta ti tu te to");
+INSERT INTO t1 VALUES("aa ii uu ee oo");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 0
@@ -19,7 +18,7 @@ COUNT(*)
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-INSERT INTO t1 VALUES(6, "");
+INSERT INTO t1 VALUES("");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
Modified: test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test (+6 -7)
===================================================================
--- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:45:35 +0900 (61e420c)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:47:00 +0900 (4ab3cf6)
@@ -23,16 +23,15 @@ DROP TABLE IF EXISTS t1;
FLUSH STATUS;
CREATE TABLE t1 (
- c1 INT PRIMARY KEY,
c3 TEXT,
FULLTEXT INDEX ft(c3)
);
-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, "sa si su se so");
-INSERT INTO t1 VALUES(4, "ta ti tu te to");
-INSERT INTO t1 VALUES(5, "aa ii uu ee oo");
+INSERT INTO t1 VALUES("aa ii uu ee oo");
+INSERT INTO t1 VALUES("ka ki ku ke ko");
+INSERT INTO t1 VALUES("sa si su se so");
+INSERT INTO t1 VALUES("ta ti tu te to");
+INSERT INTO t1 VALUES("aa ii uu ee oo");
SHOW STATUS LIKE 'mroonga_count_skip';
SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
@@ -40,7 +39,7 @@ SHOW STATUS LIKE 'mroonga_count_skip';
CONNECT (thread2, localhost, root, ,);
CONNECTION thread2;
-INSERT INTO t1 VALUES(6, "");
+INSERT INTO t1 VALUES("");
DISCONNECT thread2;
CONNECTION default;