From c439671a05e4c20703937f08fc85eb1edf6313c9 Mon Sep 17 00:00:00 2001 From: Eric Masseran Date: Sat, 10 Jul 2021 23:08:49 +0200 Subject: [PATCH] Add a non nesting cte --- test/sql/test_cte.py | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/test/sql/test_cte.py b/test/sql/test_cte.py index 8643fa3f0a..a2e5a2726e 100644 --- a/test/sql/test_cte.py +++ b/test/sql/test_cte.py @@ -1405,12 +1405,14 @@ class NestingCTETest(fixtures.TestBase, AssertsCompiledSQL): nesting_cte = select([literal(1).label("val")]).cte( "nesting_cte", nesting=True ) - stmt = select([nesting_cte.c.val]) + cte = select([literal(2).label("val")]).cte("cte") + stmt = select([nesting_cte.c.val, cte.c.val]) self.assert_compile( stmt, - "WITH nesting_cte AS (SELECT %(param_1)s AS val) " - "SELECT nesting_cte.val FROM nesting_cte", + "WITH nesting_cte AS (SELECT %(param_1)s AS val)" + ", cte AS (SELECT %(param_2)s AS val)" + " SELECT nesting_cte.val, cte.val AS val_1 FROM nesting_cte, cte", dialect="postgresql", ) -- 2.47.3