cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Self-join
Date Wed, 27 Jun 2007 13:58:33 GMT
Or actually ... I take it back :-)

The underlying cause is still the inability to build correct joins  
when traversing a multi-step path qualifier, such as "parent.parent =  
null". This explains why Mike's patch made a difference.

Andrus


On Jun 27, 2007, at 4:50 PM, Andrus Adamchik wrote:

> Just to clarify, CAY-732 is a real bug, but it is not a bug with  
> relationships to same entity per se (those resolve just fine). This  
> is a bug specifically related to *prefetching* on such relationships.
>
> Andrus
>
>
> On Jun 12, 2007, at 10:33 PM, Mike Kienenberger wrote:
>
>> Not really sure as I don't use them, but at least one issue with
>> self-joins is solved if you use my outer join patch for 1.2.
>>
>> https://issues.apache.org/cayenne/browse/CAY-732
>>
>>
>>
>> On 6/12/07, Fredrik Liden <fliden@translate.com> wrote:
>>> What is the status of self joins in v. 1.2.3?
>>> From the 2 posts I find in the archive seems like some people are  
>>> using
>>> it.
>>> The documentation doesn't mention it.
>>> Just wondering if it's ok to use or if there are any limitations  
>>> that
>>> discourages it's use?
>>>
>>> I'm have a set of nodes. I'm guessing the source node will have
>>> Source_node_id NULL or 0. And then the target nodes will refer  
>>> back to
>>> the source nodes Node_id. Would it be worth using self joins here or
>>> should I just look up the target nodes based on the source nodes  
>>> using
>>> regular queries and not worry about the relations?
>>>
>>> NODE
>>>
>>> Node_id (pk)
>>> Text
>>> Source_node_id (fk)
>>>
>>> Thanks!
>>> Fredrik
>>>
>>
>
>


Mime
View raw message