null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 11:41:37 JST
Kouhei Sutou 2012-03-28 11:41:37 +0900 (Wed, 28 Mar 2012)
New Revision: 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