godfreyhe commented on code in PR #20303:
URL: https://github.com/apache/flink/pull/20303#discussion_r939906925
##########
flink-table/flink-table-planner/src/test/scala/org/apache/flink/table/planner/runtime/batch/sql/join/JoinITCase.scala:
##########
@@ -770,6 +773,214 @@ class JoinITCase(expectedJoinType: JoinType) extends
BatchTestBase {
)
}
+ @Test
+ def testLeftOuterJoinReorder(): Unit = {
+ // This test is used to test the result after join to multi join and join
reorder.
+ tEnv.getConfig.set(
+ OptimizerConfigOptions.TABLE_OPTIMIZER_JOIN_REORDER_ENABLED,
+ Boolean.box(true))
+ // Register table with stats to support join reorder,
+ // join order LJ(LJ(LJ(T5, T3), T2), T1) will reorder to RJ(T1, LJ(T2,
LJ(T5, T3)))
+ registerCollection(
Review Comment:
could you use ddl to create test tables ? such as: create table xxx, and
Catalog#alterTableStatistics ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
