Benoit Hanotte created CALCITE-2767:
---------------------------------------
Summary: Invalid operands for Case operator in
RexSqlStandardConvertletTable
Key: CALCITE-2767
URL: https://issues.apache.org/jira/browse/CALCITE-2767
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.18.0
Reporter: Benoit Hanotte
Assignee: Julian Hyde
`SqlCaseOperator.createCall()` requires 4 operands [1]:
# first value (i.e. `CASE value WHEN...`)
# when condifitions (as SqlNodeList)
# then values (as SqlNodeLists)
# else value
`RexSqlStandardConvertletTable` always only pass 3 arguments [2] as it uses the
generic form such as `CASE WHEN condition1(val1) THEN val2 ... ELSE val3 END`
and never the form `CASE val WHEN cond1 THEN val2 ELSE val3`.
When calling `SqlCaseOperator.createCall()`, it needs to pass a null sql node
for first value in order to correctly provide the 4 expected arguments and not
only the last 3.
[1]
https://github.com/apache/calcite/blob/59b76701d9c805f51b0929577ca604fdbfe00b0b/core/src/main/java/org/apache/calcite/sql/fun/SqlCaseOperator.java#L288
[2]
https://github.com/apache/calcite/blob/59b76701d9c805f51b0929577ca604fdbfe00b0b/core/src/main/java/org/apache/calcite/rex/RexSqlStandardConvertletTable.java#L239
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
