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

[CQF] Simplify explain for evaluation of simple constants

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 7.0.0-rc0
    • None
    • None
    • None
    • Query Optimization
    • Fully Compatible
    • QO 2023-02-20

    Description

      SERVER-72233 simplified the explain output for Evaluation nodes to concisely list projections at the top level. We can simplify that output further in cases where the only node in the Evaluation path is a simple constant or variable.

      For example, what is currently printed as

      Evaluation [{val_prev}]
      |     Variable [valIn]
      

      could be simplified to

      Evaluation[{val_prev = valIn}]
      

      and what is current printed asĀ 

      Evaluation [{val_prev}]
      |     Const [1]
      

      could be simplified to

      Evaluation[{val_prev = 1}]
      

      Attachments

        Activity

          People

            svilen.mihaylov@mongodb.com Svilen Mihaylov (Inactive)
            will.buerger@mongodb.com Will Buerger
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: