[
https://issues.apache.org/jira/browse/CALCITE-4710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17390808#comment-17390808
]
duan xiong commented on CALCITE-4710:
-------------------------------------
This looks like a related issue about CALCITE-4590 ?
> In the special scenario of the case when statement, the constant RexNode
> fails to be parsed.
> --------------------------------------------------------------------------------------------
>
> Key: CALCITE-4710
> URL: https://issues.apache.org/jira/browse/CALCITE-4710
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.20.0, 1.27.0
> Reporter: Data Platform
> Priority: Major
> Labels: features
>
> I found that calcite had problems parsing the "case when" statement since
> version 1.20.0.
> insert into OutputStream select "zz" as name_a, case when xdr.name_b is not
> null then "AAAAA" else "BB" end as name_b from InStream as xdr;
> ----
> use calcite （version：1.20.0）to parse the Streamming SQL:
> in the "case when" statement, The analysis result is not Correct of
> RexLiteral "BB"：
> Result:
> Correct: RexLiteral "AAAAA" : type ="CHAR(5)" , digest="'AAAAA'"
> Error: RexLiteral "BB" : type ="CHAR(5)" , digest="'BB '"
> I found that the parsing result of the constant "BB" is aligned with that of
> the constant "AAAAA", The missing bits are filled with spaces.
> ----
> use calcite （version：1.17.0）to parse the Streamming SQL:
> In the "case when" statement, The analysis result is as expected：
> Result:
> Correct: RexLiteral "AAAAA" : type ="CHAR(5)" , digest="'AAAAA'"
> Correct: RexLiteral "BB" : type ="CHAR(2)" , digest="'BB'"
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
