[jira] [Updated] (HIVE-23229) CAST to string on column instead of simplification over literal column

["Jesus Camacho Rodriguez (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-23229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated HIVE-23229:
-------------------------------------------
    Target Version/s: 4.0.0

> CAST to string on column instead of simplification over literal column
> ----------------------------------------------------------------------
>
>                 Key: HIVE-23229
>                 URL: https://issues.apache.org/jira/browse/HIVE-23229
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>            Reporter: Jesus Camacho Rodriguez
>            Priority: Major
>
> After HIVE-23100 went in, we end up for one of the queries with CAST over a column instead of applying CAST on literal and comparing in CHAR, which can be seen in ql/src/test/results/clientpositive/in_typecheck_char.q.out .
> {code}
>              filterExpr: (((s = 'a') and (t = 'a         ')) or (null and (t = 'bb        '))) is null (type: boolean) 
> {code}
> was replaced by:
> {code}
>              filterExpr: (((CAST( s AS STRING) = 'a') and (CAST( t AS STRING) = 'a')) or (null and (CAST( t AS STRING) = 'bb'))) is null (type: boolean)
> {code}
> Probably this is as a result of the changes introduced in HIVE-23100 wrt IN handling.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)