[ https://issues.apache.org/jira/browse/FLINK-31477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Leonard Xu resolved FLINK-31477. -------------------------------- Resolution: Fixed Fixed in release-1.16 : 1bd25a48fa444390971149515810d057324b642b > 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 > Assignee: Yunhong Zheng > Priority: Major > Labels: pull-request-available > 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)