[MDEV-17397] Implement JSON functions available in MySQL 8.0 but not MariaDB - Jira

XML

Word

Printable

Details

Type: Epic
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: compat80, JSON
Labels:
- compat80

Epic Name:
Implement JSON functions available in MySQL 8.0 but not MariaDB

Description

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 — N/A
JSON_STORAGE_SIZE — N/A
JSON_OVERLAPS (~~MDEV-27677~~)
JSON_SCHEMA_VALID() (~~MDEV-27128~~)
JSON_SCHEMA_VALIDATION_REPORT()
MEMBER OF() operator (MDEV-38591)

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

Attachments

Issue Links

is part of

MDEV-28906 MySQL 8.0 desired compatibility

Open

relates to

MDEV-13992 Implement JSON_MERGE_PATCH

Closed

MDEV-16620 Add support for JSON_ARRAYAGG and JSON_OBJECTAGG

Closed

MDEV-17399 Add support for JSON_TABLE

Closed

MDEV-27677 Implement JSON_OVERLAPS()

Closed

MDEV-27128 Implement JSON Schema Validation FUNCTION

Closed

(1 relates to)

Activity

People

Assignee:: Rucha Deodhar

Reporter:: Ian Gilfillan

Votes:: 11 Vote for this issue

Watchers:: 17 Start watching this issue

Dates

Created:: 2018-10-08 20:02

Updated:: 2026-01-18 12:29

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.