Description
Given
CREATE INDEX idx ON default( DISTINCT ARRAY p FOR p IN PAIRS( SELF ) END ); |
|
SELECT META( d ).id |
FROM default d |
WHERE
|
ANY p IN PAIRS( d ) SATISFIES p = [ "name", "John" ] END |
AND AND p IN PAIRS( d ) SATISFIES p = [ "age", 30 ] END; |
We need to generate a span for each AND term and intersect the results.
Attachments
Issue Links
- blocks
-
MB-22188 4.6.2 Minor Release
- Closed
For Gerrit Dashboard: MB-22195 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
71615,3 | MB-22195. Intersect AND terms for dynamic index. | master | query | Status: MERGED | +2 | +1 |
71622,2 | MB-22195. Intersect AND terms for dynamic index. | master | query | Status: MERGED | +2 | +1 |
71777,14 | MB-22223, MB-22195, MB-22107. Planner reorg to support combinations of intersection and union scans. | master | query | Status: MERGED | +2 | +1 |
73363,2 | MB-22195. Intersect AND terms for dynamic index. | watson++ | query | Status: MERGED | +2 | +1 |
73364,2 | MB-22195. Intersect AND terms for dynamic index. | watson++ | query | Status: MERGED | +2 | +1 |
73371,2 | MB-22223, MB-22195, MB-22107. Planner reorg to support combinations of intersection and union scans. | watson++ | query | Status: MERGED | +2 | +1 |