[IMPALA-10086] SqlCastException when comparing char with varchar

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 4.0.0, Impala 3.3.0
• Fix Version/s: Impala 4.3.0
• Component/s: Frontend
• Labels: newbie ramp-up
• Epic Color: ghx-label-10
• Assignee: Michael Smith
• Reporter: Tim Armstrong
• Created: 15/Aug/20 00:22
• Updated: 15/Sep/23 18:38
• Resolved: 12/Sep/23 16:16

Description

[localhost:21000] default> select 'expected 2',count(*) from ax where cast(t as string) = cast('a         ' as varchar(10));
+--------------+----------+
| 'expected 2' | count(*) |
+--------------+----------+
| expected 2   | 2        |
+--------------+----------+
Fetched 1 row(s) in 0.44s
[localhost:21000] default> create table chartbl (c char(10));
+-------------------------+
| summary                 |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.23s
[localhost:21000] default> select * from chartbl where c = cast('test' as varchar(10));
ERROR: SqlCastException: targetType=VARCHAR(*) type=VARCHAR(10)

Also using the functional dataset:

[localhost:21000] functional> select * from chars_tiny where cs = vc;
ERROR: SqlCastException: targetType=VARCHAR(*) type=VARCHAR(5)

Issue Links

• is caused by: IMPALA-7368 Add initial support for DATE type
• is duplicated by: IMPALA-11321 Cannot compare char to varchar