diff options
Diffstat (limited to 'test/dialect/postgresql/test_compiler.py')
| -rw-r--r-- | test/dialect/postgresql/test_compiler.py | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/test/dialect/postgresql/test_compiler.py b/test/dialect/postgresql/test_compiler.py index 20732067d..ce285007f 100644 --- a/test/dialect/postgresql/test_compiler.py +++ b/test/dialect/postgresql/test_compiler.py @@ -1234,6 +1234,27 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): "%(param_1)s = ANY (x)", checkparams={"param_1": 4}, ) + + self.assert_compile( + c.any(5), "%(param_1)s = ANY (x)", checkparams={"param_1": 5}, + ) + + self.assert_compile( + ~c.any(5), + "NOT (%(param_1)s = ANY (x))", + checkparams={"param_1": 5}, + ) + + self.assert_compile( + c.all(5), "%(param_1)s = ALL (x)", checkparams={"param_1": 5}, + ) + + self.assert_compile( + ~c.all(5), + "NOT (%(param_1)s = ALL (x))", + checkparams={"param_1": 5}, + ) + self.assert_compile( c.any(5, operator=operators.ne), "%(param_1)s != ANY (x)", |