Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.2, 7.2.6
-
Untriaged
-
0
-
Yes
Description
CREATE INDEX ix20 ON default(ALL a1) WHERE type = "docs";
|
SELECT d1, d2.id, d2.c2
|
FROM default AS d1 USE KEYS "2345234"
|
LEFT JOIN default AS d2 ON d2.type = "docs" AND ANY id IN d2.a1 SATISFIES id = META(d1).id END ;
|
"errors": [
|
{
|
"code": 4000,
|
"msg": "Sargable index not sarged; pred=(((`d2`.`type`) = \"docs\") and any `id` in (`d2`.`a1`) satisfies (`id` = (meta(`d1`).`id`)) end), sarg_keys=[(all ((`d2`.`a1`)))], error=Plan error: sarg.VisitAny: unexpected array id (0) for ANY expression any `id` in (`d2`.`a1`) satisfies (`id` = (meta(`d1`).`id`)) end"
|
}
|
]
|
Works 7.2.3
Regression in 7.2.6, 7.6.2 due to MB-61549
Attachments
Issue Links
- is caused by
-
MB-61549 Multiple ANY clause on FLATTEN array index gives wrong results
- Closed
For Gerrit Dashboard: MB-63163 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
214566,4 | MB-63163 Make sure arrayId is properly assigned ... ... for ON-clauses of outer joins | trinity | query | Status: MERGED | +2 | +1 |
214614,4 | MB-63163: [BP 7.2.6] Make sure arrayId is properly assigned ... ... for ON-clauses of outer joins | neo | query | Status: MERGED | +2 | +1 |
214959,3 | MB-63274 Unit test updates | neo | query | Status: MERGED | +2 | +1 |