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)
