[Sqlalchemy-tickets] [sqlalchemy] #2738: SQLAlchemy should throw an exception if there are multiple foreign keys to relate

[sqlalchemy <mi...@zz...>]

#2738: SQLAlchemy should throw an exception if there are multiple foreign keys to
relate
-------------------------+-----------------------------------------
 Reporter:  Svenstaro    |           Owner:  zzzeek
     Type:  defect       |          Status:  new
 Priority:  medium       |       Milestone:
Component:  cextensions  |        Severity:  no triage selected yet
 Keywords:               |  Progress State:  awaiting triage
-------------------------+-----------------------------------------
 The attached code generates something like this:

 SELECT "group".id AS group_id
 FROM "group" JOIN (SELECT "user".type AS type, deriveduser.id AS id,
 "user".id AS id, deriveduser.preference1_id AS preference1_id,
 deriveduser.preference2_id AS preference2_id, deriveduser.preference3_id
 AS preference3_id, deriveduser.group_id AS group_id, count(:param_1) AS
 deriveduser_count
 FROM "user" JOIN deriveduser ON "user".id = deriveduser.id GROUP BY
 deriveduser.group_id) AS anon_1 ON "group".id = anon_1.preference1_id AND
 "group".id = anon_1.preference2_id AND "group".id = anon_1.preference3_id
 AND "group".id = anon_1.group_id

 Isn't this actually ill behavior that should throw an exception if the
 join is ambiguous as it is in this case?

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2738>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python