Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-84438

Improve rewrites of filters on time-series as bucket-level predicates

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Integration

    Description

      For SERVER-84130 we had to remove the bucket-level filter with internal LT(E) comparisons. While required for query correctness, the check could be more narrow, for example, in a conjunction with GT(E) it would be still correct to use the LT(E) optimization as the GT(E) would cut off the problematic events with the missing field.

      In general, the rewrites of predicates at bucket level might benefit from a more systemic review & refactor – we've seen a few post-release bugs immediately in the area: SERVER-79585, SERVER-84130, SERVER-84207, as well as in integration with other pipeline optimizations: SERVER-79692, SERVER-79637. The code is complex and the logic is spread across multiple helper functions with numerous arguments (~10) in multiple files. The entry point is around createPredicatesOnBucketLevelField().

      Attachments

        Activity

          People

            backlog-query-integration Backlog - Query Integration
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: