Description
The planner should optimize the following:
WHERE FALSE => skip Index Scan.
WHERE TRUE => skip planning, use Primary Scan.
SELECT META().id FROM xxx => use primary index as covering index, skip Fetch.
DELETE FROM xxx => use primary index as covering index, skip Fetch.
Attachments
For Gerrit Dashboard: MB-19443 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
63544,2 | MB-19443. Optimize WHERE FALSE, WHERE TRUE, and SELECT META().id. | master | query | Status: MERGED | +2 | +1 |