Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:39:48 JST 2012
Kouhei Sutou 2012-03-28 11:41:37 +0900 (Wed, 28 Mar 2012) New Revision: 2f961f93e42fc31b223cd9340e7bd41397762f6d https://github.com/mroonga/mroonga/commit/2f961f93e42fc31b223cd9340e7bd41397762f6d Log: test: split a SQLs block to logical blocks Modified files: test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test Modified: test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test (+5 -0) =================================================================== --- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:38:28 +0900 (f73159d) +++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:41:37 +0900 (330eccf) @@ -29,22 +29,27 @@ CREATE TABLE t1 ( 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 -------------- next part -------------- HTML����������������������������...Download