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

Add support for JSON_ARRAYAGG and JSON_OBJECTAGG

Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.5.0
    • JSON
    • None

    Description

      MySQL 8.0 has JSON_ARRAYAGG and JSON_OBJECTAGG. These are also available in Oracle databases.

      The JSON_ARRAYAGG in addition to the MySQL features supports the DISTINCT mode.
      So the JSON_ARRAYAGG(DISTINCT expr) will only collect the unique values in the resulting array.

      Attachments

        Issue Links

          causes

          Task - A task that needs to be done. MDEV-21410 Document JSON_ARRAYAGG and JSON_OBJECTAGG

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24784 JSON_ARRAYAGG charset issue

          • Major - Major loss of function.
          • Closed

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-17397 Implement JSON functions available in MySQL 8.0 but not MariaDB

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21528 json_arrayagg crashes in Item_func_group_concat::add, Assertion `(ptr != __null && end >= ptr) || (ptr == __null && end == __null)' failed in copy_fields

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21902 Nested JSON_ARRAYAGG in JSON_OBJECT should not get escaped

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21914 JSON_ARRAYAGG doesn't reject ORDER BY clause, but doesn't work either

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21915 Server crashes in copy_fields,Item_func_group_concat::add while using json_arrayagg() as a window function

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22011 DISTINCT with JSON_ARRAYAGG gives wrong results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22084 Squared brackets missing from JSON_ARRAYAGG when used in a view

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22837 JSON_ARRAYAGG and JSON_OBJECTAGG treat JSON arguments as text

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26506 Over-quoted JSON when combining JSON_ARRAYAGG with JSON_OBJECT

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30412 JSON_OBJECTAGG doesn't escape double quote in key

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            markus makela markus makela created issue -
            serg Sergei Golubchik added a comment -

            Just for the record, they're in the standard too

            serg Sergei Golubchik added a comment - Just for the record, they're in the standard too
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Component/s JSON [ 13908 ]
            serg Sergei Golubchik made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.4 [ 22408 ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            serg Sergei Golubchik made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            diego dupin Diego Dupin made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Link PT-76 [ 68557 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Link PT-76 [ 68557 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.4 [ 22408 ]
            NRE Projects RM_104_others RM_105_CANDIDATE
            holyfoot Alexey Botchkov made changes -
            Due Date 2019-08-26
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            holyfoot Alexey Botchkov made changes -
            Due Date 2019-08-26 2019-10-08
            julien.fritsch Julien Fritsch added a comment -

            Last update: "this one is in fact closed. Only need to make decision about the documentation." Should be done this week.

            julien.fritsch Julien Fritsch added a comment - Last update: "this one is in fact closed. Only need to make decision about the documentation." Should be done this week.
            julien.fritsch Julien Fritsch made changes -
            Due Date 2019-10-08
            johann Johann Pardanaud added a comment -

            What's the state of this development? Did you manage to make the appropriate decisions about the documentation?

            johann Johann Pardanaud added a comment - What's the state of this development? Did you manage to make the appropriate decisions about the documentation?
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5.0 [ 23709 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik added a comment -

            already done. pushed and released. Not documented yet, it's MDEV-21410

            serg Sergei Golubchik added a comment - already done. pushed and released. Not documented yet, it's MDEV-21410
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            holyfoot Alexey Botchkov made changes -
            Description MySQL 8.0 has [JSON_ARRAYAGG|https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_json-arrayagg] and [JSON_OBJECTAGG|https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_json-objectagg]. These are also available in Oracle databases. MySQL 8.0 has [JSON_ARRAYAGG|https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_json-arrayagg] and [JSON_OBJECTAGG|https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_json-objectagg]. These are also available in Oracle databases.

            The JSON_ARRAYAGG in addition to the MySQL features supports the DISTINCT mode.
            So the JSON_ARRAYAGG(DISTINCT expr) will only collect the unique values in the resulting array.
            alice Alice Sherepa made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            thk Thomas K. made changes -
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 88127 ] MariaDB v4 [ 133617 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Link MDEV-17397 [ 70163 ]
            alice Alice Sherepa made changes -

            People

              holyfoot Alexey Botchkov
              markus makela markus makela
              Votes:
              14 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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