diff options
Diffstat (limited to 'mysql-test/main/range_notembedded.result')
| -rw-r--r-- | mysql-test/main/range_notembedded.result | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/main/range_notembedded.result b/mysql-test/main/range_notembedded.result index b3d2dfbb43b..d774c81d6e1 100644 --- a/mysql-test/main/range_notembedded.result +++ b/mysql-test/main/range_notembedded.result @@ -13,7 +13,7 @@ set @tmp_21958=@@optimizer_trace; set optimizer_trace=1; explain select * from t2 where key1 in (1,2,3) and pk not in (1,2,3); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 ALL PRIMARY,key1 NULL NULL NULL 5 Using where +1 SIMPLE t2 range PRIMARY,key1 key1 5 NULL 3 Using index condition # This should show only ranges in form "(1) <= (key1) <= (1)" # ranges over "pk" should not be constructed. select json_detailed(JSON_EXTRACT(trace, '$**.ranges')) @@ -24,6 +24,12 @@ json_detailed(JSON_EXTRACT(trace, '$**.ranges')) "(1) <= (key1) <= (1)", "(2) <= (key1) <= (2)", "(3) <= (key1) <= (3)" + ], + + [ + "(1) <= (key1) <= (1)", + "(2) <= (key1) <= (2)", + "(3) <= (key1) <= (3)" ] ] set optimizer_trace=@tmp_21958; |