[IMPALA-12042] Invalid casts in set operations calculation

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: Impala 4.3.0
• Fix Version/s: Impala 4.3.0
• Component/s: fe
• Epic Color: ghx-label-1
• Assignee: Peter Rozsa
• Reporter: Peter Rozsa
• Created: 05/Apr/23 07:45
• Updated: 29/May/23 02:16
• Resolved: 11/May/23 11:37

Description

Invalid implicit casts are produced when a set operation contains transitive compatibility, for example: 

values (true), (123), (111.0)

 where boolean(true) is compatible with tinyint(123) and tinyint is compatible with decimal(111.0) but boolean is not compatible with decimal nonetheless 'castToSetOpCompatibleTypes' produces decimal as a compatible type.

 

If the condition described above exists, FE fails with 

IllegalStateException: cast BOOLEAN to DECIMAL(4,1)