[ https://issues.apache.org/jira/browse/FLINK-32026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
xueyongyang updated FLINK-32026: -------------------------------- Issue Type: Bug (was: Improvement) > jdbc-3.1.0-1.16 left join conversion error > ------------------------------------------ > > Key: FLINK-32026 > URL: https://issues.apache.org/jira/browse/FLINK-32026 > Project: Flink > Issue Type: Bug > Components: Connectors / JDBC > Affects Versions: jdbc-3.1.0 > Environment: flink1.16.1 > mysql8.0.33 > jdbc-3.1.0-1.16 > Reporter: xueyongyang > Priority: Major > > I have a sql, > insert into test_flink_res2(id,name,address) > select a.id,a.name,a.address from test_flink_res1 a left join test_flink_res2 > b on a.id=b.id where a.name='abc0.11317691217472489' and b.id is null; > *Why does flinksql convert this statement into the following statement?* > SELECT `address` FROM `test_flink_res1` WHERE ((`name` = > 'abc0.11317691217472489')) AND ((`id` IS NULL)) > *As a result, there is no data in test_flink_res2,why?* -- This message was sent by Atlassian Jira (v8.20.10#820010)