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
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
12d 17h 57m | 1 |
|
7s | 1 |
|
3s | 1 |
|
23s | 1 |
|
3d 21h 52m | 2 |
|
51d 4h 37m | 2 |
|
6d 22h 54m | 1 |