[jira] [Commented] (CALCITE-7562) SqlToRel misses CAST in case IN expression without type coercion

["Mihai Budiu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-7562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18083981#comment-18083981 ] 

Mihai Budiu commented on CALCITE-7562:
--------------------------------------

 I never really understood what it means to "disable type coercion".

You are actually performing type coercion here. What is the result supposed to be if coercion is disabled?

 

> 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
>              Labels: pull-request-available
>
> 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)