RE: Self-join

From: Fredrik Liden (flide..ranslate.com)
Date: Tue Jun 12 2007 - 16:33:44 EDT

  • Next message: Mike Kienenberger: "Re: Self-join"

    I like Vanilla Cayenne :-)
    Maybe I'll give it a try then.

    Thanks,
    Fredrik

    -----Original Message-----
    From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    Sent: Tuesday, June 12, 2007 2:14 PM
    To: use..ayenne.apache.org
    Subject: Re: Self-join

    Hmm... I know self-joins worked for me in the past with vanilla
    Cayenne. I haven't used such schemas in a while though. I guess I
    need to look closer at that bug report.

    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 <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 - 16:34:10 EDT