Kouhei Sutou
null+****@clear*****
Wed Apr 20 23:09:57 JST 2016
Kouhei Sutou 2016-04-20 23:09:57 +0900 (Wed, 20 Apr 2016) New Revision: 97338d3393d2a17633a5bc955d0207d6aaa767dd https://github.com/mroonga/mroonga/commit/97338d3393d2a17633a5bc955d0207d6aaa767dd Message: mysql57 test: follow default sql_mode change Added files: mysql-test/mroonga/storage/column/datetime/64bit/mysql_57_or_later/r/out_of_range.result Copied files: mysql-test/mroonga/storage/column/datetime/64bit/mysql_57_or_later/t/out_of_range.test (from mysql-test/mroonga/storage/column/datetime/64bit/version_56_or_later/t/out_of_range.test) Modified files: mysql-test/mroonga/storage/column/datetime/64bit/version_56_or_later/t/out_of_range.test Added: mysql-test/mroonga/storage/column/datetime/64bit/mysql_57_or_later/r/out_of_range.result (+20 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/storage/column/datetime/64bit/mysql_57_or_later/r/out_of_range.result 2016-04-20 23:09:57 +0900 (f4e6eec) @@ -0,0 +1,20 @@ +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 ('2012', '2012'); +ERROR 22007: Incorrect datetime value: '2012' for column 'created_at' at row 1 +SELECT * FROM diaries; +id title created_at +DROP TABLE diaries; Copied: mysql-test/mroonga/storage/column/datetime/64bit/mysql_57_or_later/t/out_of_range.test (+2 -1) 93% =================================================================== --- mysql-test/mroonga/storage/column/datetime/64bit/version_56_or_later/t/out_of_range.test 2016-04-20 23:06:36 +0900 (1688e7c) +++ mysql-test/mroonga/storage/column/datetime/64bit/mysql_57_or_later/t/out_of_range.test 2016-04-20 23:09:57 +0900 (68372d0) @@ -17,7 +17,7 @@ --source ../../../../../../include/mroonga/skip_freebsd.inc --source ../../../../../../include/mroonga/have_64bit.inc ---source ../../../../../../include/mroonga/have_version_56_or_later.inc +--source ../../../../../../include/mroonga/have_mysql_57_or_later.inc --source ../../../../../../include/mroonga/have_mroonga.inc --disable_warnings @@ -31,6 +31,7 @@ CREATE TABLE diaries ( ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; +--error ER_TRUNCATED_WRONG_VALUE INSERT INTO diaries (title, created_at) VALUES ('2012', '2012'); Modified: mysql-test/mroonga/storage/column/datetime/64bit/version_56_or_later/t/out_of_range.test (+1 -0) =================================================================== --- mysql-test/mroonga/storage/column/datetime/64bit/version_56_or_later/t/out_of_range.test 2016-04-20 23:06:36 +0900 (1688e7c) +++ mysql-test/mroonga/storage/column/datetime/64bit/version_56_or_later/t/out_of_range.test 2016-04-20 23:09:57 +0900 (9a8c8d1) @@ -18,6 +18,7 @@ --source ../../../../../../include/mroonga/skip_freebsd.inc --source ../../../../../../include/mroonga/have_64bit.inc --source ../../../../../../include/mroonga/have_version_56_or_later.inc +--source ../../../../../../include/mroonga/skip_mysql_57_or_later.inc --source ../../../../../../include/mroonga/have_mroonga.inc --disable_warnings -------------- next part -------------- HTML����������������������������...Download