Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
multipleOf
The value of "multipleOf" MUST be a number, strictly greater than 0.
https://json-schema.org/draft/2019-09/json-schema-validation.html#rfc.section.6.2.1
Case:
SET @schema = '{ |
"multipleOf": 0
|
}'; |
SELECT JSON_SCHEMA_VALID(@schema, '2'); |
Expected that there will be a warning, but actual result is:
JSON_SCHEMA_VALID(@schema, '2') |
0
|
Also maybe a value like 0.1("multipleOf": 0.1) needs to be checked but I'm not sure
Attachments
Issue Links
- is caused by
-
MDEV-27128 Implement JSON Schema Validation FUNCTION
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is caused by |
| Description |
*multipleOf*
??The value of "multipleOf" MUST be a number, strictly greater than 0. ?? https://json-schema.org/draft/2019-09/json-schema-validation.html#rfc.section.6.2.1 Case: {code:sql} SET @schema = '{ "multipleOf": 0 }'; SELECT JSON_SCHEMA_VALID(@schema, '2'); {code} Expected that there will be a warning, but actual result is: {code:sql} JSON_SCHEMA_VALID(@schema, '2') 0 {code} Also maybe a value like 0.1("multipleOf": 0.1) needs to be checked but I'm not sure |
*multipleOf*
??The value of "multipleOf" MUST be a number, strictly greater than 0.?? https://json-schema.org/draft/2019-09/json-schema-validation.html#rfc.section.6.2.1 Case: {code:sql} SET @schema = '{ "multipleOf": 0 }'; SELECT JSON_SCHEMA_VALID(@schema, '2'); {code} Expected that there will be a warning, but actual result is: {code:sql} JSON_SCHEMA_VALID(@schema, '2') 0 {code} Also maybe a value like 0.1("multipleOf": 0.1) needs to be checked but I'm not sure |
| Assignee | Rucha Deodhar [ rucha174 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Rucha Deodhar [ rucha174 ] | Alexey Botchkov [ holyfoot ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Alexey Botchkov [ holyfoot ] | Rucha Deodhar [ rucha174 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.1.1 [ 28704 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |