Details
-
Bug
-
Resolution: Unresolved
-
Major
-
5.5.6, 6.0.3, 6.5.0
-
None
-
Untriaged
-
Unknown
Description
create index ix10 on default(status) WHERE status is not missing and type = "hotel"; |
explain select 1 from default where type = "hotel" AND status in [$s1]; |
The above query not able to choose index. Below queries able to choose.
status IN [$s1] mean implicitly status IS NOT MISSING.
explain select 1 from default where type = "hotel" AND status in [$s1] and status is not missing; |
explain select 1 from default where type = "hotel" AND status in $s1; |
|