Kouhei Sutou
null+****@clear*****
Tue Apr 19 22:29:13 JST 2016
Kouhei Sutou 2016-04-19 22:29:13 +0900 (Tue, 19 Apr 2016) New Revision: 1cdfa7dc4653be4bf4e70990c6b5f599b0d1b644 https://github.com/mroonga/mroonga/commit/1cdfa7dc4653be4bf4e70990c6b5f599b0d1b644 Message: mysql57 test: set default value for timestamp explicitly Because MySQL 5.7 enables NO_ZERO_DATE by default. It disables DEFAULT 0. Modified files: mysql-test/mroonga/storage/column/timestamp/r/with_index.result mysql-test/mroonga/storage/column/timestamp/t/with_index.test Modified: mysql-test/mroonga/storage/column/timestamp/r/with_index.result (+4 -4) =================================================================== --- mysql-test/mroonga/storage/column/timestamp/r/with_index.result 2016-04-19 22:25:51 +0900 (b310de4) +++ mysql-test/mroonga/storage/column/timestamp/r/with_index.result 2016-04-19 22:29:13 +0900 (3bc01ab) @@ -2,8 +2,8 @@ DROP TABLE IF EXISTS diaries; CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, title TEXT, -created_at TIMESTAMP, -updated_at TIMESTAMP, +created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, +updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY (updated_at) ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; @@ -11,8 +11,8 @@ Table Create Table diaries CREATE TABLE `diaries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` text, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', + `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `updated_at` (`updated_at`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 Modified: mysql-test/mroonga/storage/column/timestamp/t/with_index.test (+3 -3) =================================================================== --- mysql-test/mroonga/storage/column/timestamp/t/with_index.test 2016-04-19 22:25:51 +0900 (e9ee247) +++ mysql-test/mroonga/storage/column/timestamp/t/with_index.test 2016-04-19 22:29:13 +0900 (ecaab5d) @@ -1,4 +1,4 @@ -# Copyright(C) 2012 Kouhei Sutou <kou �� clear-code.com> +# Copyright(C) 2012-2016 Kouhei Sutou <kou �� clear-code.com> # # This library is free software; you can redistribute it and/or # modify it under the terms of the GNU Lesser General Public @@ -23,8 +23,8 @@ DROP TABLE IF EXISTS diaries; CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, title TEXT, - created_at TIMESTAMP, - updated_at TIMESTAMP, + created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, + updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY (updated_at) ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; -------------- next part -------------- HTML����������������������������...下載
