JSON Schema Validation Functions • reason : A human-readable string containing the reason for the failure • schema-location : A JSON pointer URI fragment identifier indicating where in the JSON schema the validation failed (see Note following this list) • document-location : A JSON pointer URI fragment identifier indicating where in the JSON document the validation failed (see Note following this list) • schema-failed-keyword : A string containing the name of the keyword or property in the JSON schema that was violated mysql>  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", ’> "minimum": -90, ’> "maximum": 90 ’> }, ’> "longitude": { ’> "type": "number", ’> "minimum": -180, ’> "maximum": 180 ’> } ’>  }, ’>  "required": ["latitude", "longitude"] ’> }’; Query OK, 0 rows affected (0.01 sec) mysql>  SET @document = ’{ ’>  "latitude": 63.444697, ’>  "longitude": 10.445118 ’> }’; Query OK, 0 rows affected (0.00 sec) mysql>  SELECT JSON_SCHEMA_VALIDATION_REPORT(@schema, @document); +---------------------------------------------------+ | JSON_SCHEMA_VALIDATION_REPORT(@schema, @document) | +---------------------------------------------------+ | {"valid": true} | +---------------------------------------------------+ 2385 In this example, we set a user variable  @schema  to the value of a a JSON schema for geographical coordinates, and another one  @document  to the value of a JSON document containing one such coordinate. We then verify that  @document  validates according to  @schema  by using them as the arguments to  JSON_SCHEMA_VALIDATION_REORT() : JSON pointer URI fragment identifiers are defined in RFC 6901 - JavaScript Object Notation (JSON) Pointer. (These are  not  the same as the JSON path notation used by  JSON_EXTRACT()  and other MySQL JSON functions.) In this notation,  #  represents the entire document, and  #/myprop  represents the portion of the document included in the top-level property named  myprop . See the specification just cited and the examples shown later in this section for more information. Note