[IMPALA-1652] Fix CHAR datatype: Incorrect results with basic predicate on CHAR typed column.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.1, Impala 2.3.0
• Component/s: Backend
• Labels: correctness downgraded usability
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Alexander Behm
• Created: 09/Jan/15 20:16
• Updated: 15/Sep/23 18:38

Description

Repro:

create table foo(col1 char(10));
insert into foo values (cast('test1' as char(10)));
select * from foo where col1 = 'test1'; <-- returns an empty result set
select * from foo where col1 = cast('test1' as char(10)); <-- correctly returns 1 row

Issue Links

• is related to: IMPALA-11321 Cannot compare char to varchar
• is related to: IMPALA-2172 length(CHAR) doesn't consider trailing space
• relates to: HIVE-24040 Slightly odd behaviour with CHAR comparisons and string literals