[
https://issues.apache.org/jira/browse/CALCITE-7562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Nuyanzin updated CALCITE-7562:
-------------------------------------
Description:
In CALCITE-6435 there was removed {{ensureType}} while handling {{IN}}
expressions.
The problem appears when there are types which might be coerced with default
settings however type coercion is disabled.
For instance
{code:sql}
date_1 in ('2000-01-01', '2002-02-02')
{code}
was:
In CALCITE-6435 there was removed {{ensureType}} while handling {{IN}}
expressions.
The problem appears when there are types which might be coerced with default
settings however type coercion is disables.
For instance
{code:sql}
date_1 in ('2000-01-01', '2002-02-02')
{code}
> SqlToRel misses CAST in case IN expression without type coercion
> ----------------------------------------------------------------
>
> Key: CALCITE-7562
> URL: https://issues.apache.org/jira/browse/CALCITE-7562
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Sergey Nuyanzin
> Assignee: Sergey Nuyanzin
> Priority: Major
>
> In CALCITE-6435 there was removed {{ensureType}} while handling {{IN}}
> expressions.
> The problem appears when there are types which might be coerced with default
> settings however type coercion is disabled.
> For instance
> {code:sql}
> date_1 in ('2000-01-01', '2002-02-02')
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
