Details
Description
CREATE INDEX ix20 ON default (ALL `arr1`, `c1`, `c2`) WHERE `type` = 'doc';
|
CREATE INDEX ix21 ON default(`c3`, DISTINCT ARRAY `v1`.`ac1` FOR `v1` IN `arr1` END) WHERE `type` = 'doc';
|
SELECT RAW META().id
|
FROM default
|
WHERE type = 'doc'
|
AND ANY v1 IN arr1 SATISFIES ((v1.ac1 IS NOT VALUED OR v1.ac1 in [1])) END
|
AND c2 IS NOT VALUED
|
AND c3 IN [2];
|
"errors": [
|
{
|
"code": 4000,
|
"msg": "Sargable index not sarged; pred=(((((`default`.`type`) = \"doc\") and any `v1` in (`default`.`arr1`) satisfies (((`v1`.`ac1`) is not valued) or ((`v1`.`ac1`) in [1])) end) and ((`default`.`c2`) is not valued)) and ((`default`.`c3`) in [2])), sarg_keys=[(all ((`default`.`arr1`)))], error=\u003cnil\u003e"
|
}
|
],
|
"status": "fatal",
|
Attachments
Issue Links
For Gerrit Dashboard: MB-54952 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
184482,2 | MB-54952 Allow WHOLE_SPANS to be generated for leading array index key | master | query | Status: MERGED | +2 | +1 |
184547,3 | MB-54952 Proper determination of sargability for array index in simplified form | master | query | Status: MERGED | +2 | +1 |
184601,2 | MB-54952 Modify fix | master | query | Status: MERGED | +2 | +1 |