summaryrefslogtreecommitdiff
path: root/test/sql/test_selectable.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_selectable.py')
-rw-r--r--test/sql/test_selectable.py10
1 files changed, 10 insertions, 0 deletions
diff --git a/test/sql/test_selectable.py b/test/sql/test_selectable.py
index 5d3d53b88..a5693acd3 100644
--- a/test/sql/test_selectable.py
+++ b/test/sql/test_selectable.py
@@ -1062,6 +1062,16 @@ class JoinConditionTest(fixtures.TestBase, AssertsCompiledSQL):
"FROM t2 JOIN t3 ON t2.id = t3.t2id) ON t2.id = t3_t2id")
+ def test_join_multiple_equiv_fks(self):
+ m = MetaData()
+ t1 = Table('t1', m,
+ Column('id', Integer, primary_key=True)
+ )
+ t2 = Table('t2', m,
+ Column('t1id', Integer, ForeignKey('t1.id'), ForeignKey('t1.id'))
+ )
+
+ assert sql_util.join_condition(t1, t2).compare(t1.c.id == t2.c.t1id)
def test_join_cond_no_such_unrelated_table(self):
m = MetaData()