Bug #84653 json aggregate functions
Submitted: 24 Jan 2017 21:03 Modified: 24 Jan 2017 21:07
Reporter: Ephraim Khantsis Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: JSON Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[24 Jan 2017 21:03] Ephraim Khantsis
Description:
since mysql now returns values as json, it would be useful to have json aggregate functions too. Specifically, json_group_array would return an array of combined group results. Other systems, including PostGRE and even SQLite, already have this. 

Currently, a poor workaround is group_concat, however it returns a string, which causes improper json.

How to repeat:
the function does not exist
[24 Jan 2017 21:07] Ephraim Khantsis
sorry, i found that this is sa duplicate