summaryrefslogtreecommitdiff
path: root/test/sql/test_operators.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_operators.py')
-rw-r--r--test/sql/test_operators.py16
1 files changed, 16 insertions, 0 deletions
diff --git a/test/sql/test_operators.py b/test/sql/test_operators.py
index dd9f76cd6..82c69003b 100644
--- a/test/sql/test_operators.py
+++ b/test/sql/test_operators.py
@@ -912,6 +912,14 @@ class BooleanEvalTest(fixtures.TestBase, testing.AssertsCompiledSQL):
dialect=self._dialect(False),
)
+ def test_three_a_double(self):
+ c = column("x", Boolean)
+ self.assert_compile(
+ select([c]).where(~~c),
+ "SELECT x WHERE x = 1",
+ dialect=self._dialect(False),
+ )
+
def test_three_b(self):
c = column("x", Boolean)
self.assert_compile(
@@ -928,6 +936,14 @@ class BooleanEvalTest(fixtures.TestBase, testing.AssertsCompiledSQL):
dialect=self._dialect(True),
)
+ def test_four_double(self):
+ c = column("x", Boolean)
+ self.assert_compile(
+ select([c]).where(~~c),
+ "SELECT x WHERE x",
+ dialect=self._dialect(True),
+ )
+
def test_five_a(self):
c = column("x", Boolean)
self.assert_compile(