Details
-
Bug
-
Resolution: Fixed
-
Major
-
4.6.2, 4.6.3
-
Untriaged
-
Unknown
Description
create index ix300 on default (all addr); |
explain SELECT v.seqno FROM default USE index (ix300) UNNEST default.messages AS v WHERE v.seqno > 1; |
Unnest Expression doesn't match with array expression of the index.
This causes wrong results
Workaround not to create any simplified array index in 4..6.3 instead create full array index syntax like ix301.
create index ix301 on default (all ARRAY v FOR v IN add END); |
|
Attachments
Issue Links
- relates to
-
MB-25568 Unnest Scan considers wrong array index
- Closed