Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.1(EOL)
-
None
Description
JSON_SCHEMA_VALID is not validating case sensitive when using regex
11.1.0-dbg>SET @schema='{ |
'> "type": "string", |
'> "pattern": "[A-Z]" |
'> }'; |
Query OK, 0 rows affected (0.000 sec) |
 |
11.1.0-dbg>
|
Actual result
11.1.0-dbg>SELECT JSON_SCHEMA_VALID(@schema,'"a"'); |
+----------------------------------+ |
| JSON_SCHEMA_VALID(@schema,'"a"') | |
+----------------------------------+ |
| 1 |
|
+----------------------------------+ |
1 row in set (0.000 sec) |
Expected result
11.1.0-dbg>SELECT JSON_SCHEMA_VALID(@schema,'"a"'); |
+----------------------------------+ |
| JSON_SCHEMA_VALID(@schema,'"a"') | |
+----------------------------------+ |
| 0 |
|
+----------------------------------+ |
1 row in set (0.000 sec) |
Attachments
Issue Links
- is caused by
-
MDEV-27128 Implement JSON Schema Validation FUNCTION
- Closed