Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.0.2, 6.5.0, Cheshire-Cat
-
Untriaged
-
Unknown
Description
CREATE INDEX ix20 ON default ( DISTINCT ARRAY r.bid FOR r IN responses END, _type, createdAt) ; |
|
EXPLAIN SELECT RAW meta().id
|
FROM `default` |
WHERE `_type` = 'AppLead' |
AND `createdAt` >= '2019-08-28' |
AND ANY `item` IN `responses` SATISFIES `item`.`bid` = 'BidRegistration::1234' END; |
|
EXPLAIN SELECT RAW meta().id
|
FROM `default` |
WHERE `_type` = $q1
|
AND `createdAt` >= $q2
|
AND ANY `item` IN `responses` SATISFIES `item`.`bid` = $q3 END;
|
|
\set -$q1 'AppLead'; |
\set -$q2 '2019-08-28'; |
\set -$q3 'BidRegistration::1234'; |
|
EXPLAIN SELECT RAW meta().id
|
FROM `default` |
WHERE `_type` = $q1
|
AND `createdAt` >= $q2
|
AND ANY `item` IN `responses` SATISFIES `item`.`bid` = $q3 END;
|
First 2 queries are covered . When query parameters are set and run query (adhoc=true) It is not choosing covering path when the Implicit Array index.