Viliam Durina created CALCITE-4785:
--------------------------------------
Summary: The parser allows multiple ON ERROR or ON EMPTY clauses
for JSON_QUERY and JSON_VALUE
Key: CALCITE-4785
URL: https://issues.apache.org/jira/browse/CALCITE-4785
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.27.0
Reporter: Viliam Durina
The following expression parses succesfully:
{{JSON_QUERY('bad-json', '$' DEFAULT 1 ON ERROR DEFAULT 2 ON ERROR)}}
The 2nd ON ERROR clause overrides the 1st one and it returns {{2}}. Instead, an
error should be thrown.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)