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

Nested aggregate windowed query fails

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.9.0
    • None
    • 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

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-750 Allow windowed aggregate on top of regular aggregate

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1340 Window aggregates invalid error/error messages in some cases

          • Major - Major loss of function.
          • Closed

          Activity

            People

              gparai Gautam Parai
              gparai Gautam Parai
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: