Bug #86877 Improve error report for unsupported aggr. window function to include its name
Submitted: 29 Jun 2017 20:25 Modified: 15 Aug 2017 13:33
Reporter: Dag Wanvik Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S4 (Feature request)
Version:8.0.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: WL9727 WL9236

[29 Jun 2017 20:25] Dag Wanvik
Description:
Currently, the error message looks like this:

ERROR 1235 (42000): This version of MySQL doesn't yet support 'this aggregate as window function'

It would be nice to include the name of the unsupported aggregate.

How to repeat:
CREATE TABLE t(i VARCHAR(20));
SELECT GROUP_CONCAT(i) OVER () FROM t;
[15 Aug 2017 13:33] Paul DuBois
Posted by developer:
 
Fixed in 8.0.3.

Cosmetic improvement. No changelog entry needed.