[MDEV-30995] JSON_SCHEMA_VALID is not validating case sensitive when using regex - Jira

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)

is caused by

MDEV-27128 Implement JSON Schema Validation FUNCTION

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server