Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.2.0
-
Untriaged
-
0
-
Unknown
-
Analytics CBO Sprint 12, Analytics CBO Sprint 13
Description
Here is the query
explain select count ( * ) from KS1 x where uniq_i > 50 and uniq_i < 60 and (ANY and EVERY v IN x.uarr_i satisfies v > 384 END) and (ANY v IN x.zarr_i satisfies v >= 0 END) and (ANY v IN x.zarr_i satisfies v >= 0 END)
The problem goes away if the ANY and EVERY predicate is also a ANY IN predicate.
Problem may be that for the above query there are two selects above the ANY AND EVERY subplan. My code expects only one.
This is with the CBO code.
Attachments
Issue Links
- links to