Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Fix
-
11.1(EOL)
-
None
Description
11.1.0-dbg>SET @schema='{"maximum": 18446744073709551}'; |
Query OK, 0 rows affected (0.000 sec) |
|
|
11.1.0-dbg>
|
Actual result
11.1.0-dbg>SELECT JSON_SCHEMA_VALID(@schema,18446744073709552); |
+----------------------------------------------+ |
| JSON_SCHEMA_VALID(@schema,18446744073709552) | |
+----------------------------------------------+ |
| 1 |
|
+----------------------------------------------+ |
1 row in set (0.000 sec) |
|
|
11.1.0-dbg>
|
Expected result
11.1.0-dbg>SELECT JSON_SCHEMA_VALID(@schema,18446744073709552); |
+----------------------------------------------+ |
| JSON_SCHEMA_VALID(@schema,18446744073709552) | |
+----------------------------------------------+ |
| 0 |
|
+----------------------------------------------+ |
1 row in set (0.000 sec) |
|
|
11.1.0-dbg>
|
11.1.0-dbg>SET @schema='{"minimum": 18446744073709551}'; |
Query OK, 0 rows affected (0.000 sec) |
|
|
11.1.0-dbg>
|
Actual result
11.1.0-dbg>SELECT JSON_SCHEMA_VALID(@schema,18446744073709550); |
+----------------------------------------------+ |
| JSON_SCHEMA_VALID(@schema,18446744073709550) | |
+----------------------------------------------+ |
| 1 |
|
+----------------------------------------------+ |
1 row in set (0.000 sec) |
|
|
11.1.0-dbg>
|
Expected result
11.1.0-dbg>SELECT JSON_SCHEMA_VALID(@schema,18446744073709550); |
+----------------------------------------------+ |
| JSON_SCHEMA_VALID(@schema,18446744073709550) | |
+----------------------------------------------+ |
| 0 |
|
+----------------------------------------------+ |
1 row in set (0.000 sec) |
|
|
11.1.0-dbg>
|
Attachments
Issue Links
- is caused by
-
MDEV-27128 Implement JSON Schema Validation FUNCTION
-
- Closed
-
- relates to
-
-
- Open
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is caused by |
| Fix Version/s | 11.1.0 [ 28705 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Resolution | Won't Fix [ 2 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link | This issue relates to MDEV-31104 [ MDEV-31104 ] |
Wont fix for now. The json values are store in "double" type but the maximum values mentioned in the test case are bigger than what double can store. long double can store it, but currently we don't support long double. It needs to be implemented as a separate task.