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)
