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 <flide..ranslate.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
>
This archive was generated by hypermail 2.0.0 : Tue Jun 12 2007 - 15:33:41 EDT