Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17397

Implement JSON functions available in MySQL 8.0 but not MariaDB

    XMLWordPrintable

    Details

    • 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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rucha174 Rucha Deodhar
              Reporter:
              greenman Ian Gilfillan
              Votes:
              11 Vote for this issue
              Watchers:
              16 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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