From 9c731b2ebf4909d319bf7ce44c4c5e895723afa6 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 28 Mar 2014 16:41:08 -0400 Subject: - add further coverage for join_condition to make sure we get this case where there are multiple, equivalent foreign keys --- test/sql/test_selectable.py | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'test/sql') 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() -- cgit v1.2.1