Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5(EOL)
-
None
Description
The outpu of the EXPLAIN command for the query
( select * from t1 |
where (f1 is null and f2 is null) and (f2 between 'a' and 'z' or f1 in ('a'))) |
union
|
( select * from t1 |
where (f1 is null and f2 is null) and (f2 between 'a' and 'z' or f1 in ('a'))); |
contains the line:
1 PRIMARY t1 ref|filter f1,f2 f1|f1 13|13 const 1 (2%) Using index condition; Using where; Using rowid filtter
|
.
It means that a range rowid filter fir index on f1 is used for ref access by the same index. Expected either ref f1, or ref|filter f1|f2, or ref|filter f2|f1.