[ https://issues.apache.org/jira/browse/CALCITE-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pengzhiwei updated CALCITE-2311: -------------------------------- Description: If the case-when expression has two branches which returns string literal,redundant white space will append to the short string literal after the ReduceExpressionsRule. For example: {code:java} case when id>0 then 'a' else 'abc' end{code} will actually be convert to {code:java} case when id>0 then 'a ' else 'abc' end{code} The reason is that the type of 'a' is CHAR(1),but CHAR(3) for 'abc',so the return type of the case-when is CHAR(3). The RexBuilder#ensureType() method append a cast convertion for 'a' to cast it to CHAR(3) type.The ReduceExpressionsRule execute the cast convertion which fill two whilte space to 'a'. was: If case when has two brach which returns string literal,redundant white space will append to the short brach.For example: {code:java} case when id>0 then 'a' else 'abc' end{code} will actually be convert to {code:java} case when id>0 then 'a ' else 'abc' end{code} > case when returns redundant white space > --------------------------------------- > > Key: CALCITE-2311 > URL: https://issues.apache.org/jira/browse/CALCITE-2311 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.1.0-incubating > Reporter: pengzhiwei > Assignee: Julian Hyde > Priority: Major > Fix For: 1.17.0 > > > If the case-when expression has two branches which returns string > literal,redundant white space will append to the short string literal after > the ReduceExpressionsRule. For example: > {code:java} > case when id>0 then 'a' else 'abc' end{code} > will actually be convert to > {code:java} > case when id>0 then 'a ' else 'abc' end{code} > > The reason is that the type of 'a' is CHAR(1),but CHAR(3) for 'abc',so the > return type of the case-when is CHAR(3). The RexBuilder#ensureType() method > append a cast convertion for 'a' to cast it to CHAR(3) type.The > ReduceExpressionsRule execute the cast convertion which fill two whilte space > to 'a'. -- This message was sent by Atlassian JIRA (v7.6.3#76005)