null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 11:48:38 JST
Kouhei Sutou 2012-03-28 11:48:38 +0900 (Wed, 28 Mar 2012)
New Revision: c0be1ee2e86016544180a32f1f748fa963cc8191
Log:
test: use meaningful name for column name
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 (+4 -4)
===================================================================
--- test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:47:00 +0900 (53a6ec5)
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:48:38 +0900 (58264b8)
@@ -1,8 +1,8 @@
DROP TABLE IF EXISTS t1;
FLUSH STATUS;
CREATE TABLE t1 (
-c3 TEXT,
-FULLTEXT INDEX ft(c3)
+title TEXT,
+FULLTEXT INDEX ft(title)
);
INSERT INTO t1 VALUES("aa ii uu ee oo");
INSERT INTO t1 VALUES("ka ki ku ke ko");
@@ -12,7 +12,7 @@ INSERT INTO t1 VALUES("aa ii uu ee oo");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 0
-SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
COUNT(*)
1
SHOW STATUS LIKE 'mroonga_count_skip';
@@ -22,7 +22,7 @@ INSERT INTO t1 VALUES("");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
COUNT(*)
1
SHOW STATUS LIKE 'mroonga_count_skip';
Modified: test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test (+4 -4)
===================================================================
--- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:47:00 +0900 (4ab3cf6)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:48:38 +0900 (076605f)
@@ -23,8 +23,8 @@ DROP TABLE IF EXISTS t1;
FLUSH STATUS;
CREATE TABLE t1 (
- c3 TEXT,
- FULLTEXT INDEX ft(c3)
+ title TEXT,
+ FULLTEXT INDEX ft(title)
);
INSERT INTO t1 VALUES("aa ii uu ee oo");
@@ -34,7 +34,7 @@ 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);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
SHOW STATUS LIKE 'mroonga_count_skip';
CONNECT (thread2, localhost, root, ,);
@@ -44,7 +44,7 @@ DISCONNECT thread2;
CONNECTION default;
SHOW STATUS LIKE 'mroonga_count_skip';
-SELECT COUNT(*) FROM t1 WHERE MATCH(c3) AGAINST("+su" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("+su" IN BOOLEAN MODE);
SHOW STATUS LIKE 'mroonga_count_skip';
DROP TABLE t1;