[ https://issues.apache.org/jira/browse/FLINK-29280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
godfrey he closed FLINK-29280. ------------------------------ Resolution: Fixed Fixed in master: 22cb554008320e6684280b5205f93d7a6f685c6c in 1.16.0: b37a8153f22b62982ca144604a34056246f6f36c > Join hint are not propagated in subquery > ---------------------------------------- > > Key: FLINK-29280 > URL: https://issues.apache.org/jira/browse/FLINK-29280 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Affects Versions: 1.16.0 > Reporter: xuyang > Assignee: xuyang > Priority: Major > Labels: pull-request-available > > Add the following code in JoinHintTestBase to re-produce this bug. > {code:java} > @Test > public void testJoinHintWithJoinHintInSubQuery() { > String sql = > "select * from T1 WHERE a1 IN (select /*+ %s(T2) */ a2 from T2 > join T3 on T2.a2 = T3.a3)"; > verifyRelPlanByCustom(String.format(sql, > buildCaseSensitiveStr(getTestSingleJoinHint()))); > } {code} > This is because that calcite will not propagate the hint in subquery and > flink also doesn't resolve it in FlinkSubQueryRemoveRule -- This message was sent by Atlassian Jira (v8.20.10#820010)