From 6b48bdf269cb86e95e1655d28d2f32443918b4fa Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Mon, 5 Aug 2019 15:25:31 +0400 Subject: MDEV-18456 Assertion `item->maybe_null' failed in Type_handler_temporal_result::make_sort_key Adding tests only. This problem was earlier fixed in 10.4 by MDEV-17325 and backported to 10.3 with this commit: f4019f5b3544a18f3ddf32df2c5214c3f8dabdce --- mysql-test/main/func_hybrid_type.test | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'mysql-test/main/func_hybrid_type.test') diff --git a/mysql-test/main/func_hybrid_type.test b/mysql-test/main/func_hybrid_type.test index 9736485bb9f..7d986130d7f 100644 --- a/mysql-test/main/func_hybrid_type.test +++ b/mysql-test/main/func_hybrid_type.test @@ -710,6 +710,16 @@ SHOW CREATE TABLE t1; DROP TABLE t1; SET sql_mode=DEFAULT; +--echo # +--echo # MDEV-18456 Assertion `item->maybe_null' failed in Type_handler_temporal_result::make_sort_key +--echo # + +CREATE TABLE t1 (t TIME NOT NULL); +INSERT INTO t1 VALUES ('00:20:11'),('14:52:05'); +SELECT GREATEST('9999', t) FROM t1 ORDER BY 1; +DROP TABLE t1; + + --echo # --echo # End of 10.3 tests --echo # -- cgit v1.2.1