Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1327

Nested aggregate windowed query fails

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.0
    • Component/s: None
    • Labels:
      None

      Description

      Regression from CALCITE-750 Allow nested window aggregates.
      Calcite allows illegal queries instead of raising an appropriate error. When executing the following query calcite does not raise the following error.

      select avg(sum(b)) over (partition by b) from t1;
      ERROR:  Expression 'b' is not being grouped
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gparai Gautam Kumar Parai
                Reporter:
                gparai Gautam Kumar Parai
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: