diff options
Diffstat (limited to 'mysql-test/main/type_timestamp.result')
-rw-r--r-- | mysql-test/main/type_timestamp.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/type_timestamp.result b/mysql-test/main/type_timestamp.result index 70e55f2d595..c2af8952f4f 100644 --- a/mysql-test/main/type_timestamp.result +++ b/mysql-test/main/type_timestamp.result @@ -1152,5 +1152,17 @@ f NULL DROP TABLE t1; # +# MDEV-18145 Assertion `0' failed in Item::val_native upon SELECT subquery with timestamp +# +CREATE TABLE t1 (a INT) ENGINE=MyISAM; +CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=MyISAM; +INSERT INTO t2 VALUES (1),(2); +CREATE TABLE t3 (pk INT PRIMARY KEY, b TIMESTAMP) ENGINE=MyISAM; +SELECT ( SELECT b FROM t1 LIMIT 1 ) AS sq FROM t2 LEFT JOIN t3 USING (pk); +sq +NULL +NULL +DROP TABLE t1, t2, t3; +# # End of 10.4 tests # |