[
https://issues.apache.org/jira/browse/FLINK-34507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18088167#comment-18088167
]
Qilong Wang commented on FLINK-34507:
-------------------------------------
Based on my observation, the current issue has already been fixed in
[FLINK-36026|https://issues.apache.org/jira/browse/FLINK-36026]
> JSON functions have wrong operand checker
> -----------------------------------------
>
> Key: FLINK-34507
> URL: https://issues.apache.org/jira/browse/FLINK-34507
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 1.18.1
> Reporter: Dawid Wysakowicz
> Priority: Major
>
> I believe that all JSON functions (`JSON_VALUE`, `JSON_QUERY`, ...) have
> wrong operand checker.
> As far as I can tell the first argument (the JSON) should be a `STRING`
> argument. That's what all other systems do (some accept clob/blob
> additionally e.g. ORACLE).
> We via Calcite accept `ANY` type there, which I believe is wrong:
> https://github.com/apache/calcite/blob/c49792f9c72159571f898c5fca1e26cba9870b07/core/src/main/java/org/apache/calcite/sql/fun/SqlJsonValueFunction.java#L61
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
