Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
7.1.0
-
None
-
1
Description
create index ix20 on default(DISTINCT c1,c2);
explain SELECT 1 from default where ANY v IN c1 SATISFIES v = 10 AND c2 = 20 END;
c2 = 20 should able to sargable and push to indexer. If moved outside ANY it does.
subset/sargable/sarg should handle combinations of (normal key/arraykey, normal predicate/ANY/ANY AND EVERY SATISFIES)