Recover from query settings application failure on queries containing min/max fields.

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.1.0-rc0, 8.0.0-rc2
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • Fully Compatible
    • ALL
    • v8.0
    • QE 2024-04-15, QE 2024-04-29
    • 47
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Min/max queries require explicit index cursor hints. The presence of query settings will cause the planning system to ignore cursor hints, and throw an unnamed error code, different than NoQueryExecutionPlans.

      As the query settings fallback mechanism only works on NoQueryExecutionPlans errors, this min/max error will bypass the retry, making the query fail even if a cursor hint is present.

            Assignee:
            Catalin Sumanaru
            Reporter:
            Catalin Sumanaru
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: