null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 11:53:27 JST
Kouhei Sutou 2012-03-28 11:53:27 +0900 (Wed, 28 Mar 2012)
New Revision: 52129d50fee5ec42be4d7534d2ce7d8b72d99591
Log:
test: use meaningful table 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 (+9 -9)
===================================================================
--- test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:52:54 +0900 (00d73e9)
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:53:27 +0900 (4104e24)
@@ -1,29 +1,29 @@
-DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS diaries;
FLUSH STATUS;
-CREATE TABLE t1 (
+CREATE TABLE diaries (
title TEXT,
FULLTEXT INDEX ft(title)
);
-INSERT INTO t1 VALUES("Hello mroonga!");
-INSERT INTO t1 VALUES("It's funny.");
-INSERT INTO t1 VALUES("Happy birthday!");
+INSERT INTO diaries VALUES("Hello mroonga!");
+INSERT INTO diaries VALUES("It's funny.");
+INSERT INTO diaries VALUES("Happy birthday!");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 0
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM diaries 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("Rainy day...");
+INSERT INTO diaries VALUES("Rainy day...");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 1
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
COUNT(*)
1
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
mroonga_count_skip 2
-DROP TABLE t1;
+DROP TABLE diaries;
Modified: test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test (+9 -9)
===================================================================
--- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:52:54 +0900 (1406d67)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:53:27 +0900 (23ba14e)
@@ -18,33 +18,33 @@
--source include/have_mroonga.inc
--disable_warnings
-DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS diaries;
--enable_warnings
FLUSH STATUS;
-CREATE TABLE t1 (
+CREATE TABLE diaries (
title TEXT,
FULLTEXT INDEX ft(title)
);
-INSERT INTO t1 VALUES("Hello mroonga!");
-INSERT INTO t1 VALUES("It's funny.");
-INSERT INTO t1 VALUES("Happy birthday!");
+INSERT INTO diaries VALUES("Hello mroonga!");
+INSERT INTO diaries VALUES("It's funny.");
+INSERT INTO diaries VALUES("Happy birthday!");
SHOW STATUS LIKE 'mroonga_count_skip';
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
SHOW STATUS LIKE 'mroonga_count_skip';
CONNECT (thread2, localhost, root, ,);
CONNECTION thread2;
-INSERT INTO t1 VALUES("Rainy day...");
+INSERT INTO diaries VALUES("Rainy day...");
DISCONNECT thread2;
CONNECTION default;
SHOW STATUS LIKE 'mroonga_count_skip';
-SELECT COUNT(*) FROM t1 WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
+SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
SHOW STATUS LIKE 'mroonga_count_skip';
-DROP TABLE t1;
+DROP TABLE diaries;
--source include/have_mroonga_deinit.inc