Description
|
INSERT INTO default VALUES("k200",{"messages":[{"seqno":100,"id":"abc"}]}); |
CREATE INDEX ix200 ON default(ALL ARRAY v.seqno FOR v IN messages END); |
|
SELECT v.seqno FROM default UNNEST default.messages AS v WHERE v.id = "abc" AND v.seqno > 1; |
-- Above query returns 0 results instead of 1 and uses ix200 and should n't be using cover fetch the data. |
|
|
Attachments
Issue Links
- mentioned in
-
Page Loading...
For Gerrit Dashboard: MB-25388 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
81309,2 | MB-25388. Check Unnest predicate is covered by index | master | query | Status: MERGED | +2 | +1 |
81311,2 | MB-25388. Check Unnest predicate is covered by index | watson | query | Status: MERGED | +2 | +1 |
81549,2 | MB-25388. Unnest make cover | master | query | Status: MERGED | +2 | +1 |
81554,2 | MB-25388. Unnest make cover | watson | query | Status: MERGED | +2 | +1 |
81857,3 | MB-25388. Fix regressions | master | query | Status: MERGED | +2 | +1 |
81873,2 | MB-25388. Fix regressions | watson | query | Status: MERGED | +2 | +1 |
81923,3 | MB-25388. Fix another regression | master | query | Status: MERGED | +2 | +1 |
81948,2 | MB-25388. Fix another regression | watson | query | Status: MERGED | +2 | +1 |