diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-08-05 15:25:31 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-08-05 15:25:31 +0400 |
commit | 6b48bdf269cb86e95e1655d28d2f32443918b4fa (patch) | |
tree | 186109f50c4e68f832d36d2783715ba2e90fb6c6 /mysql-test/main/func_hybrid_type.test | |
parent | e1e142e7fca77f24a26a789fd6116896391e852a (diff) | |
download | mariadb-git-6b48bdf269cb86e95e1655d28d2f32443918b4fa.tar.gz |
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
Diffstat (limited to 'mysql-test/main/func_hybrid_type.test')
-rw-r--r-- | mysql-test/main/func_hybrid_type.test | 10 |
1 files changed, 10 insertions, 0 deletions
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 @@ -711,5 +711,15 @@ 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 # |