diff options
Diffstat (limited to 'mysql-test/main/func_in.result')
| -rw-r--r-- | mysql-test/main/func_in.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/func_in.result b/mysql-test/main/func_in.result index 4627208d..b3865bab 100644 --- a/mysql-test/main/func_in.result +++ b/mysql-test/main/func_in.result @@ -531,6 +531,8 @@ Warning 1292 Truncated incorrect DECIMAL value: 'b' explain select f1 from t1 where f1 in (2,1); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index t1f1_idx t1f1_idx 2 NULL 3 Using where; Using index +Warnings: +Note 1105 Cannot use key `t1f1_idx` part[0] for lookup: `test`.`t1`.`f1` of type `char` = "2" of type `int` create table t2(f2 int, index t2f2(f2)); insert into t2 values(0),(1),(2); select f2 from t2 where f2 in ('a',2); |