[MDEV-16620] Add support for JSON_ARRAYAGG and JSON_OBJECTAGG Created: 2018-06-29  Updated: 2023-01-16  Resolved: 2020-01-01

Status: Closed
Project: MariaDB Server
Component/s: JSON
Fix Version/s: 10.5.0

Type: Task Priority: Critical
Reporter: markus makela Assignee: Alexey Botchkov
Resolution: Fixed Votes: 14
Labels: None

Issue Links:
Problem/Incident
causes MDEV-21410 Document JSON_ARRAYAGG and JSON_OBJEC... Closed
Relates
relates to MDEV-24784 JSON_ARRAYAGG charset issue Closed
relates to MDEV-17397 Implement JSON functions available in... Open
relates to MDEV-21528 json_arrayagg crashes in Item_func_gr... Closed
relates to MDEV-21902 Nested JSON_ARRAYAGG in JSON_OBJECT s... Closed
relates to MDEV-21914 JSON_ARRAYAGG doesn't reject ORDER BY... Closed
relates to MDEV-21915 Server crashes in copy_fields,Item_fu... Closed
relates to MDEV-22011 DISTINCT with JSON_ARRAYAGG gives wro... Closed
relates to MDEV-22084 Squared brackets missing from JSON_AR... Closed
relates to MDEV-22837 JSON_ARRAYAGG and JSON_OBJECTAGG trea... Closed
relates to MDEV-26506 Over-quoted JSON when combining JSON_... Closed
relates to MDEV-30412 JSON_OBJECTAGG doesn't escape double ... Closed
Epic Link: Implement JSON functions available in MySQL 8.0 but not MariaDB

 Description   

MySQL 8.0 has JSON_ARRAYAGG and JSON_OBJECTAGG. These are also available in Oracle databases.

The JSON_ARRAYAGG in addition to the MySQL features supports the DISTINCT mode.
So the JSON_ARRAYAGG(DISTINCT expr) will only collect the unique values in the resulting array.

 Comments   
Comment by Sergei Golubchik [ 2018-07-01 ]

Just for the record, they're in the standard too

Comment by Julien Fritsch [ 2019-11-05 ]

Last update: "this one is in fact closed. Only need to make decision about the documentation." Should be done this week.

Comment by Johann Pardanaud [ 2019-12-09 ]

What's the state of this development? Did you manage to make the appropriate decisions about the documentation?

Comment by Sergei Golubchik [ 2020-01-01 ]

already done. pushed and released. Not documented yet, it's MDEV-21410

Generated at Thu Feb 08 08:30:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.