[ https://issues.apache.org/jira/browse/CALCITE-6478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-6478: ------------------------------------ Labels: pull-request-available (was: ) > JSON functions should return NULL when input is NULL > ----------------------------------------------------- > > Key: CALCITE-6478 > URL: https://issues.apache.org/jira/browse/CALCITE-6478 > Project: Calcite > Issue Type: Improvement > Reporter: xiong duan > Priority: Major > Labels: pull-request-available > > Here is the test in H2: > {code:java} > SELECT js, > js IS JSON "json?", > js IS JSON value "json?", > js IS JSON SCALAR "scalar?", > js IS JSON OBJECT "object?", > js IS JSON ARRAY "array?" > FROM (VALUES ('123'), > ('"abc"'), > ('{"a": "b"}'), > ('[1,2]'), > ('abc'), NULL) foo(js); > {code} > {code:java} > +----------+-----+-----+-------+-------+------+ > |JS |json?|json?|scalar?|object?|array?| > +----------+-----+-----+-------+-------+------+ > |123 |true |true |true |false |false | > |"abc" |true |true |true |false |false | > |{"a": "b"}|true |true |false |true |false | > |[1,2] |true |true |false |false |true | > |abc |false|false|false |false |false | > |null |null |null |null |null |null | > +----------+-----+-----+-------+-------+------+ > {code} > Same SQL in Calcite: > {code:java} > +------------+-------+-------+---------+---------+--------+ > | JS | json? | json? | scalar? | object? | array? | > +------------+-------+-------+---------+---------+--------+ > | "abc" | true | true | true | false | false | > | 123 | true | true | true | false | false | > | [1,2] | true | true | false | false | true | > | abc | false | false | false | false | false | > | {"a": "b"} | true | true | false | true | false | > | | false | false | false | false | false | > +------------+-------+-------+---------+---------+--------+ > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)