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
            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
            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.
            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 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

            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.