summaryrefslogtreecommitdiff
path: root/mysql-test/main/type_datetime.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2020-06-13 15:11:43 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2020-06-13 15:11:43 +0300
commitd83a4432503d199f6aed8e378563b08471d090dc (patch)
tree4982259fb773f1d1e627e010fba0f58a10e82a13 /mysql-test/main/type_datetime.test
parent6c30bc2181328ea619d1ab61a464feb0514bf12a (diff)
parentb68f1d847f1fc00eed795e20162effc8fbc4119b (diff)
downloadmariadb-git-d83a4432503d199f6aed8e378563b08471d090dc.tar.gz
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/type_datetime.test')
-rw-r--r--mysql-test/main/type_datetime.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/type_datetime.test b/mysql-test/main/type_datetime.test
index 60b30121559..41913638474 100644
--- a/mysql-test/main/type_datetime.test
+++ b/mysql-test/main/type_datetime.test
@@ -837,6 +837,15 @@ ALTER TABLE t1 MODIFY a DATETIME;
SELECT * FROM t1;
DROP TABLE t1;
+--echo #
+--echo # MDEV-21619 Server crash or assertion failures in my_datetime_to_str
+--echo #
+
+CREATE TABLE t1 (f DATETIME, KEY(f));
+INSERT INTO t1 VALUES ('2020-01-01 00:00:00'),('2020-01-02 00:00:00');
+EXPLAIN EXTENDED SELECT * FROM t1 WHERE 1995.0000000 BETWEEN f AND '2012-12-12';
+DROP TABLE t1;
+
--echo #
--echo # End of 10.2 tests