Confirmed it is a bug -
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-218
Will work on fixing it...
Andrus
On Oct 21, 2004, at 1:01 PM, Andrus Adamchik wrote:
> Derek,
>
> this might actually be a bug. Let me investigate this some more...
>
> Andrus
>
>> I have a Party superclass and Person/Organisation sub classes. I have
>> relationships set up at both levels. If I create a query based on
>> person
>> and prefetch a Person specific relationship, then I get two selects -
>> one for the person(s) and one for the relationship for those
>> person(s).
>> All is well :-)
>>
>> However, if I prefetch one of the Party relationships (regardless of
>> it
>> being a Party or Person based query), then I get more than two
>> selects -
>> one for the person(s), one for the relationship for those person(s),
>> and then one for each party related to a relationship (fetching the
>> "Party" object by its id). It looks like that if I use a party
>> relationship, then it executes a search for every distinct "toParty"
>> link pointing back from the relationship record(s) to party. Is this
>> is
>> a bug or a feature? I would rather not have to push all my
>> relationships
>> to the leaf classes if I can help it.
>>
>> Thanks
>>
>> Derek
This archive was generated by hypermail 2.0.0 : Thu Oct 21 2004 - 22:06:55 EDT