[IMPALA-12285] Type mismatch in set operations with ALLOW_UNSAFE_CASTS enabled

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.4.0
• Component/s: Frontend
• Epic Color: ghx-label-4
• Assignee: Peter Rozsa
• Reporter: Peter Rozsa
• Created: 14/Jul/23 08:28
• Updated: 16/Jul/24 23:45
• Resolved: 16/Jul/24 23:45

Description

INSERT INTO iobt(c0) VALUES ("0"), (15629);

hit DCHECK in tuple.cc:233; the common type calculation resolves to smallint due to 15629, but literal casting does not respect the target type, and transforms the string literal to tinyint type.

Issue Links

• is caused by: IMPALA-10173 Allow implicit casts between numeric and string types when inserting into table