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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: fe
• Epic Color: ghx-label-4
• Assignee: Peter Rozsa
• Reporter: Peter Rozsa
• Created: 14/Jul/23 08:28
• Updated: 17/Jul/23 08:19
• Resolved: 17/Jul/23 07:58

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