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

Implement JSON functions available in MySQL 8.0 but not MariaDB

Details

    • 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

            No workflow transitions have been executed yet.

            People

              rucha174 Rucha Deodhar
              greenman Ian Gilfillan
              Votes:
              11 Vote for this issue
              Watchers:
              17 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.