null+****@clear*****
null+****@clear*****
2012年 3月 28日 (水) 12:37:08 JST
Kouhei Sutou 2012-03-28 12:37:08 +0900 (Wed, 28 Mar 2012)
New Revision: 23d17f9fb42472c526e99f159b5955b3c9395ac0
Log:
test: split test cases in a file to separated files
We should check a test case in a file. The policy will create readable
tests.
Added files:
test/sql/suite/mroonga_storage/r/optimization_skip_count_after_insert_multithread.result
test/sql/suite/mroonga_storage/r/optimization_skip_count_after_insert_single_thread.result
Copied files:
test/sql/suite/mroonga_storage/t/optimization_skip_count_after_insert_multithread.test
(from test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test)
Removed files:
test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result
Renamed files:
test/sql/suite/mroonga_storage/t/optimization_skip_count_after_insert_single_thread.test
(from test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test)
Added: test/sql/suite/mroonga_storage/r/optimization_skip_count_after_insert_multithread.result (+19 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_after_insert_multithread.result 2012-03-28 12:37:08 +0900 (1e0ac2b)
@@ -0,0 +1,19 @@
+DROP TABLE IF EXISTS diaries;
+FLUSH STATUS;
+CREATE TABLE diaries (
+title TEXT,
+FULLTEXT INDEX ft(title)
+);
+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 diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
+COUNT(*)
+1
+SHOW STATUS LIKE 'mroonga_count_skip';
+Variable_name Value
+mroonga_count_skip 1
+DROP TABLE diaries;
Added: test/sql/suite/mroonga_storage/r/optimization_skip_count_after_insert_single_thread.result (+19 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/optimization_skip_count_after_insert_single_thread.result 2012-03-28 12:37:08 +0900 (1e0ac2b)
@@ -0,0 +1,19 @@
+DROP TABLE IF EXISTS diaries;
+FLUSH STATUS;
+CREATE TABLE diaries (
+title TEXT,
+FULLTEXT INDEX ft(title)
+);
+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 diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
+COUNT(*)
+1
+SHOW STATUS LIKE 'mroonga_count_skip';
+Variable_name Value
+mroonga_count_skip 1
+DROP TABLE diaries;
Deleted: test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result (+0 -29) 100644
===================================================================
--- test/sql/suite/mroonga_storage/r/optimization_skip_count_multithread.result 2012-03-28 11:53:27 +0900 (4104e24)
+++ /dev/null
@@ -1,29 +0,0 @@
-DROP TABLE IF EXISTS diaries;
-FLUSH STATUS;
-CREATE TABLE diaries (
-title TEXT,
-FULLTEXT INDEX ft(title)
-);
-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 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 diaries VALUES("Rainy day...");
-SHOW STATUS LIKE 'mroonga_count_skip';
-Variable_name Value
-mroonga_count_skip 1
-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 diaries;
Copied: test/sql/suite/mroonga_storage/t/optimization_skip_count_after_insert_multithread.test (+1 -6) 87%
===================================================================
--- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:53:27 +0900 (23ba14e)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_after_insert_multithread.test 2012-03-28 12:37:08 +0900 (45cfe07)
@@ -29,15 +29,10 @@ CREATE TABLE diaries (
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 diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
-SHOW STATUS LIKE 'mroonga_count_skip';
CONNECT (thread2, localhost, root, ,);
CONNECTION thread2;
-INSERT INTO diaries VALUES("Rainy day...");
+INSERT INTO diaries VALUES("Happy birthday!");
DISCONNECT thread2;
CONNECTION default;
Renamed: test/sql/suite/mroonga_storage/t/optimization_skip_count_after_insert_single_thread.test (+0 -10) 81%
===================================================================
--- test/sql/suite/mroonga_storage/t/optimization_skip_count_multithread.test 2012-03-28 11:53:27 +0900 (23ba14e)
+++ test/sql/suite/mroonga_storage/t/optimization_skip_count_after_insert_single_thread.test 2012-03-28 12:37:08 +0900 (49be07f)
@@ -35,16 +35,6 @@ SHOW STATUS LIKE 'mroonga_count_skip';
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 diaries VALUES("Rainy day...");
-DISCONNECT thread2;
-CONNECTION default;
-
-SHOW STATUS LIKE 'mroonga_count_skip';
-SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
-SHOW STATUS LIKE 'mroonga_count_skip';
-
DROP TABLE diaries;
--source include/have_mroonga_deinit.inc