Critical Description
filter condition is depends on multiple unnests
CREATE INDEX ix22 ON default( (ALL ARRAY (ALL ARRAY [op.name,op.val,x] FOR op IN x END) FOR x IN a1 END )); |
|
|
EXPLAIN SELECT [op.name,op.val,x]
|
FROM default AS d UNNEST d.a1 AS x |
UNNEST x AS op
|
WHERE [op.name,op.val,x] = ["type2", "bla","xxx"] ; |
|
Above query is not using the index mentioned above.
Attachments
| For Gerrit Dashboard: MB-30292 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 96286,3 | MB-30292 Multiple level of unnest does not properly use sargable predicate | master | query | Status: MERGED | +2 | +1 |
| 96301,2 | MB-30292 Multiple level of unnest does not properly use sargable predicate | vulcan | query | Status: MERGED | +2 | +1 |