diff options
Diffstat (limited to 'mysql-test/r/func_encrypt.result')
| -rw-r--r-- | mysql-test/r/func_encrypt.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/func_encrypt.result b/mysql-test/r/func_encrypt.result index 91ff4e218fb..f5e03a90327 100644 --- a/mysql-test/r/func_encrypt.result +++ b/mysql-test/r/func_encrypt.result @@ -190,3 +190,21 @@ insert into t1 values (null,'contraction\'s'); insert into t1 values (-15818,'requirement\'s'); select encrypt(f1,f2) as a from t1,(select encrypt(f1,f2) as b from t1) a; drop table t1; +# +# Start of 10.1 tests +# +# +# MDEV-8369 Unexpected impossible WHERE for a condition on a ZEROFILL field +# +CREATE TABLE t1 (a INT(6) ZEROFILL); +INSERT INTO t1 VALUES (1),(2); +EXPLAIN EXTENDED +SELECT * FROM t1 WHERE a=1 AND DES_ENCRYPT('test',a)=_latin1 'abc' COLLATE latin1_bin; +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` = 1) and (des_encrypt('test',`test`.`t1`.`a`) = 'abc')) +DROP TABLE t1; +# +# End of 10.1 tests +# |