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

          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

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            alekseymvt Aleksey M. added a comment - - edited

            @elenst, Why do you ignore these requests?

            alekseymvt Aleksey M. added a comment - - edited @elenst, Why do you ignore these requests?
            fduenas Francisco Dueñas added a comment -

            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?

            fduenas Francisco Dueñas added a comment - 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?
            fduenas Francisco Dueñas added a comment -

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

            fduenas Francisco Dueñas added a comment - When this task finishes, can they be ported to 10.2 or newer one below 10.5?
            rucha174 Rucha Deodhar added a comment - - edited

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

            rucha174 Rucha Deodhar added a comment - - edited Removed JSON_PRETTY() from description because it is implemented as JSON_DETAILED() in MariaDB.

            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.