rubenada commented on code in PR #3480:
URL: https://github.com/apache/calcite/pull/3480#discussion_r1372703471
##########
core/src/test/java/org/apache/calcite/test/SqlValidatorTest.java:
##########
@@ -5232,6 +5232,39 @@ void testReturnsCorrectRowTypeOnCombinedJoin() {
+ "select * from emp2")
.type(EMP_RECORD_TYPE);
+ // simplest with recursive fails
+ sql("with RECURSIVE emp2 as (select * from ^emp2^)\n"
+ + "select * from emp2")
+ .fails("Object 'EMP2' not found");
+
+ sql("with RECURSIVE emp2 as ("
+ + "select * from emp "
+ + " union select * from ^emp2^"
+ + " union select * from emp2"
+ + ")\n"
+ + "select * from emp2")
+ .fails("Object 'EMP2' not found");
+
+ // simplest with RECURSIVE working case.
+ sql("with RECURSIVE emp2 as (select * from emp union select * from emp2)\n"
+ + "select * from emp2")
+ .type(EMP_RECORD_TYPE);
+
+ // union all with recursive working case.
+ sql("with RECURSIVE emp2 as (select * from emp union all select * from
emp2)\n"
+ + "select * from emp2")
+ .type(EMP_RECORD_TYPE);
+
+ // union all with recursive working case.
Review Comment:
minor: this comment seems wrong ("working case" but the test actually checks
for a failure)
--
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]
