[
https://issues.apache.org/jira/browse/FLINK-29280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
godfrey he updated FLINK-29280:
-------------------------------
Fix Version/s: 1.16.0
1.17.0
> 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
> Fix For: 1.16.0, 1.17.0
>
>
> 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)
