diff options
Diffstat (limited to 'mysql-test/main/type_datetime.result')
-rw-r--r-- | mysql-test/main/type_datetime.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/type_datetime.result b/mysql-test/main/type_datetime.result index b23fa762c73..5b27d02d28f 100644 --- a/mysql-test/main/type_datetime.result +++ b/mysql-test/main/type_datetime.result @@ -1330,6 +1330,18 @@ a 2000-10-00 00:00:00 DROP TABLE t1; # +# MDEV-21619 Server crash or assertion failures in my_datetime_to_str +# +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'; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 range f f 6 NULL 1 100.00 Using where; Using index +Warnings: +Warning 1292 Truncated incorrect datetime value: '1995.0000000' +Note 1003 select `test`.`t1`.`f` AS `f` from `test`.`t1` where '0000-00-00 00:00:00.000000' between `test`.`t1`.`f` and <cache>('2012-12-12') +DROP TABLE t1; +# # End of 10.2 tests # # |