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

is json predicate

    XMLWordPrintable

Details

    Description

      https://modern-sql.com/caniuse/is-json

      IS JSON is a predicate to determine if the previous is a JSON object.

      The SQL 2016 syntax is (2:8.22)

      <expr> [ FORMAT JSON [ ENCODING { UTF8 | UTF16 | UTF32 } ] ]
             IS [ NOT ] JSON
             [ { VALUE | ARRAY | OBJECT | SCALAR } ]
             [ { WITH | WITHOUT } UNIQUE [ KEYS ] ]
      

      but can only implement a subset of it, of course.

      With IS being a parsed comparison its a small extension.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.