hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zoltan Haindrich (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20617) Fix type of constants in IN expressions to have correct type
Date Tue, 23 Oct 2018 09:49:00 GMT

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

Zoltan Haindrich commented on HIVE-20617:
-----------------------------------------

#10 will also address some more correctness issues

* during in comparision numeric might not have been compared as double as it should.

* mixed numeric and string comparisions in IN: may have missed one either string or numeric
results:
{code}
select * from t where a in (1.0,'x',2);
{code}

* struct containing null might have not compared correctly
{code}
select 'expected 2',count(*) from ax where (s,t) in (('a','a'),(null, 'bb'));
{code}



> Fix type of constants in IN expressions to have correct type
> ------------------------------------------------------------
>
>                 Key: HIVE-20617
>                 URL: https://issues.apache.org/jira/browse/HIVE-20617
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>            Priority: Major
>         Attachments: HIVE-20617.01.patch, HIVE-20617.02.patch, HIVE-20617.03.patch, HIVE-20617.05.patch,
HIVE-20617.06.patch, HIVE-20617.07.patch, HIVE-20617.08.patch, HIVE-20617.08.patch, HIVE-20617.08.patch,
HIVE-20617.08.patch, HIVE-20617.08.patch, HIVE-20617.08.patch, HIVE-20617.08.patch, HIVE-20617.08.patch,
HIVE-20617.09.patch, HIVE-20617.10.patch, HIVE-20617.10.patch, HIVE-20617.11.patch
>
>
> In statements like {{struct(a,b) IN (const struct('x','y'), ... )}} the comparision in
UDFIn may fail because if a or b is of char/varchar type the constants will retain string
type - especially after PointlookupOptimizer compaction.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message