[MDEV-25934] JSON-Schema as Contraint on JSON-column Created: 2021-06-16  Updated: 2021-11-26  Resolved: 2021-11-26

Status: Closed
Project: MariaDB Server
Component/s: JSON
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Karsten Budde Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: CONSTRAINT, json

Issue Links:
Duplicate
is duplicated by MDEV-27128 Implement JSON Schema Validation FUNC... Closed

 Description   

With JSON Schema there is an established standard to check the structure of a JSON document.

The JSON checking functions currently implemented in MariaDB offer a similar range of functions.

As a rule, the JSON document must be checked for correctness not only in the database but also in the programming language of the application. Therefore, it would be easier for the developer if the JSON schema could also be used for checking in the database via checking in the application.

Is it planned that in the future one can also pass a JSON schema to the database to check a JSON column for correctness?
I would appreciate that very much.



 Comments   
Comment by Sergei Golubchik [ 2021-11-26 ]

please, see MDEV-27128

Generated at Thu Feb 08 09:41:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.