summaryrefslogtreecommitdiff
path: root/mysql-test/main/type_timestamp.result
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2019-02-14 22:07:33 -0800
committerIgor Babaev <igor@askmonty.org>2019-02-14 22:07:33 -0800
commit98d55b1366746a2b4750da9e8781f66b0d01ed85 (patch)
treeff062a3ec4e6a760d5c45e9db4f1fd292cfadbbe /mysql-test/main/type_timestamp.result
parentccce4d3be9bb5dfce66576f9744bcb927b754cf4 (diff)
parent282ba973e748456a829eecf1b49fb352870c6a8f (diff)
downloadmariadb-git-98d55b1366746a2b4750da9e8781f66b0d01ed85.tar.gz
Merge branch '10.4' into bb-10.4-mdev16188
Diffstat (limited to 'mysql-test/main/type_timestamp.result')
-rw-r--r--mysql-test/main/type_timestamp.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/type_timestamp.result b/mysql-test/main/type_timestamp.result
index 57fdcdf9af9..eda01d67ec7 100644
--- a/mysql-test/main/type_timestamp.result
+++ b/mysql-test/main/type_timestamp.result
@@ -1176,5 +1176,14 @@ NULL
NULL
DROP TABLE t1, t2, t3;
#
+# MDEV-18447 Assertion `!is_zero_datetime()' failed in Timestamp_or_zero_datetime::tv
+#
+CREATE TABLE t1 (a TIMESTAMP DEFAULT 0, b TIMESTAMP DEFAULT 0, c TIME DEFAULT 0);
+INSERT INTO t1 VALUES (0,0,0);
+SELECT c IN (GREATEST(a,b)) FROM t1;
+c IN (GREATEST(a,b))
+0
+DROP TABLE t1;
+#
# End of 10.4 tests
#