null+****@clear*****
null+****@clear*****
2012年 2月 15日 (水) 00:17:20 JST
Kouhei Sutou 2012-02-15 00:17:20 +0900 (Wed, 15 Feb 2012)
New Revision: 6444eb21dd49a2eee9fdcb4eb38388206d5f8f03
Log:
[test] split test patterns to test files.
Added files:
test/sql/suite/mroonga_storage/r/column_year_with_index.result
test/sql/suite/mroonga_storage/r/column_year_without_index.result
Copied files:
test/sql/suite/mroonga_storage/t/column_year_with_index.test
(from test/sql/suite/mroonga_storage/t/column_year.test)
Removed files:
test/sql/suite/mroonga_storage/r/column_year.result
Renamed files:
test/sql/suite/mroonga_storage/t/column_year_without_index.test
(from test/sql/suite/mroonga_storage/t/column_year.test)
Deleted: test/sql/suite/mroonga_storage/r/column_year.result (+0 -38) 100644
===================================================================
--- test/sql/suite/mroonga_storage/r/column_year.result 2012-02-15 00:05:02 +0900 (a3c4fce)
+++ /dev/null
@@ -1,38 +0,0 @@
-DROP TABLE IF EXISTS aniversary_memos;
-CREATE TABLE aniversary_memos (
-id INT PRIMARY KEY AUTO_INCREMENT,
-title TEXT,
-created_year YEAR,
-party_year YEAR,
-KEY (created_year)
-) DEFAULT CHARSET UTF8;
-SHOW CREATE TABLE aniversary_memos;
-Table Create Table
-aniversary_memos CREATE TABLE `aniversary_memos` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` text,
- `created_year` year(4) DEFAULT NULL,
- `party_year` year(4) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `created_year` (`created_year`)
-) ENGINE=mroonga DEFAULT CHARSET=utf8
-INSERT INTO aniversary_memos (title, created_year, party_year)
-VALUES ("We need a big cake!", "11", "12");
-INSERT INTO aniversary_memos (title, created_year, party_year)
-VALUES ("Invitations are sent.", "2011", "2012");
-INSERT INTO aniversary_memos (title, created_year, party_year)
-VALUES ("Tommorow is the anniversary party day!", "2012", "2012");
-INSERT INTO aniversary_memos (title, created_year, party_year)
-VALUES ("Wow! Today is the anniversary party day!", "13", "13");
-SELECT * FROM aniversary_memos;
-id title created_year party_year
-1 We need a big cake! 2011 2012
-2 Invitations are sent. 2011 2012
-3 Tommorow is the anniversary party day! 2012 2012
-4 Wow! Today is the anniversary party day! 2013 2013
-SELECT * FROM aniversary_memos
-WHERE created_year BETWEEN "12" AND "2013";
-id title created_year party_year
-3 Tommorow is the anniversary party day! 2012 2012
-4 Wow! Today is the anniversary party day! 2013 2013
-DROP TABLE aniversary_memos;
Added: test/sql/suite/mroonga_storage/r/column_year_with_index.result (+37 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/column_year_with_index.result 2012-02-15 00:17:20 +0900 (832e5ef)
@@ -0,0 +1,37 @@
+DROP TABLE IF EXISTS aniversary_memos;
+CREATE TABLE aniversary_memos (
+id INT PRIMARY KEY AUTO_INCREMENT,
+title TEXT,
+party_year YEAR,
+KEY (party_year)
+) DEFAULT CHARSET UTF8;
+SHOW CREATE TABLE aniversary_memos;
+Table Create Table
+aniversary_memos CREATE TABLE `aniversary_memos` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `title` text,
+ `party_year` year(4) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `party_year` (`party_year`)
+) ENGINE=mroonga DEFAULT CHARSET=utf8
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("We need a big cake!", "11");
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("Invitations are sent.", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("Tommorow is the anniversary party day!", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("Wow! Today is the anniversary party day!", "13");
+SELECT * FROM aniversary_memos;
+id title party_year
+1 We need a big cake! 2011
+2 Invitations are sent. 2012
+3 Tommorow is the anniversary party day! 2012
+4 Wow! Today is the anniversary party day! 2013
+SELECT * FROM aniversary_memos
+WHERE party_year BETWEEN "12" AND "2013";
+id title party_year
+2 Invitations are sent. 2012
+3 Tommorow is the anniversary party day! 2012
+4 Wow! Today is the anniversary party day! 2013
+DROP TABLE aniversary_memos;
Added: test/sql/suite/mroonga_storage/r/column_year_without_index.result (+35 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/suite/mroonga_storage/r/column_year_without_index.result 2012-02-15 00:17:20 +0900 (9ab4c5d)
@@ -0,0 +1,35 @@
+DROP TABLE IF EXISTS aniversary_memos;
+CREATE TABLE aniversary_memos (
+id INT PRIMARY KEY AUTO_INCREMENT,
+title TEXT,
+party_year YEAR
+) DEFAULT CHARSET UTF8;
+SHOW CREATE TABLE aniversary_memos;
+Table Create Table
+aniversary_memos CREATE TABLE `aniversary_memos` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `title` text,
+ `party_year` year(4) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=mroonga DEFAULT CHARSET=utf8
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("We need a big cake!", "11");
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("Invitations are sent.", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("Tommorow is the anniversary party day!", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+VALUES ("Wow! Today is the anniversary party day!", "13");
+SELECT * FROM aniversary_memos;
+id title party_year
+1 We need a big cake! 2011
+2 Invitations are sent. 2012
+3 Tommorow is the anniversary party day! 2012
+4 Wow! Today is the anniversary party day! 2013
+SELECT * FROM aniversary_memos
+WHERE party_year BETWEEN "12" AND "2013";
+id title party_year
+2 Invitations are sent. 2012
+3 Tommorow is the anniversary party day! 2012
+4 Wow! Today is the anniversary party day! 2013
+DROP TABLE aniversary_memos;
Copied: test/sql/suite/mroonga_storage/t/column_year_with_index.test (+10 -11) 66%
===================================================================
--- test/sql/suite/mroonga_storage/t/column_year.test 2012-02-15 00:05:02 +0900 (f751190)
+++ test/sql/suite/mroonga_storage/t/column_year_with_index.test 2012-02-15 00:17:20 +0900 (c64b8bd)
@@ -23,25 +23,24 @@ DROP TABLE IF EXISTS aniversary_memos;
CREATE TABLE aniversary_memos (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
- created_year YEAR,
party_year YEAR,
- KEY (created_year)
+ KEY (party_year)
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE aniversary_memos;
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("We need a big cake!", "11", "12");
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("Invitations are sent.", "2011", "2012");
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("Tommorow is the anniversary party day!", "2012", "2012");
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("Wow! Today is the anniversary party day!", "13", "13");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("We need a big cake!", "11");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("Invitations are sent.", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("Tommorow is the anniversary party day!", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("Wow! Today is the anniversary party day!", "13");
SELECT * FROM aniversary_memos;
SELECT * FROM aniversary_memos
- WHERE created_year BETWEEN "12" AND "2013";
+ WHERE party_year BETWEEN "12" AND "2013";
DROP TABLE aniversary_memos;
Renamed: test/sql/suite/mroonga_storage/t/column_year_without_index.test (+10 -12) 65%
===================================================================
--- test/sql/suite/mroonga_storage/t/column_year.test 2012-02-15 00:05:02 +0900 (f751190)
+++ test/sql/suite/mroonga_storage/t/column_year_without_index.test 2012-02-15 00:17:20 +0900 (e29948a)
@@ -23,25 +23,23 @@ DROP TABLE IF EXISTS aniversary_memos;
CREATE TABLE aniversary_memos (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
- created_year YEAR,
- party_year YEAR,
- KEY (created_year)
+ party_year YEAR
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE aniversary_memos;
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("We need a big cake!", "11", "12");
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("Invitations are sent.", "2011", "2012");
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("Tommorow is the anniversary party day!", "2012", "2012");
-INSERT INTO aniversary_memos (title, created_year, party_year)
- VALUES ("Wow! Today is the anniversary party day!", "13", "13");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("We need a big cake!", "11");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("Invitations are sent.", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("Tommorow is the anniversary party day!", "2012");
+INSERT INTO aniversary_memos (title, party_year)
+ VALUES ("Wow! Today is the anniversary party day!", "13");
SELECT * FROM aniversary_memos;
SELECT * FROM aniversary_memos
- WHERE created_year BETWEEN "12" AND "2013";
+ WHERE party_year BETWEEN "12" AND "2013";
DROP TABLE aniversary_memos;