vldpyatkov commented on code in PR #13562:
URL: https://github.com/apache/ignite/pull/13562#discussion_r3967651434
##########
modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/integration/RecursiveCteIntegrationTest.java:
##########
@@ -31,6 +31,32 @@ public class RecursiveCteIntegrationTest extends
AbstractBasicIntegrationTest {
/** Number of invocations of a non-deterministic function. */
private static final AtomicInteger nonDeterministicCallCnt = new
AtomicInteger();
+ /** Explicit and inferred recursion must produce the same rows. */
+ @Test
+ public void testOptionalRecursiveKeyword() {
+ for (String keyword : new String[] {"", "RECURSIVE "}) {
+ assertQuery("WITH " + keyword + "seed(n) AS (SELECT 1), numbers(n)
AS (" +
+ "SELECT n FROM seed UNION ALL SELECT n + 1 FROM numbers WHERE
n < 3), " +
+ "result AS (SELECT * FROM numbers) SELECT * FROM result")
+ .returns(1)
+ .returns(2)
+ .returns(3)
+ .check();
+
+ assertQuery("SELECT * FROM (WITH " + keyword + "\"Numbers\"(n) AS
(" +
+ "SELECT 1 UNION ALL SELECT x.n + 1 FROM \"Numbers\" x WHERE
x.n < 3) " +
+ "SELECT * FROM \"Numbers\")")
+ .returns(1)
+ .returns(2)
+ .returns(3)
+ .check();
+
+ assertThrows("WITH " + keyword + "numbers(n) AS (" +
Review Comment:
assertThrowsSqlException fails here because Calcite wraps the
_IgniteSQLException_ in a _RuntimeException_.
--
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]
