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/main/type_date.result | |
| 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/main/type_date.result')
| -rw-r--r-- | mysql-test/main/type_date.result | 15 |
1 files changed, 15 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 # |