[MDEV-19053] Error using first_value/last_value window function with aggregated function Created: 2019-03-26  Updated: 2020-06-21  Resolved: 2020-06-21

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - Window functions
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Varun Gupta (Inactive)
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-15313 Error with aggregate function inside ... Stalled

 Description   

create table t1 (a int);
insert into t1 values (1), (2), (3);
 
select  first_value(avg(a)) over () from t1;

MariaDB [test]> select  first_value(avg(a)) over () from t1;
ERROR 1111 (HY000): Invalid use of group function

Mysql 8.0/Postgres 9.6:

mysql> select  first_value(avg(a)) over () from t1;
+-----------------------------+
| first_value(avg(a)) over () |
+-----------------------------+
|                      2.0000 |
+-----------------------------+
1 row in set (0.00 sec)


Generated at Thu Feb 08 08:48:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.