xiedeyantu commented on code in PR #4392:
URL: https://github.com/apache/calcite/pull/4392#discussion_r2151884030
##########
core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java:
##########
@@ -10785,4 +10785,61 @@ private void
checkLoptOptimizeJoinRule(LoptOptimizeJoinRule rule) {
.withRule(CoreRules.HYPER_GRAPH_OPTIMIZE, CoreRules.PROJECT_REMOVE,
CoreRules.PROJECT_MERGE)
.check();
}
+
+ @Test void testVariousJoinTypeForDphyp() {
+ HepProgram program = new HepProgramBuilder()
+ .addMatchOrder(HepMatchOrder.BOTTOM_UP)
+ .addRuleInstance(CoreRules.PROJECT_MERGE)
+ .addRuleInstance(CoreRules.PROJECT_TO_SEMI_JOIN)
+ .addRuleInstance(CoreRules.JOIN_TO_HYPER_GRAPH)
+ .build();
+
+ sql("select emp.empno from "
+ + "emp_address inner join emp on emp_address.empno = emp.empno "
+ + "left join dept on emp.deptno = dept.deptno "
+ + "where exists(select * from dept_nested where dept.deptno =
dept_nested.deptno)")
+ .withExpand(true)
+ .withDecorrelate(true)
+ .withPre(program)
+ .withRule(CoreRules.HYPER_GRAPH_OPTIMIZE, CoreRules.PROJECT_REMOVE,
CoreRules.PROJECT_MERGE)
+ .check();
+ }
+
+ @Test void testVariousJoinTypeForDphyp2() {
Review Comment:
Do not use auto-increment numbers at the end of the test method name, you
need to have a meaningful name.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
