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
            greenman Ian Gilfillan created issue -
            diego dupin Diego Dupin made changes -
            Field Original Value New Value
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            anel Anel Husakovic made changes -
            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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            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?
            ralf.gebhardt Ralf Gebhardt made changes -
            NRE Projects RM_105_CANDIDATE
            greenman Ian Gilfillan made changes -
            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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5 [ 23123 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            holyfoot Alexey Botchkov made changes -
            Due Date 2019-08-26
            serg Sergei Golubchik made changes -
            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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            serg Sergei Golubchik made changes -
            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
                JSON_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            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_MERGE_PATCH
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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_MERGE_PATCH (in MDEV-13992)
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            serg Sergei Golubchik made changes -
            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_MERGE_PATCH (in MDEV-13992)
                JSON_MERGE_PRESERVE
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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_MERGE_PATCH (in MDEV-13992)
                JSON_MERGE_PRESERVE (in MDEV-13992)
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            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_MERGE_PATCH (in MDEV-13992)
                JSON_MERGE_PRESERVE (in MDEV-13992)
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS (MySQL 8.0.17)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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_MERGE_PATCH (in MDEV-13992)
                JSON_MERGE_PRESERVE (in MDEV-13992)
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            holyfoot Alexey Botchkov made changes -
            Due Date 2019-08-26 2019-11-25
            ralf.gebhardt Ralf Gebhardt made changes -
            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_MERGE_PATCH (in MDEV-13992)
                JSON_MERGE_PRESERVE (in MDEV-13992)
                JSON_OBJECTAGG (in MDEV-16620)
                JSON_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_TABLE (in MDEV-17399)
                JSON_OVERLAPS

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_OVERLAPS

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            julien.fritsch Julien Fritsch made changes -
            Due Date 2019-11-25
            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?
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5 [ 23123 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 89975 ] MariaDB v4 [ 130913 ]
            rucha174 Rucha Deodhar made changes -
            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_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_OVERLAPS

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_OVERLAPS
                JSON_SCHEMA_VALID()
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            rucha174 Rucha Deodhar made changes -
            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_PRETTY
                JSON_STORAGE_FREE
                JSON_STORAGE_SIZE
                JSON_OVERLAPS
                JSON_SCHEMA_VALID()
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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
                JSON_SCHEMA_VALID()
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            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.
            rucha174 Rucha Deodhar made changes -
            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
                JSON_SCHEMA_VALID()
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID()
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            rucha174 Rucha Deodhar made changes -
            rucha174 Rucha Deodhar made changes -
            rucha174 Rucha Deodhar made changes -
            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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID()
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID() ([MDEV-27815|https://jira.mariadb.org/browse/MDEV-27815])
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            rucha174 Rucha Deodhar made changes -
            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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID() ([MDEV-27815|https://jira.mariadb.org/browse/MDEV-27815])
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID() ([MDEV-27128|https://jira.mariadb.org/browse/MDEV-27128])
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            rucha174 Rucha Deodhar made changes -
            rucha174 Rucha Deodhar made changes -
            rucha174 Rucha Deodhar made changes -
            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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID() ([MDEV-27128|https://jira.mariadb.org/browse/MDEV-27128])
                JSON_SCHEMA_VALIDATION_REPORT()

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID() ([MDEV-27128|https://jira.mariadb.org/browse/MDEV-27128])
                JSON_SCHEMA_VALIDATION_REPORT()
                MEMBER OF() operator

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Assignee Alexey Botchkov [ holyfoot ] Rucha Deodhar [ rucha174 ]
            greenman Ian Gilfillan made changes -
            Component/s compat80 [ 19003 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            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|https://jira.mariadb.org/browse/MDEV-27677])
                JSON_SCHEMA_VALID() ([MDEV-27128|https://jira.mariadb.org/browse/MDEV-27128])
                JSON_SCHEMA_VALIDATION_REPORT()
                MEMBER OF() operator

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.             		*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.
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Name Implement JSON functions available in MySQL 8.0 but not MariaDB
            Epic Status To Do [ 10100 ]
            Issue Type Task [ 3 ] Epic [ 5 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Child MDEV-16620 [ 68417 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Child MDEV-13992 [ 63468 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Child MDEV-17399 [ 70166 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Child MDEV-27677 [ 107406 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Child MDEV-27128 [ 105604 ]

            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.