Description
During ORDER BY pushdown, the query planner ignores equality predicates and constants in the ORDER BY keys.
These equality and constant keys should be removed from the ORDER BY clause in advance, so that OrderedIntersectScan and sorting are not performed unnecessarily.
Transform this.order in build_select_sub.go (make a copy and transform the copy), before calling buildScan().
Attachments
Issue Links
- blocks
-
MB-22188 4.6.2 Minor Release
- Closed
For Gerrit Dashboard: MB-22412 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
72288,2 | MB-22412. Skip fixed order terms. | master | query | Status: MERGED | +2 | +1 |
72291,2 | MB-22412. Do not skip aggregate keys in ORDER BY. | master | query | Status: MERGED | +2 | +1 |
73395,2 | MB-22412. Skip fixed order terms. | watson++ | query | Status: MERGED | +2 | +1 |
73396,2 | MB-22412. Do not skip aggregate keys in ORDER BY. | watson++ | query | Status: MERGED | +2 | +1 |
76420,4 | CBQE-4050/CBQE-3995: Added test cases for MB-22412 and MB-22321. Fixed nulls_gsi. Fixed test_ins_spans in watson | watson | testrunner | Status: MERGED | +2 | +1 |
76438,3 | CBQE-4050/CBQE-3995: Added test cases for MB-22412 and MB-22321. Fixed nulls_gsi in spock | master | testrunner | Status: MERGED | +2 | +1 |