Leonard Xu created FLINK-31477: ---------------------------------- Summary: NestedLoopJoinTest.testLeftOuterJoinWithFilter failed on azure Key: FLINK-31477 URL: https://issues.apache.org/jira/browse/FLINK-31477 Project: Flink Issue Type: Bug Components: Table SQL / Planner Affects Versions: 1.16.1 Reporter: Leonard Xu Fix For: 1.16.2
{noformat} Failures: Mar 15 15:52:32 [ERROR] NestedLoopJoinTest.testLeftOuterJoinWithFilter1:37 optimized exec plan expected:<...[InnerJoin], where=[[true], select=[a, e, f], build=[left]) Mar 15 15:52:32 :- Exchange(distribution=[broadcast]) Mar 15 15:52:32 : +- Calc(select=[a], where=[(a = 10)]) Mar 15 15:52:32 : +- LegacyTableSourceScan(table=[[default_catalog, default_database, MyTable1, source: [TestTableSource(a, b, c)]]], fields=[a, b, c]) Mar 15 15:52:32 +- Calc(select=[e, f], where=[(d = 10])]) Mar 15 15:52:32 +- LegacyT...> but was:<...[InnerJoin], where=[[(a = d)], select=[a, d, e, f], build=[left]) Mar 15 15:52:32 :- Exchange(distribution=[broadcast]) Mar 15 15:52:32 : +- Calc(select=[a], where=[SEARCH(a, Sarg[10])]) Mar 15 15:52:32 : +- LegacyTableSourceScan(table=[[default_catalog, default_database, MyTable1, source: [TestTableSource(a, b, c)]]], fields=[a, b, c]) Mar 15 15:52:32 +- Calc(select=[d, e, f], where=[SEARCH(d, Sarg[10]])]) Mar 15 15:52:32 +- LegacyT...>{noformat} https://dev.azure.com/apache-flink/apache-flink/_build/results?buildId=47202&view=logs&j=086353db-23b2-5446-2315-18e660618ef2&t=6cd785f3-2a2e-58a8-8e69-b4a03be28843 -- This message was sent by Atlassian Jira (v8.20.10#820010)