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