-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2.3
-
Fix Version/s: 10.2.4
-
Component/s: Optimizer - Window functions
-
Labels:None
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
-
- Stalled
-
-
MDEV-22814 SIGSEGV in set_field_to_null_with_conversions on SELECT (on optimized builds)
-
- In Progress
-
-
MDEV-24875 Nested GROUP_CONCAT in stored function gives "ERROR 1111 (HY000) : Invalid use of group function"
-
- Confirmed
-