[ 
https://issues.apache.org/jira/browse/FLINK-27379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17527922#comment-17527922
 ] 

luoyuxia commented on FLINK-27379:
----------------------------------

More detail analysis is in 
[FLINK-27407|https://issues.apache.org/jira/browse/FLINK-27407].

At end, I prefer to fix it in 
[FLINK-26771|https://issues.apache.org/jira/browse/FLINK-26771] for the root 
cause is same. Both of them are it's not supported to cast boolean to 
string/int implicitly.

> CodeGenException: Unable to find common type of
> -----------------------------------------------
>
>                 Key: FLINK-27379
>                 URL: https://issues.apache.org/jira/browse/FLINK-27379
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Connectors / Hive
>    Affects Versions: 1.13.1, 1.15.0
>            Reporter: tartarus
>            Priority: Major
>
> We can reproduce through a UT
> Add test case in HiveDialectITCase
> {code:java}
> @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'");
> } {code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to