[jira] [Commented] (HIVE-20779) Fix missing results when IN operator has a struct with a null field

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

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

Zoltan Haindrich commented on HIVE-20779:
-----------------------------------------

[~ikryvenko] latest version of HIVE-20617 will probably also address this - alongside with another IN related resultset issue

> Fix missing results when IN operator has a struct with a null field
> -------------------------------------------------------------------
>
>                 Key: HIVE-20779
>                 URL: https://issues.apache.org/jira/browse/HIVE-20779
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltan Haindrich
>            Assignee: Igor Kryvenko
>            Priority: Major
>
> {code}
> create table ax(s char(1),t char(10));
> insert into ax values ('a','a'),('a','a '),('b','bb');
> select 'expected 1',count(*) from ax where ((s,t) in (('a','a'),(null, 'bb'))) is null;
> -- returns 0 rows
> {code}



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