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.py37
1 files changed, 37 insertions, 0 deletions
diff --git a/test/sql/test_operators.py b/test/sql/test_operators.py
index aa56d0b6b..a90b03b38 100644
--- a/test/sql/test_operators.py
+++ b/test/sql/test_operators.py
@@ -5,6 +5,7 @@ from sqlalchemy import and_
from sqlalchemy import between
from sqlalchemy import exc
from sqlalchemy import Integer
+from sqlalchemy import join
from sqlalchemy import LargeBinary
from sqlalchemy import literal_column
from sqlalchemy import not_
@@ -988,6 +989,42 @@ class BooleanEvalTest(fixtures.TestBase, testing.AssertsCompiledSQL):
or_(false(), true()), "1 = 1", dialect=self._dialect(False)
)
+ def test_seven_a(self):
+ t1 = table("t1", column("a"))
+ t2 = table("t2", column("b"))
+ self.assert_compile(
+ join(t1, t2, onclause=true()),
+ "t1 JOIN t2 ON 1 = 1",
+ dialect=self._dialect(False),
+ )
+
+ def test_seven_b(self):
+ t1 = table("t1", column("a"))
+ t2 = table("t2", column("b"))
+ self.assert_compile(
+ join(t1, t2, onclause=false()),
+ "t1 JOIN t2 ON 0 = 1",
+ dialect=self._dialect(False),
+ )
+
+ def test_seven_c(self):
+ t1 = table("t1", column("a"))
+ t2 = table("t2", column("b"))
+ self.assert_compile(
+ join(t1, t2, onclause=true()),
+ "t1 JOIN t2 ON true",
+ dialect=self._dialect(True),
+ )
+
+ def test_seven_d(self):
+ t1 = table("t1", column("a"))
+ t2 = table("t2", column("b"))
+ self.assert_compile(
+ join(t1, t2, onclause=false()),
+ "t1 JOIN t2 ON false",
+ dialect=self._dialect(True),
+ )
+
def test_eight(self):
self.assert_compile(
and_(false(), true()), "false", dialect=self._dialect(True)