Bug #62186 add a limit argument to group_concat

Description:
I often find myself wanting to a query that uses group_concat but want to limimt the number of rows in the concat. Looking around I find many posts from people asking how to do this, so it would be useful addition to MySQL.

Yes I know that you can do a subquery, but perfomance-wise it's not the same as native support.

How to repeat:
do any group_concat query, and try to pass a limit argument

Suggested fix:
add a limit argument to group_concat

Why not to use group_concat_max_len server variable to limit size (see http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_group_concat_ma...)?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

group_concat_max_len would be useful only if the items being concatenated are constant length.  Otherwise, LIMIT seems to be a necessity.

Assuming that LIMIT is required, this could be "Dup of bug 30098".