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


1
2
3
4
5
6
7
8
9
10

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

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