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