[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288358#comment-17288358 ] WeiNan Zhao commented on FLINK-21162: - [~jark] ok,i will do it > FLINK SQL IF funct

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288298#comment-17288298 ] Jark Wu commented on FLINK-21162: - [~ZhaoWeiNan], Yes. I think this is a bug in {{RexSim

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288247#comment-17288247 ] WeiNan Zhao commented on FLINK-21162: - [~jark] ,Hello,when i debug,i found that when

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288158#comment-17288158 ] WeiNan Zhao commented on FLINK-21162: - |if (!${castedNeedle.nullTerm}) { | $resultTe

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288149#comment-17288149 ] WeiNan Zhao commented on FLINK-21162: - [~ykt836] Thanks for the investigation [~ykt8

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288145#comment-17288145 ] Jark Wu commented on FLINK-21162: - Thanks for the investigation [~ykt836], I also checke

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288143#comment-17288143 ] Kurt Young commented on FLINK-21162: I don't we should change this behavior. I check

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288139#comment-17288139 ] Jark Wu commented on FLINK-21162: - Yes. I think {{null IN (...)}} should return unknown,

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17287869#comment-17287869 ] WeiNan Zhao commented on FLINK-21162: - [~jark] [code: testSqlApi("f14 IN ('This is

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17278558#comment-17278558 ] WeiNan Zhao commented on FLINK-21162: - [~hiscat] I debug your sql and found that col

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17272764#comment-17272764 ] Jark Wu commented on FLINK-21162: - Sounds like a bug in code generation. > FLINK SQL I

[jira] [Commented] (FLINK-21162) FLINK SQL IF function semantic incorrect

[ https://issues.apache.org/jira/browse/FLINK-21162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17272735#comment-17272735 ] 谢波 commented on FLINK-21162: I using the COALESCE(return_flag, '') solve the problem, but i