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

JSON_TABLE: extract document fragment into JSON column

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Fix Version/s: 10.6.9
    • Component/s: JSON
    • Labels:
      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

              Assignee:
              rucha174 Rucha Deodhar
              Reporter:
              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.