[
https://issues.apache.org/jira/browse/CALCITE-4785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17416894#comment-17416894
]
Viliam Durina commented on CALCITE-4785:
----------------------------------------
Unfortunately I don't have access to the standard. Oracle reports it as error.
And it also makes sense because SQL is a declarative language and expressions
coming later don't override expressions coming before them.
Validator/parser reporting the error - doesn't matter to the end user much.
> 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
> Priority: Minor
>
> The following expression parses succesfully:
> {{JSON_VALUE('bad-json', '$' DEFAULT 1 ON ERROR DEFAULT 2 ON ERROR)}}
> The 2nd ON ERROR clause overrides the 1st one and the expression returns
> {{2}}. Instead, an error should be thrown.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
