better support for indistinct eager-loaded objects
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.
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.
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.