better support for indistinct eager-loaded objects

Bug #627221 reported by Robert Collins
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Storm
New
Undecided
Unassigned

Bug Description

I look forward to the better eager loading support that is in development.

This is essentially a note that one particular situation is a bit tricky.

Consider:
select * from Specification left outer join person on person.id in (specification.assignee, specification.drafter, specification.approver) ...

This will return 0-3 rows for every specification. This particular query can be rewritten using 3 alias tables, but that makes it very hard when you then add in :
left outer join account on person.account=account.id

because if table aliases are used, you need three separate joins to account, and the query and result set all get harder to read. It may well also become pathological in terms of fooling query planners.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.