null+****@clear*****
null+****@clear*****
2012年 2月 14日 (火) 23:15:57 JST
Kouhei Sutou 2012-02-14 23:15:57 +0900 (Tue, 14 Feb 2012) New Revision: a6888cd7a23a8c390d7a9a1f941f71f25c159447 Log: [test] split test patterns to each test file. Added files: test/sql/suite/mroonga_storage/r/column_date_with_index.result test/sql/suite/mroonga_storage/r/column_date_without_index.result Copied files: test/sql/suite/mroonga_storage/t/column_date_with_index.test (from test/sql/suite/mroonga_storage/t/column_date.test) Removed files: test/sql/suite/mroonga_storage/r/column_date.result Renamed files: test/sql/suite/mroonga_storage/t/column_date_without_index.test (from test/sql/suite/mroonga_storage/t/column_date.test) Deleted: test/sql/suite/mroonga_storage/r/column_date.result (+0 -35) 100644 =================================================================== --- test/sql/suite/mroonga_storage/r/column_date.result 2012-02-14 22:43:02 +0900 (1cdb789) +++ /dev/null @@ -1,35 +0,0 @@ -DROP TABLE IF EXISTS diaries; -CREATE TABLE diaries ( -id INT PRIMARY KEY AUTO_INCREMENT, -title TEXT, -created_at DATE, -updated_at DATE, -KEY (updated_at) -) DEFAULT CHARSET UTF8; -SHOW CREATE TABLE diaries; -Table Create Table -diaries CREATE TABLE `diaries` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `title` text, - `created_at` date DEFAULT NULL, - `updated_at` date DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `updated_at` (`updated_at`) -) ENGINE=mroonga DEFAULT CHARSET=utf8 -INSERT INTO diaries (title, created_at, updated_at) -VALUES ("clear day", "2012-01-29", "2012-01-29"); -INSERT INTO diaries (title, created_at, updated_at) -VALUES ("rainy day", "2012-01-30", "2012-01-30"); -INSERT INTO diaries (title, created_at, updated_at) -VALUES ("cloudy day", "2012-01-31", "2012-01-31"); -SELECT * FROM diaries; -id title created_at updated_at -1 clear day 2012-01-29 2012-01-29 -2 rainy day 2012-01-30 2012-01-30 -3 cloudy day 2012-01-31 2012-01-31 -SELECT * FROM diaries -WHERE updated_at BETWEEN "2012-01-29" AND "2012-01-30"; -id title created_at updated_at -1 clear day 2012-01-29 2012-01-29 -2 rainy day 2012-01-30 2012-01-30 -DROP TABLE diaries; Added: test/sql/suite/mroonga_storage/r/column_date_with_index.result (+29 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/mroonga_storage/r/column_date_with_index.result 2012-02-14 23:15:57 +0900 (1c6cf69) @@ -0,0 +1,29 @@ +DROP TABLE IF EXISTS diaries; +CREATE TABLE diaries ( +id INT PRIMARY KEY AUTO_INCREMENT, +title TEXT, +created_at DATE, +KEY (created_at) +) DEFAULT CHARSET UTF8; +SHOW CREATE TABLE diaries; +Table Create Table +diaries CREATE TABLE `diaries` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text, + `created_at` date DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `created_at` (`created_at`) +) ENGINE=mroonga DEFAULT CHARSET=utf8 +INSERT INTO diaries (title, created_at) VALUES ("clear day", "2012-01-29"); +INSERT INTO diaries (title, created_at) VALUES ("rainy day", "2012-01-30"); +INSERT INTO diaries (title, created_at) VALUES ("cloudy day", "2012-01-31"); +SELECT * FROM diaries; +id title created_at +1 clear day 2012-01-29 +2 rainy day 2012-01-30 +3 cloudy day 2012-01-31 +SELECT * FROM diaries WHERE created_at BETWEEN "2012-01-29" AND "2012-01-30"; +id title created_at +1 clear day 2012-01-29 +2 rainy day 2012-01-30 +DROP TABLE diaries; Added: test/sql/suite/mroonga_storage/r/column_date_without_index.result (+27 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/mroonga_storage/r/column_date_without_index.result 2012-02-14 23:15:57 +0900 (19dd41c) @@ -0,0 +1,27 @@ +DROP TABLE IF EXISTS diaries; +CREATE TABLE diaries ( +id INT PRIMARY KEY AUTO_INCREMENT, +title TEXT, +created_at DATE +) DEFAULT CHARSET UTF8; +SHOW CREATE TABLE diaries; +Table Create Table +diaries CREATE TABLE `diaries` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text, + `created_at` date DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=mroonga DEFAULT CHARSET=utf8 +INSERT INTO diaries (title, created_at) VALUES ("clear day", "2012-01-29"); +INSERT INTO diaries (title, created_at) VALUES ("rainy day", "2012-01-30"); +INSERT INTO diaries (title, created_at) VALUES ("cloudy day", "2012-01-31"); +SELECT * FROM diaries; +id title created_at +1 clear day 2012-01-29 +2 rainy day 2012-01-30 +3 cloudy day 2012-01-31 +SELECT * FROM diaries WHERE created_at BETWEEN "2012-01-29" AND "2012-01-30"; +id title created_at +1 clear day 2012-01-29 +2 rainy day 2012-01-30 +DROP TABLE diaries; Copied: test/sql/suite/mroonga_storage/t/column_date_with_index.test (+5 -10) 71% =================================================================== --- test/sql/suite/mroonga_storage/t/column_date.test 2012-02-14 22:43:02 +0900 (4f318b2) +++ test/sql/suite/mroonga_storage/t/column_date_with_index.test 2012-02-14 23:15:57 +0900 (08b8e88) @@ -24,22 +24,17 @@ CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, title TEXT, created_at DATE, - updated_at DATE, - KEY (updated_at) + KEY (created_at) ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; -INSERT INTO diaries (title, created_at, updated_at) - VALUES ("clear day", "2012-01-29", "2012-01-29"); -INSERT INTO diaries (title, created_at, updated_at) - VALUES ("rainy day", "2012-01-30", "2012-01-30"); -INSERT INTO diaries (title, created_at, updated_at) - VALUES ("cloudy day", "2012-01-31", "2012-01-31"); +INSERT INTO diaries (title, created_at) VALUES ("clear day", "2012-01-29"); +INSERT INTO diaries (title, created_at) VALUES ("rainy day", "2012-01-30"); +INSERT INTO diaries (title, created_at) VALUES ("cloudy day", "2012-01-31"); SELECT * FROM diaries; -SELECT * FROM diaries - WHERE updated_at BETWEEN "2012-01-29" AND "2012-01-30"; +SELECT * FROM diaries WHERE created_at BETWEEN "2012-01-29" AND "2012-01-30"; DROP TABLE diaries; Renamed: test/sql/suite/mroonga_storage/t/column_date_without_index.test (+5 -11) 69% =================================================================== --- test/sql/suite/mroonga_storage/t/column_date.test 2012-02-14 22:43:02 +0900 (4f318b2) +++ test/sql/suite/mroonga_storage/t/column_date_without_index.test 2012-02-14 23:15:57 +0900 (525292f) @@ -23,23 +23,17 @@ DROP TABLE IF EXISTS diaries; CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, title TEXT, - created_at DATE, - updated_at DATE, - KEY (updated_at) + created_at DATE ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; -INSERT INTO diaries (title, created_at, updated_at) - VALUES ("clear day", "2012-01-29", "2012-01-29"); -INSERT INTO diaries (title, created_at, updated_at) - VALUES ("rainy day", "2012-01-30", "2012-01-30"); -INSERT INTO diaries (title, created_at, updated_at) - VALUES ("cloudy day", "2012-01-31", "2012-01-31"); +INSERT INTO diaries (title, created_at) VALUES ("clear day", "2012-01-29"); +INSERT INTO diaries (title, created_at) VALUES ("rainy day", "2012-01-30"); +INSERT INTO diaries (title, created_at) VALUES ("cloudy day", "2012-01-31"); SELECT * FROM diaries; -SELECT * FROM diaries - WHERE updated_at BETWEEN "2012-01-29" AND "2012-01-30"; +SELECT * FROM diaries WHERE created_at BETWEEN "2012-01-29" AND "2012-01-30"; DROP TABLE diaries;