diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-06-13 19:01:28 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-06-13 19:01:28 +0300 |
| commit | 805340936aa47493886bafd119863d83c475f45c (patch) | |
| tree | 46e5a4bd2e8311ef2880caa0526ce705a40c925e /mysql-test/main/type_date.result | |
| parent | f9e53a659c87f1147d4f6d004702077d4d0ce5d7 (diff) | |
| parent | d83a4432503d199f6aed8e378563b08471d090dc (diff) | |
| download | mariadb-git-805340936aa47493886bafd119863d83c475f45c.tar.gz | |
Merge 10.3 into 10.4
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..616ba0a4529 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 index f f 4 NULL 2 50.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 # # |