xueyongyang created FLINK-32026: ----------------------------------- Summary: 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: Improvement Components: Connectors / JDBC Affects Versions: jdbc-3.1.0 Environment: flink1.16.1
mysql8.0.33 jdbc-3.1.0-1.16 Reporter: xueyongyang 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)