You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zoltan Haindrich (JIRA)" <ji...@apache.org> on 2018/11/19 12:35:00 UTC
[jira] [Comment Edited] (HIVE-20779) Fix missing results when IN
operator has a struct with a null field
[ https://issues.apache.org/jira/browse/HIVE-20779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16691651#comment-16691651 ]
Zoltan Haindrich edited comment on HIVE-20779 at 11/19/18 12:34 PM:
--------------------------------------------------------------------
sorry; the expected in the above case is 2 - I think I was not entirely in the picture when I've filed the jira...
for {{char(n)}} types the content is "padded" with spaces all the time: so the following evaluates to true
{code}
select cast('a' as char(10)) = cast('a ' as char(10));
{code}
was (Author: kgyrtkirk):
sorry; the expected in the above case is 2 - I think I was not entirely in the picture when I've filed the jira...
for char(n) types the content is "padded" with spaces all the time: so the following evaluates to true
{code}
select cast('a' as char(10)) = cast('a ' as char(10));
{code}
> 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)