[
https://issues.apache.org/jira/browse/CALCITE-7287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18037720#comment-18037720
]
Steve Carlin commented on CALCITE-7287:
---------------------------------------
[~jensen] This is correct. My original SQL was a VARCHAR cast around the
literal. On the first round of simplification, that became just a literal with
a VARCHAR type, as you mentioned. The second round of simplification
eliminated the reference to VARCHAR.
[~xuzifu666] : I think this will work! I'll try to test today or tomorrow,
thanks for the quick turnaround!
> In simplifyLike, the makeLiteral call does not preserve the RelDataType
> -----------------------------------------------------------------------
>
> Key: CALCITE-7287
> URL: https://issues.apache.org/jira/browse/CALCITE-7287
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.41.0
> Reporter: Steve Carlin
> Priority: Major
> Labels: pull-request-available
>
> In my Calcite code, I have a RexLiteral that is of type RelDataType.VARCHAR
> (the SqlTypeName is always CHAR)
> However, this information is getting lost in the call here
> [https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/rex/RexSimplify.java#L527]
> The result of this simplification gives me a RelDataType.CHAR instead.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
