From 936b28d7da13d4bba630049e93832e63a5256823 Mon Sep 17 00:00:00 2001 From: Eric Masseran Date: Fri, 30 Jul 2021 18:58:51 +0200 Subject: [PATCH] Reorganization of cte is possible --- test/sql/test_cte.py | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/test/sql/test_cte.py b/test/sql/test_cte.py index e9773707ba..45cbea3a88 100644 --- a/test/sql/test_cte.py +++ b/test/sql/test_cte.py @@ -1782,11 +1782,15 @@ class NestingCTETest(fixtures.TestBase, AssertsCompiledSQL): # 2 next 1 - nesting_cte_2_1 = select([select_2_cte, select_1_cte]).cte("cte") + # Reorganize order with add_cte + nesting_cte_2_1 = ( + select([select_2_cte, select_1_cte]) + .add_cte(select_1_cte) + .cte("cte") + ) stmt_2_1 = select([nesting_cte_2_1]) self.assert_compile( stmt_2_1, - # FIXME: nesting_1 is generated 2 times "WITH cte AS (" "WITH nesting_1 AS (SELECT %(param_1)s AS inner_cte_1)" ", nesting_2 AS (SELECT nesting_1.inner_cte_1 + %(inner_cte_1_1)s" -- 2.47.3