diff options
Diffstat (limited to 'mysql-test/t/type_year.test')
-rw-r--r-- | mysql-test/t/type_year.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/type_year.test b/mysql-test/t/type_year.test index 685587fe3c5..d9fa2af1eb4 100644 --- a/mysql-test/t/type_year.test +++ b/mysql-test/t/type_year.test @@ -188,3 +188,25 @@ drop table t1; drop function y2k; +--echo # +--echo # Start of 10.1 tests +--echo # + +--echo # +--echo # MDEV-8741 Equal field propagation leaves some remainders after simplifying WHERE zerofill_column=2010 AND zerofill_column>=2010 +--echo # +CREATE TABLE t1 (a YEAR); +INSERT INTO t1 VALUES (2010),(2020); +SELECT * FROM t1 WHERE a=2010 AND a>=2010; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=2010 AND a>=2010; +SELECT * FROM t1 WHERE a=2010 AND a>=10; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=2010 AND a>=10; +SELECT * FROM t1 WHERE a=10 AND a>=2010; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=10 AND a>=2010; +SELECT * FROM t1 WHERE a=10 AND a>=10; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=10 AND a>=10; +DROP TABLE t1; + +--echo # +--echo # End of 10.1 tests +--echo # |