Dawid Wysakowicz created FLINK-34507:
----------------------------------------
Summary: 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
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)
