diff options
Diffstat (limited to 'test/sql/test_operators.py')
-rw-r--r-- | test/sql/test_operators.py | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/test/sql/test_operators.py b/test/sql/test_operators.py index e5835a749..fcf40ebbd 100644 --- a/test/sql/test_operators.py +++ b/test/sql/test_operators.py @@ -3045,6 +3045,15 @@ class AnyAllTest(fixtures.TestBase, testing.AssertsCompiledSQL): checkparams={"param_1": 5}, ) + def test_any_array_comparator_negate_accessor(self, t_fixture): + t = t_fixture + + self.assert_compile( + ~t.c.arrval.any(5, operator.gt), + "NOT (:param_1 > ANY (tab1.arrval))", + checkparams={"param_1": 5}, + ) + def test_all_array_comparator_accessor(self, t_fixture): t = t_fixture @@ -3054,6 +3063,15 @@ class AnyAllTest(fixtures.TestBase, testing.AssertsCompiledSQL): checkparams={"param_1": 5}, ) + def test_all_array_comparator_negate_accessor(self, t_fixture): + t = t_fixture + + self.assert_compile( + ~t.c.arrval.all(5, operator.gt), + "NOT (:param_1 > ALL (tab1.arrval))", + checkparams={"param_1": 5}, + ) + def test_any_array_expression(self, t_fixture): t = t_fixture |