[MDEV-30689] JSON_SCHEMA_VALID for type=array return 1 for any string that starts with '[' - Jira

XML

Word

Printable

Case:

SET @schema_array= '{"type":"array"}';

SELECT JSON_SCHEMA_VALID(@schema_array, '[');

In case it is missed closing brace for array, but result is still 1:

JSON_SCHEMA_VALID(json_object(),'[[')

Expected result:

JSON_SCHEMA_VALID(json_object(),'[[')

Or maybe result+warning

The same problem presents for case:

SELECT JSON_SCHEMA_VALID(repeat('[', 100000), json_object());

Actual result:

SELECT JSON_SCHEMA_VALID(repeat('[', 100000), json_object());

JSON_SCHEMA_VALID(repeat('[', 100000), json_object())

Warnings:

Warning	4040	Limit of 32 on JSON nested structures depth is reached in argument 2 to function 'json_schema_valid' at position 32

Expected result (result must be NULL):

SELECT JSON_SCHEMA_VALID(repeat('[', 100000), json_object());

JSON_SCHEMA_VALID(repeat('[', 100000), json_object())

NULL

Warnings:

Warning	4040	Limit of 32 on JSON nested structures depth is reached in argument 2 to function 'json_schema_valid' at position 32

Also after fix bug the following case should also be tested:

SELECT JSON_SCHEMA_VALID(json_object(), repeat('[', 10000000));

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.