From 3ab7052d791a21c6298ae943535ecbcd476d66a9 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Wed, 10 Jul 2013 21:19:11 +0200 Subject: fix cast.test, select.test, select_jcl6.test: update results after strict_date_checking=1 --- mysql-test/r/cast.result | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) (limited to 'mysql-test/r/cast.result') diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 23417b16698..53e021063d2 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -750,13 +750,19 @@ CAST(CAST('20:05:05' AS TIME) as date) set sql_mode= TRADITIONAL; select cast("2101-00-01 02:03:04" as datetime); cast("2101-00-01 02:03:04" as datetime) -2101-00-01 02:03:04 +NULL +Warnings: +Warning 1292 Incorrect datetime value: '2101-00-01 02:03:04' select cast(cast("2101-00-01 02:03:04" as datetime) as time); cast(cast("2101-00-01 02:03:04" as datetime) as time) -02:03:04 +NULL +Warnings: +Warning 1292 Incorrect datetime value: '2101-00-01 02:03:04' SELECT CAST(CAST('20:05:05' AS TIME) as date); CAST(CAST('20:05:05' AS TIME) as date) -0000-00-00 +NULL +Warnings: +Warning 1292 Truncated incorrect date value: '0000-00-00' set sql_mode=DEFAULT; create table t1 (f1 time, f2 date, f3 datetime); insert into t1 values ('11:22:33','2011-12-13','2011-12-13 11:22:33'); -- cgit v1.2.1