summaryrefslogtreecommitdiff
path: root/test/sql/test_compiler.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_compiler.py')
-rw-r--r--test/sql/test_compiler.py11
1 files changed, 11 insertions, 0 deletions
diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py
index 140de8622..acf16ca1c 100644
--- a/test/sql/test_compiler.py
+++ b/test/sql/test_compiler.py
@@ -4309,6 +4309,17 @@ class StringifySpecialTest(fixtures.TestBase):
"SELECT anon_1.myid FROM anon_1",
)
+ @testing.combinations(("cte",), ("alias",), ("subquery",))
+ def test_grouped_selectables_print_alone(self, modifier):
+ stmt = select(table1).where(table1.c.myid == 10)
+
+ grouped = getattr(stmt, modifier)()
+ eq_ignore_whitespace(
+ str(grouped),
+ "SELECT mytable.myid, mytable.name, "
+ "mytable.description FROM mytable WHERE mytable.myid = :myid_1",
+ )
+
def test_next_sequence_value(self):
# using descriptive text that is intentionally not compatible
# with any particular backend, since all backends have different