yql/essentials/tests/sql/suites/json/json_exists/on_error_exception.sql


1
2
3
4
5
6

/* custom error:Member not found*/

-- Accessing absent object member will cause jsonpath error in strict mode
$json = CAST("{}" as Json);
SELECT
    JSON_EXISTS($json, "strict $.key" ERROR ON ERROR);