[
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)
