[SERVER-64235] Last point TS Opt M3: Query rewrite for two {+-meta, +ts} cases Created: 04/Mar/22 Updated: 29/Oct/23 Resolved: 21/Mar/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0-rc0 |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Steve Tarzia | Assignee: | Alya Berciu |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||
| Participants: | |||||||||||||
| Linked BF Score: | 178 | ||||||||||||
| Description |
|
Implement the appropriate query rewrite the 2 remaining cases with {+-meta, +ts}. Assuming that we extend the indexes to both (min,max) and (max,min) the rewrites become: For reference, here's the case we already did in Milestone :2
translates to:
This is adapted as follows:
This tickets covers the last two rows above.
|
| Comments |
| Comment by Githook User [ 21/Mar/22 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}Message: |
| Comment by Alya Berciu [ 16/Mar/22 ] |
|
Reverting/reopening this to resolve the following BFs: BF-24629 BF-24638 BF-24630 |
| Comment by Githook User [ 16/Mar/22 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}Message: Revert " This reverts commit 811dc428a93105d0aa9091ca20e4dfb120e4e57d. |
| Comment by Githook User [ 15/Mar/22 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alyacarina@gmail.com', 'username': 'alyacb'}Message: |