[FLINK-27379] CodeGenException: Unable to find common type of

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.13.1, 1.15.0
• Component/s: Connectors / Hive
• Assignee: Unassigned
• Reporter: tartarus
• Created: 25/Apr/22 06:38
• Updated: 10/Jun/22 02:50
• Resolved: 10/Jun/22 02:50

Description

We can reproduce through a UT

Add test case in HiveDialectITCase

@Test
public void testUnableToFindCommonType() {
    tableEnv.executeSql("create table t1 (id bigint, name string, is_normal_play boolean)");
    tableEnv.executeSql("select * from t1 where (name = '111' or name = '222') and is_normal_play = 'true'");
} 

Issue Links

• is duplicated by: FLINK-26771 Fix incomparable exception between boolean type and numeric type in Hive dialect