diff options
author | Alexander Barkov <bar@mariadb.org> | 2015-09-09 08:11:43 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2015-09-09 08:11:43 +0400 |
commit | 3fcd84c2891f4d2c881f13b53bc5a2401870b80a (patch) | |
tree | 1067f1078692f89744bb67e5b83a84061fcc2fee /mysql-test/r/type_int.result | |
parent | 4cb6edba780085cbb82ef5fce2298f7df5fa0169 (diff) | |
download | mariadb-git-3fcd84c2891f4d2c881f13b53bc5a2401870b80a.tar.gz |
MDEV-8741 Equal field propagation leaves some remainders after simplifying WH ERE zerofill_column=2010 AND zerofill_column>=2010
Diffstat (limited to 'mysql-test/r/type_int.result')
-rw-r--r-- | mysql-test/r/type_int.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/type_int.result b/mysql-test/r/type_int.result new file mode 100644 index 00000000000..b52c26b6851 --- /dev/null +++ b/mysql-test/r/type_int.result @@ -0,0 +1,17 @@ +# +# Start of 10.1 tests +# +# +# MDEV-8741 Equal field propagation leaves some remainders after simplifying WHERE zerofill_column=2010 AND zerofill_column>=2010 +# +CREATE TABLE t1 (a INT ZEROFILL); +INSERT INTO t1 VALUES (2010),(2020); +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=2010 AND a>=2010; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +Warnings: +Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = 2010) +DROP TABLE t1; +# +# End of 10.1 tests +# |