Debian Codegraph @

mysql-test/suite/json/t/json_schema_validation_report.test

raw
1 --echo # See that NULL-handling is correct
2 SELECT JSON_SCHEMA_VALIDATION_REPORT(NULL, NULL);
3 SELECT JSON_SCHEMA_VALIDATION_REPORT(JSON_OBJECT(), NULL);
4 SELECT JSON_SCHEMA_VALIDATION_REPORT(NULL, JSON_OBJECT());
5
6 --echo # A few "happy" cases
7 SELECT JSON_SCHEMA_VALIDATION_REPORT('{"type": "object"}', '{}');
8 SELECT JSON_SCHEMA_VALIDATION_REPORT('{"type": "array"}', '[]');
9
10 --echo # Cases where the JSON document is invalid
11 SELECT JSON_SCHEMA_VALIDATION_REPORT('{"type": "object"}', '[]');
12 SELECT JSON_SCHEMA_VALIDATION_REPORT('{
13 "type": "object",
14 "properties": {
15 "geometry": {
16 "type": "object",
17 "properties": {
18 "latitude": {
19 "minimum": -90
20 }
21 }
22 }
23 }
24 }',
25 '{
26 "geometry": {
27 "longitude": -90,
28 "latitude": -180
29 }
30 }');
31
32 --echo # A case where the JSON Schema is invalid
33 SELECT JSON_SCHEMA_VALIDATION_REPORT('{"type": "object-object"}', '{}');
34
35 --echo # Non-json JSON Schema input
36 --error ER_INVALID_TYPE_FOR_JSON
37 SELECT JSON_SCHEMA_VALIDATION_REPORT(POINT(1, 1), '{}');
38 --error ER_INVALID_JSON_TEXT_IN_PARAM
39 SELECT JSON_SCHEMA_VALIDATION_REPORT('{ bar', '{}');
40
41 --echo # Non-object JSON Schema input
42 --error ER_INVALID_JSON_TYPE
43 SELECT JSON_SCHEMA_VALIDATION_REPORT('[]', '{}');
44
45 --echo # Non-json JSON document input
46 --error ER_INVALID_TYPE_FOR_JSON
47 SELECT JSON_SCHEMA_VALIDATION_REPORT('{}', POINT(1, 1));
48 --error ER_INVALID_JSON_TEXT_IN_PARAM
49 SELECT JSON_SCHEMA_VALIDATION_REPORT('{}', '{ bar');
50
51 --echo # Wrong argument count
52 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
53 SELECT JSON_SCHEMA_VALIDATION_REPORT();
54 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
55 SELECT JSON_SCHEMA_VALIDATION_REPORT(NULL);
56 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
57 SELECT JSON_SCHEMA_VALIDATION_REPORT(NULL, NULL, NULL);
58
59
60 --echo # Ensure that our item tree transformation doesn't get stuck forever when
61 --echo # using prepared statements.
62 PREPARE stmt FROM 'SELECT JSON_SCHEMA_VALIDATION_REPORT(?, ''{}'') FROM DUAL';
63 SET @json_schema = '{"type":"object"}';
64 SET @null = NULL;
65 EXECUTE stmt USING @json_schema;
66 EXECUTE stmt USING @null;
67 EXECUTE stmt USING @json_schema;
68
69 --echo #
70 --echo # Bug#29529220: WL#13005: ASSERTION FAILURE: `!ARGS[0]->CONST_ITEM()'
71 --echo # Bug#29528888: WL#11999: SIG6 IN ITEM_FUNC_JSON_SCHEMA_VALID::VAL_BOOL()
72 --echo # AT ITEM_JSON_FUNC.CC
73 --echo #
74 CREATE TABLE t1 (pk INT PRIMARY KEY, j JSON);
75 INSERT INTO t1 VALUES (1, '{"key": "foobar"}' );
76 SELECT JSON_SCHEMA_VALIDATION_REPORT(j, j) FROM t1 WHERE pk = 1;
77 SELECT JSON_SCHEMA_VALIDATION_REPORT(t2.j, t2.j)
78 FROM t1, (SELECT * FROM t1 WHERE pk = 1) t2;
79 DROP TABLE t1;
80
81 --echo #
82 --echo # Bug#30622327: JSON SCHEMA FUNCTIONS SHOULD CHECK ARGUMENT TYPES
83 --echo # AT RESOLVE TIME
84 --echo #
85 CREATE TABLE t(j JSON, g GEOMETRY);
86 --error ER_INVALID_TYPE_FOR_JSON
87 PREPARE ps FROM 'SELECT * FROM t WHERE JSON_SCHEMA_VALIDATION_REPORT(j, g)';
88 --error ER_INVALID_TYPE_FOR_JSON
89 PREPARE ps FROM 'SELECT * FROM t WHERE JSON_SCHEMA_VALIDATION_REPORT(g, j)';
90 DROP TABLE t;
91
92 --echo #
93 --echo # Bug#32047630: MISSING ERROR PROPAGATION IN JSON FUNCTIONS
94 --echo #
95
96 --error ER_INVALID_JSON_TEXT_IN_PARAM
97 SELECT JSON_ARRAY(JSON_SCHEMA_VALIDATION_REPORT('{}', '{'), 1);
98 --error ER_INVALID_JSON_TEXT_IN_PARAM
99 SELECT JSON_ARRAY(JSON_SCHEMA_VALIDATION_REPORT('{}', CAST('{' AS JSON)), 1);
100 --error ER_INVALID_JSON_TEXT_IN_PARAM
101 SELECT JSON_ARRAY(JSON_SCHEMA_VALIDATION_REPORT(
102 CAST(CONCAT('{', RAND()) AS JSON), '{}'), 1);