[MDEV-17397] Implement JSON functions available in MySQL 8.0 but not MariaDB Created: 2018-10-08  Updated: 2022-08-01

Status: Open
Project: MariaDB Server
Component/s: compat80, JSON
Fix Version/s: None

Type: Epic Priority: Major
Reporter: Ian Gilfillan Assignee: Rucha Deodhar
Resolution: Unresolved Votes: 11
Labels: Compatibility

Issue Links:
Relates
relates to MDEV-13992 Implement JSON_MERGE_PATCH Closed
relates to MDEV-16620 Add support for JSON_ARRAYAGG and JSO... Closed
relates to MDEV-17399 Add support for JSON_TABLE Closed
relates to MDEV-27677 Implement JSON_OVERLAPS() Closed
relates to MDEV-27128 Implement JSON Schema Validation FUNC... Closed
Epic Name: Implement JSON functions available in MySQL 8.0 but not MariaDB

 Description   

*strong text*As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-103-and-mysql-80 MySQL 8.0 has quite a few JSON functions not available in MariaDB:
JSON_ARRAYAGG (in MDEV-16620)
JSON_OBJECTAGG (in MDEV-16620)
JSON_MERGE_PATCH (in MDEV-13992) (done for 10.2+)
JSON_MERGE_PRESERVE (in MDEV-13992) (done for 10.2+)
JSON_TABLE (in MDEV-17399)
JSON_STORAGE_FREE
JSON_STORAGE_SIZE
JSON_OVERLAPS (MDEV-27677)
JSON_SCHEMA_VALID() (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT()
MEMBER OF() operator

The lack of these can cause problems for some MySQL users wanting to use MariaDB.

 Comments   
Comment by Aleksey M. [ 2018-11-20 ]

@elenst, Why do you ignore these requests?

Comment by Francisco Dueñas [ 2018-12-31 ]

This functions shoudl be added in latest MariaDB, or, rather than alot of workload, is there any license restrictions with Oracle MySQl to implement those?

Comment by Francisco Dueñas [ 2020-01-22 ]

When this task finishes, can they be ported to 10.2 or newer one below 10.5?

Comment by Rucha Deodhar [ 2022-01-28 ]

Removed JSON_PRETTY() from description because it is implemented as JSON_DETAILED() in MariaDB.

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