Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
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)
|
Attachments
Issue Links
- is duplicated by
-
MDEV-15313 Error with aggregate function inside of last_value() window function
- Stalled