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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15313 Error with aggregate function inside of last_value() window function

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22814 SIGSEGV in set_field_to_null_with_conversions on SELECT (on optimized builds)

          • Major - Major loss of function.
          • In Progress

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24875 Nested GROUP_CONCAT in stored function gives "ERROR 1111 (HY000) : Invalid use of group function"

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.