null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 11:52:54 JST
Kouhei Sutou 2012-03-28 11:52:54 +0900 (Wed, 28 Mar 2012)
New Revision: a89624ef74e130291dcbfe08f494a25a1d1769e0
Log:
test: insert reasonable values into a named 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:48:38 +0900 (58264b8)
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:52:54 +0900 (00d73e9)
@@ -4,25 +4,23 @@ CREATE TABLE t1 (
title TEXT,
FULLTEXT INDEX ft(title)
);
-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");
+INSERT INTO t1 VALUES("Hello mroonga!");
+INSERT INTO t1 VALUES("It's funny.");
+INSERT INTO t1 VALUES("Happy birthday!");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 0
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
COUNT(*)
1
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-INSERT INTO t1 VALUES("");
+INSERT INTO t1 VALUES("Rainy day...");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
COUNT(*)
1
SHOW STATUS LIKE 'mroonga_count_skip';
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:48:38 +0900 (076605f)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:52:54 +0900 (1406d67)
@@ -27,24 +27,22 @@ CREATE TABLE t1 (
FULLTEXT INDEX ft(title)
);
-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");
+INSERT INTO t1 VALUES("Hello mroonga!");
+INSERT INTO t1 VALUES("It's funny.");
+INSERT INTO t1 VALUES("Happy birthday!");
SHOW STATUS LIKE 'mroonga_count_skip';
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
SHOW STATUS LIKE 'mroonga_count_skip';
CONNECT (thread2, localhost, root, ,);
CONNECTION thread2;
-INSERT INTO t1 VALUES("");
+INSERT INTO t1 VALUES("Rainy day...");
DISCONNECT thread2;
CONNECTION default;
SHOW STATUS LIKE 'mroonga_count_skip';
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
SHOW STATUS LIKE 'mroonga_count_skip';
DROP TABLE t1;