How to generate a validation report of a JSON value against a JSON schema using the JSON_SCHEMA_VALIDATION_REPORT() function?

JSON_SCHEMA_VALIDATION_REPORT(schema, json) is a MySQL built-in function that returns a validation report of a JSON value against a given JSON schema. The report itself is a JSON object. For example:

SET @schema = '{
  "id": "http://json-schema.org/geo",
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A geographical coordinate",
  "type": "object",
  "properties": {
    "latitude": {
     "type": "number"
    },
    "longitude": {
     "type": "number"
    }
  },
  "required": ["latitude", "longitude"]
}';

SET @document = '{"latitude": 63.444697, "longitude": 10.445118}';

SELECT JSON_SCHEMA_VALIDATION_REPORT(@schema, @document);
  -- +---------------------------------------------------+
  -- | JSON_SCHEMA_VALIDATION_REPORT(@schema, @document) |
  -- +---------------------------------------------------+
  -- | {"valid": true}                                   |
  -- +---------------------------------------------------+

SELECT JSON_SCHEMA_VALIDATION_REPORT(@schema, '{"latitude": 63.444697}');
  -- +-----------------------------------------------------------------------+
  -- | JSON_SCHEMA_VALIDATION_REPORT(@schema, '{"latitude": 63.444697}')     |
  -- +-----------------------------------------------------------------------+
  -- | {"valid": false, "reason": "The JSON document location '#' failed 
    requirement 'required' at JSON Schema location '#'", 
  "schema-location": "#", 
  "document-location": "#", 
  "schema-failed-keyword": "required"}                                  |
  -- +-----------------------------------------------------------------------+

Reference information of the JSON_SCHEMA_VALIDATION_REPORT() function:

JSON_SCHEMA_VALIDATION_REPORT(schema, json): report
  Returns a validation report of a JSON value against a given JSON schema. 

Arguments, return value and availability:
  schema: Required. The JSON schema to validate against.
  json: Required. The JSON value to be validated.
  report: Return value. The validation report as a JSON object.
  Available since MySQL 8.0.

Related MySQL functions:

• JSON_SCHEMA_VALID() - JSON Schema Validation
• JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report

⇒ JSON_SEARCH() - Searching String in JSON

⇐ JSON_SCHEMA_VALID() - JSON Schema Validation

⇑ MySQL Functions on JSON Values

⇑⇑ MySQL Function References