xuyang created FLINK-29280: ------------------------------ Summary: Hint will not be 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
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)