Re: Self-join

From: Mike Kienenberger (mkienen..mail.com)
Date: Tue Jun 12 2007 - 16:37:18 EDT

  • Next message: Fredrik Liden: "Unit testing web apps"

    Andrus,

    There's a simple test case attached for that issue which I used to
    verify the broken behavior beforehand and the correct behavior
    afterwards.

    From the problem description given, it only affected self-joins and prefetching.

    On 6/12/07, Andrus Adamchik <andru..bjectstyle.org> wrote:
    > 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:37:42 EDT