diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-07-10 21:19:11 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-07-10 21:19:11 +0200 |
| commit | 3ab7052d791a21c6298ae943535ecbcd476d66a9 (patch) | |
| tree | 2eb1761ff96a3be2ba4cf37591e52374cec87d31 /mysql-test/r/cast.result | |
| parent | b9b41a5fb0de32fe1a57fb07d7fa67857aa68237 (diff) | |
| download | mariadb-git-3ab7052d791a21c6298ae943535ecbcd476d66a9.tar.gz | |
fix cast.test, select.test, select_jcl6.test: update results after strict_date_checking=1
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 12 |
1 files changed, 9 insertions, 3 deletions
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'); |