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] [Resolved] (HIVE-21310) Hashcode of a varchar column is incorrect if its folded
Date Fri, 01 Mar 2019 13:26:00 GMT

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

Zoltan Haindrich resolved HIVE-21310.
-------------------------------------
    Resolution: Duplicate

duplicate of HIVE-21316 ; testcase will be added in that ticket

> Hashcode of a varchar column is incorrect if its folded
> -------------------------------------------------------
>
>                 Key: HIVE-21310
>                 URL: https://issues.apache.org/jira/browse/HIVE-21310
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltan Haindrich
>            Priority: Major
>
> {code:sql}
> create table t (a varchar(10));
> insert into t values('bee'),('xxx');
> -- select  t0.v,t1.v from
> select       assert_true(t0.v = t1.v) from
>         (select hash(a) as v from t where a='bee') as t0 
> join    (select hash(a) as v from t where a='bee' or a='xbee') as t1 on (true);
> {code}
> the assertion fails because: {{97410 != 127201}}



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

Mime
View raw message