Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11867

Invalid use of group function -

    XMLWordPrintable

    Details

      Description

      Following windowed aggregate cannot be expressed.

      SELECT
          `C1`, 
          `C2`, 
          SUM(`C3`), 
          SUM(SUM(`C3`))
              OVER(
                  PARTITION BY
                      `C1`
              )
      FROM
          `TOLAP` 
      GROUP BY 
          `C1`, 
          `C2`
       
      Error: Invalid use of group function
      SQLState:  HY000
      ErrorCode: 1111
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              igor Igor Babaev
              Reporter:
              the6campbells the6campbells
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration