summaryrefslogtreecommitdiff
path: root/test/sql/test_compare.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_compare.py')
-rw-r--r--test/sql/test_compare.py10
1 files changed, 10 insertions, 0 deletions
diff --git a/test/sql/test_compare.py b/test/sql/test_compare.py
index 365ed52b2..188d9337e 100644
--- a/test/sql/test_compare.py
+++ b/test/sql/test_compare.py
@@ -491,6 +491,16 @@ class CoreFixtures(object):
select(table_a.c.a).join(table_c, table_a.c.a == table_c.c.x),
),
lambda: (
+ select(table_a.c.a),
+ select(table_a.c.a).add_cte(table_b.insert().cte()),
+ table_a.insert(),
+ table_a.delete(),
+ table_a.update(),
+ table_a.insert().add_cte(table_b.insert().cte()),
+ table_a.delete().add_cte(table_b.insert().cte()),
+ table_a.update().add_cte(table_b.insert().cte()),
+ ),
+ lambda: (
select(table_a.c.a).cte(),
select(table_a.c.a).cte(recursive=True),
select(table_a.c.a).cte(name="some_cte", recursive=True),