Kouhei Sutou
null+****@clear*****
Tue Apr 19 23:40:36 JST 2016
Kouhei Sutou 2016-04-19 23:40:36 +0900 (Tue, 19 Apr 2016) New Revision: d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8 https://github.com/mroonga/mroonga/commit/d8fe76089d2ac6a37f9e421e92c0a5e7790d76f8 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/desc.result mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/desc.test Modified: mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/desc.result (+2 -2) =================================================================== --- mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/desc.result 2016-04-19 23:36:50 +0900 (23a5522) +++ mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/r/desc.result 2016-04-19 23:40:36 +0900 (a4bdfd6) @@ -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/desc.test (+3 -3) =================================================================== --- mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/desc.test 2016-04-19 23:36:50 +0900 (2e6e66f) +++ mysql-test/mroonga/storage/index/multiple_column/unique/timestamp/order/t/desc.test 2016-04-19 23:40:36 +0900 (7a706e3) @@ -1,5 +1,5 @@ # Copyright(C) 2012 Kentoku SHIBA -# 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 @@ -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����������������������������...Télécharger
