[MDEV-11867] Invalid use of group function - - Jira

XML

Word

Printable

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

relates to

MDEV-15313 Error with aggregate function inside of last_value() window function

MDEV-22814 SIGSEGV in set_field_to_null_with_conversions on SELECT (on optimized builds)

MDEV-24875 Nested GROUP_CONCAT in stored function gives "ERROR 1111 (HY000) : Invalid use of group function"