Write a targeted PBT to test $match-splitting optimizations

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      This ticket was originally to write a PBT that runs queries targeted to hit the new $expr-splitting optimization from SERVER-106505.

      However, it’s clear that a more general PBT testing $match-splitting optimizations more generally would be beneficial. This PBT would compare the results of those queries when running against a server with optimizations enabled and a server with optimizations disabled.

      We could start by implementing this PBT to specifically cover $match splitting past a renaming stage.  The queries could have a computing/renaming operation following by a $match, For example:

      [{$project|$group|$addFields: {...}}, {$match: {...}}] 

       

            Assignee:
            Unassigned
            Reporter:
            Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated: