libenchao commented on code in PR #3193:
URL: https://github.com/apache/calcite/pull/3193#discussion_r1197490314
##########
core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java:
##########
@@ -6823,6 +6824,65 @@ private void checkSemiJoinRuleOnAntiJoin(RelOptRule
rule) {
.checkUnchanged();
}
+ /** Test case for CALCITE-5683 for two level nested decorrelate with
standard program
+ * failing during the decorrelation phase. */
+ @Test void testTwoLevelDecorrelate() {
Review Comment:
Since the exception is thrown in `RelDecorrelator`, I would try to enable
`withSubQueryRules().withLateDecorrelate(true)` to reproduce the problem.
`QuidemTest` (*.iq) is also a place we can put the tests, usually I will add
tests there if the problem occurs in the 'runtime', or the problem occurs in
earlier phase but we also want to verify the result because the plan is not
easy to verify correctness.
--
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]
