diff options
Diffstat (limited to 'mysql-test/main/type_date.result')
-rw-r--r-- | mysql-test/main/type_date.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/main/type_date.result b/mysql-test/main/type_date.result index fbf348c1a2f..aa5d6ccadc1 100644 --- a/mysql-test/main/type_date.result +++ b/mysql-test/main/type_date.result @@ -924,6 +924,24 @@ DROP TABLE t1; # End of 10.1 tests # # +# Start of 10.2 tests +# +# +# MDEV-21619 Server crash or assertion failures in my_datetime_to_str +# +CREATE TABLE t1 (f DATE, KEY(f)); +INSERT INTO t1 VALUES ('2020-01-01'),('2020-01-02'); +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 4 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' between `test`.`t1`.`f` and <cache>('2012-12-12') +DROP TABLE t1; +# +# End of 10.2 tests +# +# # Start of 10.3 tests # # |