diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-12-12 10:39:06 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-12-12 10:39:06 +0400 |
commit | c353b2a8fc10e16107ee6c7e26877f4243d4eaef (patch) | |
tree | 6bb3d15613d83be28e8720f25ba4072bdbe0582f /mysql-test/main/type_timestamp.result | |
parent | 4abb8216a054e14afbeb81e8529e02bab6fa14ac (diff) | |
download | mariadb-git-c353b2a8fc10e16107ee6c7e26877f4243d4eaef.tar.gz |
--echo #
--echo # MDEV-17979 Assertion `0' failed in Item::val_native upon SELECT with timestamp, NULLIF, GROUP BY
--echo #
Diffstat (limited to 'mysql-test/main/type_timestamp.result')
-rw-r--r-- | mysql-test/main/type_timestamp.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/type_timestamp.result b/mysql-test/main/type_timestamp.result index 20f258ea261..439532131cc 100644 --- a/mysql-test/main/type_timestamp.result +++ b/mysql-test/main/type_timestamp.result @@ -1118,5 +1118,16 @@ ERROR 22007: Incorrect datetime value: '0000-00-00 00:00:00' for column 'a' at r DROP TABLE t1; SET sql_mode=DEFAULT; # +# MDEV-17979 Assertion `0' failed in Item::val_native upon SELECT with timestamp, NULLIF, GROUP BY +# +CREATE TABLE t1 (a INT, b TIMESTAMP) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1,'2018-06-19 00:00:00'); +SELECT NULLIF(b, 'N/A') AS f, MAX(a) FROM t1 GROUP BY f; +f MAX(a) +2018-06-19 00:00:00 1 +Warnings: +Warning 1292 Truncated incorrect datetime value: 'N/A' +DROP TABLE t1; +# # End of 10.4 tests # |