Bug #105541 SELECT JSON_ARRAYAGG(DISTINCT ... does not work

Description:
This SQL

SELECT JSON_ARRAYAGG(DISTINCT `my_col`)
FROM `my_table` 
GROUP `group_col`
;

It work fine when I run it in a query tab. Even if it show a problem in the margin.

But when trying to write this select in a stored procedure, it is impossible to apply until the DISTINT is present in the query.

Error message when clicking on Apply :
The object's DDL statement contains syntax errors.
You cannot modify this object until you fix the errors.

How to repeat:
Try to make a stored procedure withe a JSON_ARRAYAGG(DISTINCT ...)

Suggested fix:
Add the support of DISTINCT for this instruction

The query in query tab

Attachment: Capture d’écran 2021-11-11 à 14.56.14.png (image/png, text), 64.70 KiB.

The error disappear when removing DISTINCT

Attachment: Capture d’écran 2021-11-11 à 14.56.28.png (image/png, text), 60.74 KiB.

Error message in the editor

Attachment: Capture d’écran 2021-11-13 à 18.37.21.png (image/png, text), 89.22 KiB.

Hello Eric BARDOUL,

Thank you for the bug report.
Imho this is duplicate of Bug #91993, please see Bug #91993.

Regards,
Ashwini Patil