Kouhei Sutou
null+****@clear*****
Tue Apr 19 22:25:51 JST 2016
Kouhei Sutou 2016-04-19 22:25:51 +0900 (Tue, 19 Apr 2016) New Revision: d1b204e22e460725f2cde46f93304eaef3a91a1e https://github.com/mroonga/mroonga/commit/d1b204e22e460725f2cde46f93304eaef3a91a1e 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/index/multiple_column/unique/timestamp/order/r/asc.result mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/asc.test Modified: mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/asc.result (+2 -2) =================================================================== --- mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/asc.result 2016-04-19 21:53:29 +0900 (1e4ee10) +++ mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/asc.result 2016-04-19 22:25:51 +0900 (cb62268) @@ -1,8 +1,8 @@ DROP TABLE IF EXISTS ranges; CREATE TABLE ranges ( id int PRIMARY KEY, -start timestamp, -end timestamp, +start timestamp DEFAULT CURRENT_TIMESTAMP, +end timestamp DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY range_key(start, end) ); INSERT INTO ranges VALUES (1, "2012-10-25 16:18:29", "2038-01-18 15:14:07"); Modified: mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/asc.test (+2 -2) =================================================================== --- mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/asc.test 2016-04-19 21:53:29 +0900 (dc88d72) +++ mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/asc.test 2016-04-19 22:25:51 +0900 (d18948b) @@ -24,8 +24,8 @@ DROP TABLE IF EXISTS ranges; CREATE TABLE ranges ( id int PRIMARY KEY, - start timestamp, - end timestamp, + start timestamp DEFAULT CURRENT_TIMESTAMP, + end timestamp DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY range_key(start, end) ); -------------- next part -------------- HTML����������������������������...Download