Query sampling should store the "let" field for each read query

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 7.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • ALL
    • Sharding NYC 2023-04-03
    • 43
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently, only the filter and collation are stored. So for a find and aggregate query whose filter refers to variables defined in "let" or "runtimeConstants" (e.g. here), the analyzeShardKey command wouldn't be able to evaluate the filter and do the synthetic routing. This would cause the command to fail with a PlanExecutor error just as shown in BF-28087.

            Assignee:
            Cheahuychou Mao
            Reporter:
            Cheahuychou Mao
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: