Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:49:27 JST 2012
Kouhei Sutou 2012-03-28 11:45:35 +0900 (Wed, 28 Mar 2012) New Revision: bee5b420ba5e62e6fcda358ad17951925fdb1d52 https://github.com/mroonga/mroonga/commit/bee5b420ba5e62e6fcda358ad17951925fdb1d52 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 -8) =================================================================== --- test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:43:38 +0900 (350553a) +++ test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:45:35 +0900 (92b9e1b) @@ -2,16 +2,14 @@ DROP TABLE IF EXISTS 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"); +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"); SHOW STATUS LIKE 'mroonga_count_skip'; Variable_name Value mroonga_count_skip 0 @@ -21,7 +19,7 @@ COUNT(*) SHOW STATUS LIKE 'mroonga_count_skip'; Variable_name Value mroonga_count_skip 1 -INSERT INTO t1 VALUES(6, 60, ""); +INSERT INTO t1 VALUES(6, ""); 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 -8) =================================================================== --- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:43:38 +0900 (317a35b) +++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:45:35 +0900 (61e420c) @@ -24,17 +24,15 @@ DROP TABLE IF EXISTS 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"); +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"); SHOW STATUS LIKE 'mroonga_count_skip'; SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE); @@ -42,7 +40,7 @@ SHOW STATUS LIKE 'mroonga_count_skip'; CONNECT (thread2, localhost, root, ,); CONNECTION thread2; -INSERT INTO t1 VALUES(6, 60, ""); +INSERT INTO t1 VALUES(6, ""); DISCONNECT thread2; CONNECTION default; -------------- next part -------------- HTML����������������������������...다운로드
