[Groonga-mysql-commit] mroonga/mroonga [master] [test] split test patterns to each test file.

Back to archive index

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;
 




Groonga-mysql-commit メーリングリストの案内
Back to archive index