Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 28 Jul 2015 20:11:04 +0000 (UTC)
From: "Aihua Xu (JIRA)" <jira@apache.org>
To: dev@hive.apache.org
Message-ID: <JIRA.12849727.1438114231000.311514.1438114264916@Atlassian.JIRA>
In-Reply-To: <JIRA.12849727.1438114231000@Atlassian.JIRA>
References: <JIRA.12849727.1438114231000@Atlassian.JIRA>
 <JIRA.12849727.1438114231141@arcas>
Subject: [jira] [Created] (HIVE-11392) Trailing spaces in char comparisons
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Aihua Xu created HIVE-11392:
-------------------------------

             Summary: Trailing spaces in char comparisons
                 Key: HIVE-11392
                 URL: https://issues.apache.org/jira/browse/HIVE-11392
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 2.0.0
            Reporter: Aihua Xu


Following on HIVE-3745, for char type, hive should ignore trailing spaces for comparison while it seems not the case. 

{noformat}
create table chtest (a char(4));
insert into chtest values ('1');
select * from chtest where a='1'; # no whitespace, produces result 
select * from chtest where a='1  '; # 2 spaces, no result
select * from chtest where a='1  '; # 3 spaces, no result 
select * from chtest where a=cast('1 ' as char(4)); # any amount of spaces, cast to char of same length, produces result
{noformat}

It's not consistent.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)