diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-08-06 10:53:55 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-08-06 10:53:55 +0400 |
commit | 13f36fffeaecf316435fc497b0f3ae2a5d58d749 (patch) | |
tree | 96e50a09c675ae0a1322a7c9626683ba380119b1 /mysql-test | |
parent | c99f9766b11bda7eb15d6875f2f1e64c2d01b461 (diff) | |
download | mariadb-git-13f36fffeaecf316435fc497b0f3ae2a5d58d749.tar.gz |
MDEV-19301 Assertion `!is_valid_datetime() || fraction_remainder(((item->decimals) < (6) ? (item->decimals) : (6))) == 0' failed in Datetime_truncation_not_needed::Datetime_truncation_not_needed
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/main/type_date.result | 15 | ||||
-rw-r--r-- | mysql-test/main/type_date.test | 8 |
2 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/main/type_date.result b/mysql-test/main/type_date.result index c5c892b5e4d..a9d17b8eb83 100644 --- a/mysql-test/main/type_date.result +++ b/mysql-test/main/type_date.result @@ -1025,5 +1025,20 @@ INSERT INTO t1 SELECT * FROM t2; DROP TABLE t1,t2; SET sql_mode=DEFAULT; # +# MDEV-19301 Assertion `!is_valid_datetime() || fraction_remainder(((item->decimals) < (6) ? (item->decimals) : (6))) == 0' failed in Datetime_truncation_not_needed::Datetime_truncation_not_needed +# +SELECT NULLIF(CAST(1012.5 AS DATE), 1); +NULLIF(CAST(1012.5 AS DATE), 1) +2000-10-12 +Warnings: +Note 1292 Truncated incorrect date value: '1012.5' +Warning 1292 Truncated incorrect datetime value: '1' +Note 1292 Truncated incorrect date value: '1012.5' +SELECT CAST(1012.5 AS DATE) * 1.0; +CAST(1012.5 AS DATE) * 1.0 +20001012.0 +Warnings: +Note 1292 Truncated incorrect date value: '1012.5' +# # End of 10.4 tests # diff --git a/mysql-test/main/type_date.test b/mysql-test/main/type_date.test index 4639c004740..d795a01fd36 100644 --- a/mysql-test/main/type_date.test +++ b/mysql-test/main/type_date.test @@ -692,5 +692,13 @@ SET sql_mode=DEFAULT; --echo # +--echo # MDEV-19301 Assertion `!is_valid_datetime() || fraction_remainder(((item->decimals) < (6) ? (item->decimals) : (6))) == 0' failed in Datetime_truncation_not_needed::Datetime_truncation_not_needed +--echo # + +SELECT NULLIF(CAST(1012.5 AS DATE), 1); +SELECT CAST(1012.5 AS DATE) * 1.0; + + +--echo # --echo # End of 10.4 tests --echo # |