diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-09-27 16:38:14 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-09-27 16:38:14 +0400 |
commit | 492998c0d80aa7d5c4804ac7792a38333e3b83dd (patch) | |
tree | 376d323584d3d846bf62d5c50293181af9db9397 /mysql-test/main/type_date.result | |
parent | 786940d7e03630d28d82bca4388c937c0d48594a (diff) | |
download | mariadb-git-492998c0d80aa7d5c4804ac7792a38333e3b83dd.tar.gz |
MDEV-15406 NO_ZERO_IN_DATE erroneously affects how CAST(AS DATE) warns about fractional digit truncation
Diffstat (limited to 'mysql-test/main/type_date.result')
-rw-r--r-- | mysql-test/main/type_date.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/type_date.result b/mysql-test/main/type_date.result index 897f42a2ec4..6d955ef698c 100644 --- a/mysql-test/main/type_date.result +++ b/mysql-test/main/type_date.result @@ -962,5 +962,31 @@ Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where coalesce(<cache>(DATE'2001-01-02'),`test`.`t1`.`a`) <=> coalesce(DATE'2001-01-01',`test`.`t1`.`a`) DROP TABLE t1; # +# MDEV-15406 NO_ZERO_IN_DATE erroneously affects how CAST(AS DATE) warns about fractional digit truncation +# +SET sql_mode=''; +CREATE TABLE t1 (a DATE); +SELECT CAST(20061108.01 AS DATE); +CAST(20061108.01 AS DATE) +2006-11-08 +Warnings: +Note 1292 Truncated incorrect datetime value: '20061108.01' +INSERT INTO t1 VALUES (20061108.01); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +SET sql_mode=NO_ZERO_IN_DATE; +SELECT CAST(20061108.01 AS DATE); +CAST(20061108.01 AS DATE) +2006-11-08 +Warnings: +Note 1292 Truncated incorrect datetime value: '20061108.01' +CREATE TABLE t1 (a DATE); +INSERT INTO t1 VALUES (20061108.01); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +SET sql_mode=DEFAULT; +# # End of 10.4 tests # |