summaryrefslogtreecommitdiff
path: root/test/sql
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql')
-rw-r--r--test/sql/test_compiler.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py
index 6779ea7bf..55c2b07c4 100644
--- a/test/sql/test_compiler.py
+++ b/test/sql/test_compiler.py
@@ -1241,6 +1241,14 @@ class SelectTest(fixtures.TestBase, AssertsCompiledSQL):
"SELECT NOT (NOT (EXISTS (SELECT 1))) AS anon_1",
)
+ self.assert_compile(
+ exists(42)
+ .select_from(table1)
+ .where(table1.c.name == "foo", table1.c.description == "bar"),
+ "EXISTS (SELECT 42 FROM mytable WHERE mytable.name = :name_1 "
+ "AND mytable.description = :description_1)",
+ )
+
def test_exists_method(self):
subq = (
select(func.count(table2.c.otherid))