Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
If at least one of the arguments is NULL, the function returns NULL.
(https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html)
So for case:
SELECT JSON_SCHEMA_VALID('{}', NULL); |
Expected result:
JSON_SCHEMA_VALID('{}', NULL) |
NULL |
Actual result:
JSON_SCHEMA_VALID('{}', NULL) |
1
|
Full MTR case for NULL:
SELECT JSON_SCHEMA_VALID(NULL, NULL); |
SELECT JSON_SCHEMA_VALID('{}', NULL); |
SELECT JSON_SCHEMA_VALID(NULL, '{}'); |
Attachments
Issue Links
- is caused by
-
MDEV-27128 Implement JSON Schema Validation FUNCTION
- Closed