From 9b79888df82259743284501af5b156a18edc427f Mon Sep 17 00:00:00 2001
From: Alexander Barkov <bar@mariadb.org>
Date: Mon, 22 May 2017 17:13:15 +0400
Subject: MDEV-12866 Out-of-range error with CREATE..SELECT..TO_SECONDS(NOW())

---
 mysql-test/t/func_time.test | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'mysql-test/t/func_time.test')

diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test
index 216b059038b..a3f542aaf57 100644
--- a/mysql-test/t/func_time.test
+++ b/mysql-test/t/func_time.test
@@ -1871,3 +1871,12 @@ DROP TABLE t2;
 DROP VIEW v1;
 DROP TABLE t1;
 SET sql_mode=DEFAULT;
+
+--echo #
+--echo # MDEV-12866 Out-of-range error with CREATE..SELECT..TO_SECONDS(NOW())
+--echo #
+SET sql_mode=STRICT_ALL_TABLES;
+CREATE TABLE t1 AS SELECT TO_SECONDS('9999-12-31 23:59:59');
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+SET sql_mode=DEFAULT;
-- 
cgit v1.2.1