Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.5.4, 6.0.2, 6.5.0
-
Untriaged
-
Unknown
Description
CREATE INDEX `ix2` ON `default`(distinct array (distinct array `p`.`relevancia` for `p` in `c`.`palabras` end) for `c` in `conclusiones` end) ; |
|
The following covers
EXPLAIN SELECT META().id FROM default AS r WHERE ANY c IN r.conclusiones SATISFIES ANY p IN c.palabras SATISFIES p.relevancia > 50 END END; |
|
The following is not covering
EXPLAIN SELECT META().id FROM default AS r WHERE ANY conclusion IN r.conclusiones SATISFIES ANY p IN conclusion.palabras SATISFIES p.relevancia > 50 END END; |
|
Attachments
Issue Links
- relates to
-
MB-35732 back out fixes in index covering determination
- Closed
For Gerrit Dashboard: MB-34660 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
110964,2 | MB-34660 Properly set identifier as binding variable in renamer | master | query | Status: MERGED | +2 | +1 |
110966,2 | MB-34660 Properly set identifier as binding variable in renamer | alice | query | Status: MERGED | +2 | +1 |
110967,2 | MB-34660 Properly set identifier as binding variable in renamer | vulcan | query | Status: MERGED | +2 | +1 |
113978,3 | MB-35732 Backout previous fixes in index covering determination | vulcan | query | Status: MERGED | +2 | +1 |