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

JSON_TABLE: extract document fragment into JSON column

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.6.9
    • JSON
    • None

    Description

      Currently, JSON_TABLE doesn't allow one to extract a JSON "subdocument" into a JSON column.

      Both the SQL Standard and MySQL-8 provide this capability. This task is about implementing it.

      I was sent a patch with MySQL-8 syntax support, so I assume we're going to implement MySQL-8 compatible syntax, which is just to allow specifying column type as JSON. For example:

      select * from
        json_table('{"foo": [1,2,3,4]}',
                   '$' columns( jscol json path '$.foo')
                   ) as T;
      

      should emit [1,2,3,4].

      Attachments

        Issue Links

          Activity

            People

              rucha174 Rucha Deodhar
              psergei Sergei Petrunia
              Votes:
              1 Vote for this issue
              Watchers:
              11 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.