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

SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.38.0
    • None

    Description

      SqlToRelConverter replaces SUM with SUM0 around here

      This might have been needed at some point in the past - but I think it will be better to leave it as SUM - as in case there is no SUM0 in the system that will be replaced with a COALESCE(SUM(...) , 0 ) to provide it - as see here

      Attachments

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-6582 Release Calcite 1.38.0

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6516 AVG to SUM+COUNT transformation inserts invalid CAST call

          • Major - Major loss of function.
          • Open
          links to

          Web Link GitHub Pull Request #3437

          Web Link GitHub Pull Request #3882

          Activity

            People

              njordan Norman Jordan
              kgyrtkirk Zoltan Haindrich
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: