null+****@clear*****
null+****@clear*****
2012年 2月 15日 (水) 00:02:54 JST
Kouhei Sutou 2012-02-15 00:02:54 +0900 (Wed, 15 Feb 2012)
New Revision: 422cbf0265f576e37753c7d0f2c0f6d3cd9a963b
Log:
[test] split test patterns to test files.
Added files:
test/sql/suite/mroonga_storage/r/column_datetime_with_fractional_seconds_with_index.result
test/sql/suite/mroonga_storage/r/column_datetime_with_fractional_seconds_without_index.result
test/sql/suite/mroonga_storage/r/column_datetime_without_fractional_seconds_with_index.result
test/sql/suite/mroonga_storage/r/column_datetime_without_fractional_seconds_without_index.result
Copied files:
test/sql/suite/mroonga_storage/t/column_datetime_with_fractional_seconds_without_index.test
(from test/sql/suite/mroonga_storage/t/column_datetime.test)
test/sql/suite/mroonga_storage/t/column_datetime_without_fractional_seconds_with_index.test
(from test/sql/suite/mroonga_storage/t/column_datetime.test)
Removed files:
test/sql/suite/mroonga_storage/r/column_datetime.result
test/sql/suite/mroonga_storage/r/column_datetime_fractional_seconds.result
Renamed files:
test/sql/suite/mroonga_storage/t/column_datetime_with_fractional_seconds_with_index.test
(from test/sql/suite/mroonga_storage/t/column_datetime_fractional_seconds.test)
test/sql/suite/mroonga_storage/t/column_datetime_without_fractional_seconds_without_index.test
(from test/sql/suite/mroonga_storage/t/column_datetime.test)
Deleted: test/sql/suite/mroonga_storage/r/column_datetime.result (+0 -35) 100644
===================================================================
--- test/sql/suite/mroonga_storage/r/column_datetime.result 2012-02-14 23:15:57 +0900 (6cf7ad1)
+++ /dev/null
@@ -1,35 +0,0 @@
-DROP TABLE IF EXISTS diaries;
-CREATE TABLE diaries (
-id INT PRIMARY KEY AUTO_INCREMENT,
-title TEXT,
-created_at DATETIME,
-updated_at DATETIME,
-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` datetime DEFAULT NULL,
- `updated_at` datetime 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 21:51:01", "2012-01-29 21:51:02");
-INSERT INTO diaries (title, created_at, updated_at)
-VALUES ("rainy day", "2012-01-30 01:23:45", "2012-01-30 01:23:46");
-INSERT INTO diaries (title, created_at, updated_at)
-VALUES ("cloudy day", "2012-01-31 08:32:10", "2012-01-31 08:32:11");
-SELECT * FROM diaries;
-id title created_at updated_at
-1 clear day 2012-01-29 21:51:01 2012-01-29 21:51:02
-2 rainy day 2012-01-30 01:23:45 2012-01-30 01:23:46
-3 cloudy day 2012-01-31 08:32:10 2012-01-31 08:32:11
-SELECT * FROM diaries
-WHERE updated_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
-id title created_at updated_at
-1 clear day 2012-01-29 21:51:01 2012-01-29 21:51:02
-2 rainy day 2012-01-30 01:23:45 2012-01-30 01:23:46
-DROP TABLE diaries;
Deleted: test/sql/suite/mroonga_storage/r/column_datetime_fractional_seconds.result (+0 -42) 100644
===================================================================
--- test/sql/suite/mroonga_storage/r/column_datetime_fractional_seconds.result 2012-02-14 23:15:57 +0900 (08e90d6)
+++ /dev/null
@@ -1,42 +0,0 @@
-DROP TABLE IF EXISTS diaries;
-CREATE TABLE diaries (
-id INT PRIMARY KEY AUTO_INCREMENT,
-title TEXT,
-created_at DATETIME(6),
-updated_at DATETIME(6),
-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` datetime(6) DEFAULT NULL,
- `updated_at` datetime(6) 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 21:51:01.111111",
-"2012-01-29 21:51:02.222222");
-INSERT INTO diaries (title, created_at, updated_at)
-VALUES ("rainy day",
-"2012-01-30 01:23:45.333",
-"2012-01-30 01:23:46.444");
-INSERT INTO diaries (title, created_at, updated_at)
-VALUES ("cloudy day",
-"2012-01-31 08:32:10.5555",
-"2012-01-31 08:32:11.6666");
-SELECT * FROM diaries;
-id title created_at updated_at
-1 clear day 2012-01-29 21:51:01.111111 2012-01-29 21:51:02.222222
-2 rainy day 2012-01-30 01:23:45.333000 2012-01-30 01:23:46.444000
-3 cloudy day 2012-01-31 08:32:10.555500 2012-01-31 08:32:11.666600
-SELECT * FROM diaries
-WHERE updated_at BETWEEN "2012-01-29 00:00:00.123456" AND
-"2012-01-31 00:00:00.999999";
-id title created_at updated_at
-1 clear day 2012-01-29 21:51:01.111111 2012-01-29 21:51:02.222222
-2 rainy day 2012-01-30 01:23:45.333000 2012-01-30 01:23:46.444000
-DROP TABLE diaries;
Added: test/sql/suite/mroonga_storage/r/column_datetime_with_fractional_seconds_with_index.result (+34 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/column_datetime_with_fractional_seconds_with_index.result 2012-02-15 00:02:54 +0900 (7d5236e)
@@ -0,0 +1,34 @@
+DROP TABLE IF EXISTS diaries;
+CREATE TABLE diaries (
+id INT PRIMARY KEY AUTO_INCREMENT,
+title TEXT,
+created_at DATETIME(6),
+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` datetime(6) 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 21:51:01.111111");
+INSERT INTO diaries (title, created_at)
+VALUES ("rainy day", "2012-01-30 01:23:45.333");
+INSERT INTO diaries (title, created_at)
+VALUES ("cloudy day", "2012-01-31 08:32:10.5555");
+SELECT * FROM diaries;
+id title created_at
+1 clear day 2012-01-29 21:51:01.111111
+2 rainy day 2012-01-30 01:23:45.333000
+3 cloudy day 2012-01-31 08:32:10.555500
+SELECT * FROM diaries
+WHERE updated_at BETWEEN "2012-01-29 00:00:00.123456" AND
+"2012-01-31 00:00:00.999999";
+id title created_at
+1 clear day 2012-01-29 21:51:01.111111
+2 rainy day 2012-01-30 01:23:45.333000
+DROP TABLE diaries;
Added: test/sql/suite/mroonga_storage/r/column_datetime_with_fractional_seconds_without_index.result (+32 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/column_datetime_with_fractional_seconds_without_index.result 2012-02-15 00:02:54 +0900 (55bfec7)
@@ -0,0 +1,32 @@
+DROP TABLE IF EXISTS diaries;
+CREATE TABLE diaries (
+id INT PRIMARY KEY AUTO_INCREMENT,
+title TEXT,
+created_at DATETIME(6)
+) 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` datetime(6) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=mroonga DEFAULT CHARSET=utf8
+INSERT INTO diaries (title, created_at)
+VALUES ("clear day", "2012-01-29 21:51:01.111111");
+INSERT INTO diaries (title, created_at)
+VALUES ("rainy day", "2012-01-30 01:23:45.333");
+INSERT INTO diaries (title, created_at)
+VALUES ("cloudy day", "2012-01-31 08:32:10.5555");
+SELECT * FROM diaries;
+id title created_at
+1 clear day 2012-01-29 21:51:01.111111
+2 rainy day 2012-01-30 01:23:45.333000
+3 cloudy day 2012-01-31 08:32:10.555500
+SELECT * FROM diaries
+WHERE created_at BETWEEN "2012-01-29 00:00:00.123456" AND
+"2012-01-31 00:00:00.999999";
+id title created_at
+1 clear day 2012-01-29 21:51:01.111111
+2 rainy day 2012-01-30 01:23:45.333000
+DROP TABLE diaries;
Added: test/sql/suite/mroonga_storage/r/column_datetime_without_fractional_seconds_with_index.result (+33 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/column_datetime_without_fractional_seconds_with_index.result 2012-02-15 00:02:54 +0900 (1d7ef14)
@@ -0,0 +1,33 @@
+DROP TABLE IF EXISTS diaries;
+CREATE TABLE diaries (
+id INT PRIMARY KEY AUTO_INCREMENT,
+title TEXT,
+created_at DATETIME,
+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` datetime 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 21:51:01");
+INSERT INTO diaries (title, created_at)
+VALUES ("rainy day", "2012-01-30 01:23:45");
+INSERT INTO diaries (title, created_at)
+VALUES ("cloudy day", "2012-01-31 08:32:10");
+SELECT * FROM diaries;
+id title created_at
+1 clear day 2012-01-29 21:51:01
+2 rainy day 2012-01-30 01:23:45
+3 cloudy day 2012-01-31 08:32:10
+SELECT * FROM diaries
+WHERE created_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
+id title created_at
+1 clear day 2012-01-29 21:51:01
+2 rainy day 2012-01-30 01:23:45
+DROP TABLE diaries;
Added: test/sql/suite/mroonga_storage/r/column_datetime_without_fractional_seconds_without_index.result (+31 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/column_datetime_without_fractional_seconds_without_index.result 2012-02-15 00:02:54 +0900 (b201214)
@@ -0,0 +1,31 @@
+DROP TABLE IF EXISTS diaries;
+CREATE TABLE diaries (
+id INT PRIMARY KEY AUTO_INCREMENT,
+title TEXT,
+created_at DATETIME
+) 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` datetime DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=mroonga DEFAULT CHARSET=utf8
+INSERT INTO diaries (title, created_at)
+VALUES ("clear day", "2012-01-29 21:51:01");
+INSERT INTO diaries (title, created_at)
+VALUES ("rainy day", "2012-01-30 01:23:45");
+INSERT INTO diaries (title, created_at)
+VALUES ("cloudy day", "2012-01-31 08:32:10");
+SELECT * FROM diaries;
+id title created_at
+1 clear day 2012-01-29 21:51:01
+2 rainy day 2012-01-30 01:23:45
+3 cloudy day 2012-01-31 08:32:10
+SELECT * FROM diaries
+WHERE created_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
+id title created_at
+1 clear day 2012-01-29 21:51:01
+2 rainy day 2012-01-30 01:23:45
+DROP TABLE diaries;
Renamed: test/sql/suite/mroonga_storage/t/column_datetime_with_fractional_seconds_with_index.test (+8 -15) 67%
===================================================================
--- test/sql/suite/mroonga_storage/t/column_datetime_fractional_seconds.test 2012-02-14 23:15:57 +0900 (7cabb38)
+++ test/sql/suite/mroonga_storage/t/column_datetime_with_fractional_seconds_with_index.test 2012-02-15 00:02:54 +0900 (f2b927a)
@@ -25,28 +25,21 @@ CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
created_at DATETIME(6),
- updated_at DATETIME(6),
- 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 21:51:01.111111",
- "2012-01-29 21:51:02.222222");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("rainy day",
- "2012-01-30 01:23:45.333",
- "2012-01-30 01:23:46.444");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("cloudy day",
- "2012-01-31 08:32:10.5555",
- "2012-01-31 08:32:11.6666");
+INSERT INTO diaries (title, created_at)
+ VALUES ("clear day", "2012-01-29 21:51:01.111111");
+INSERT INTO diaries (title, created_at)
+ VALUES ("rainy day", "2012-01-30 01:23:45.333");
+INSERT INTO diaries (title, created_at)
+ VALUES ("cloudy day", "2012-01-31 08:32:10.5555");
SELECT * FROM diaries;
SELECT * FROM diaries
- WHERE updated_at BETWEEN "2012-01-29 00:00:00.123456" AND
+ WHERE created_at BETWEEN "2012-01-29 00:00:00.123456" AND
"2012-01-31 00:00:00.999999";
DROP TABLE diaries;
Copied: test/sql/suite/mroonga_storage/t/column_datetime_with_fractional_seconds_without_index.test (+10 -10) 67%
===================================================================
--- test/sql/suite/mroonga_storage/t/column_datetime.test 2012-02-14 23:15:57 +0900 (4abd1fd)
+++ test/sql/suite/mroonga_storage/t/column_datetime_with_fractional_seconds_without_index.test 2012-02-15 00:02:54 +0900 (f3ca575)
@@ -14,6 +14,7 @@
# License along with this library; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+--source include/have_fractional_seconds.inc
--source include/have_mroonga.inc
--disable_warnings
@@ -23,23 +24,22 @@ DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
- created_at DATETIME,
- updated_at DATETIME,
- KEY (updated_at)
+ created_at DATETIME(6)
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE diaries;
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("clear day", "2012-01-29 21:51:01", "2012-01-29 21:51:02");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("rainy day", "2012-01-30 01:23:45", "2012-01-30 01:23:46");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("cloudy day", "2012-01-31 08:32:10", "2012-01-31 08:32:11");
+INSERT INTO diaries (title, created_at)
+ VALUES ("clear day", "2012-01-29 21:51:01.111111");
+INSERT INTO diaries (title, created_at)
+ VALUES ("rainy day", "2012-01-30 01:23:45.333");
+INSERT INTO diaries (title, created_at)
+ VALUES ("cloudy day", "2012-01-31 08:32:10.5555");
SELECT * FROM diaries;
SELECT * FROM diaries
- WHERE updated_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
+ WHERE created_at BETWEEN "2012-01-29 00:00:00.123456" AND
+ "2012-01-31 00:00:00.999999";
DROP TABLE diaries;
Copied: test/sql/suite/mroonga_storage/t/column_datetime_without_fractional_seconds_with_index.test (+8 -9) 70%
===================================================================
--- test/sql/suite/mroonga_storage/t/column_datetime.test 2012-02-14 23:15:57 +0900 (4abd1fd)
+++ test/sql/suite/mroonga_storage/t/column_datetime_without_fractional_seconds_with_index.test 2012-02-15 00:02:54 +0900 (a58ed8d)
@@ -24,22 +24,21 @@ CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
created_at DATETIME,
- updated_at DATETIME,
- 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 21:51:01", "2012-01-29 21:51:02");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("rainy day", "2012-01-30 01:23:45", "2012-01-30 01:23:46");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("cloudy day", "2012-01-31 08:32:10", "2012-01-31 08:32:11");
+INSERT INTO diaries (title, created_at)
+ VALUES ("clear day", "2012-01-29 21:51:01");
+INSERT INTO diaries (title, created_at)
+ VALUES ("rainy day", "2012-01-30 01:23:45");
+INSERT INTO diaries (title, created_at)
+ VALUES ("cloudy day", "2012-01-31 08:32:10");
SELECT * FROM diaries;
SELECT * FROM diaries
- WHERE updated_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
+ WHERE created_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
DROP TABLE diaries;
Renamed: test/sql/suite/mroonga_storage/t/column_datetime_without_fractional_seconds_without_index.test (+8 -10) 69%
===================================================================
--- test/sql/suite/mroonga_storage/t/column_datetime.test 2012-02-14 23:15:57 +0900 (4abd1fd)
+++ test/sql/suite/mroonga_storage/t/column_datetime_without_fractional_seconds_without_index.test 2012-02-15 00:02:54 +0900 (8e059e2)
@@ -23,23 +23,21 @@ DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
- created_at DATETIME,
- updated_at DATETIME,
- KEY (updated_at)
+ created_at DATETIME
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE diaries;
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("clear day", "2012-01-29 21:51:01", "2012-01-29 21:51:02");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("rainy day", "2012-01-30 01:23:45", "2012-01-30 01:23:46");
-INSERT INTO diaries (title, created_at, updated_at)
- VALUES ("cloudy day", "2012-01-31 08:32:10", "2012-01-31 08:32:11");
+INSERT INTO diaries (title, created_at)
+ VALUES ("clear day", "2012-01-29 21:51:01");
+INSERT INTO diaries (title, created_at)
+ VALUES ("rainy day", "2012-01-30 01:23:45");
+INSERT INTO diaries (title, created_at)
+ VALUES ("cloudy day", "2012-01-31 08:32:10");
SELECT * FROM diaries;
SELECT * FROM diaries
- WHERE updated_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
+ WHERE created_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
DROP TABLE diaries;