Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
As JSON_ARRAYAGG is implemented as a wrapper over Item_func_group_concat, MDEV-11563 is going to affect JSON_ARRAYAGG too.
The problem with DISTINCT in JSON_ARRAYAGG is that it expects the values read from the table for each record. It does not use the key but instead calls val_str() for all the arguments in the GROUP_CONCAT function.
Attachments
Issue Links
- relates to
-
MDEV-11563 GROUP_CONCAT(DISTINCT ...) may produce a non-distinct list
- Closed
-
MDEV-16620 Add support for JSON_ARRAYAGG and JSON_OBJECTAGG
- Closed
-
MDEV-22840 JSON_ARRAYAGG gives wrong results with NULL values and ORDER by clause
- Closed