yql/essentials/tests/sql/suites/json/json_query/on_error.sql


1
2
3
4
5
6
7
8
9
10

/* syntax version 1 */
/* postgres can not */

-- Accessing absent object member will cause jsonpath error in strict mode
$json = CAST("{}" as Json);
SELECT
    JSON_QUERY($json, "strict $.key"), -- defaults to NULL ON ERROR
    JSON_QUERY($json, "strict $.key" NULL ON ERROR),
    JSON_QUERY($json, "strict $.key" EMPTY ARRAY ON ERROR),
    JSON_QUERY($json, "strict $.key" EMPTY OBJECT ON ERROR);