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

      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

          relates to

          Task - A task that needs to be done. MDEV-13992 Implement JSON_MERGE_PATCH

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16620 Add support for JSON_ARRAYAGG and JSON_OBJECTAGG

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-17399 Add support for JSON_TABLE

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-27677 Implement JSON_OVERLAPS()

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-27128 Implement JSON Schema Validation FUNCTION

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              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.