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

Implement JSON Schema Validation FUNCTION

    XMLWordPrintable

    Details

      Description

      A great addition to MariaDB would be able to validate JSON schemas. MySQL already have this implemented as follows:

      JSON_SCHEMA_VALID(schema,document)

      Validates a JSON document against a JSON schema. Both schema and document are required. The schema must be a valid JSON object; the document must be a valid JSON document. Provided that these conditions are met: If the document validates against the schema, the function returns true (1); otherwise, it returns false (0).

      https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html#function_json-schema-valid

      Since MariaDB is great and it allows the use of UDFs and deterministic functions on constraints something like this would be awesome:

      CREATE TABLE t1 (a JSON CHECK JSON_SCHEMA_VALID(schema, a));

      or

      CREATE TABLE t1 (
      		 
      a JSON,
      		 
      CONSTRAINT json_validation CHECK JSON_SCHEMA_VALID(schema, a)
      		 
      );

      The word schema should be replaced by a string representing a valid JSON schema.

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30287 JSON_SCHEMA_VALID returns incorrect result for type=number

          • Major - Major loss of function.
          • Open
          duplicates

          Task - A task that needs to be done. MDEV-25934 JSON-Schema as Contraint on JSON-column

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          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

          Task - A task that needs to be done. MDEV-30219 Add more validation keywords for json schema

          • Major - Major loss of function.
          • Open

            Activity

              People

              Assignee:
              lstartseva Lena Startseva
              Reporter:
              rubenferreira7575 Rúben Ferreira
              Votes:
              3 Vote for this issue
              Watchers:
              9 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.