MySQL Bugs: #84653: json aggregate functions

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

sorry, i found that this is sa duplicate