You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2014/05/03 11:32:14 UTC

[jira] [Created] (CAY-1928) Second INNER join generated for OUTER flattended relationships in disjoint prefetches

Andrus Adamchik created CAY-1928:
------------------------------------

             Summary: Second INNER join generated for OUTER flattended relationships in disjoint prefetches
                 Key: CAY-1928
                 URL: https://issues.apache.org/jira/browse/CAY-1928
             Project: Cayenne
          Issue Type: Bug
    Affects Versions: 3.2M1, 3.1M3
            Reporter: Andrus Adamchik
            Assignee: Andrus Adamchik


In a situation when a query qualifier contains an outer join hint for a flattened relationship, Cayenne correctly generates a pair of OUTER joins in the root query SQL. However all disjoint prefetch queries are only using OUTER for the first join, and INNER for the second. This causes subtle issues, such as prefetch queries returning a trucated result (when a root object doesn't have anything on the target side of OUTER relationship).




--
This message was sent by Atlassian JIRA
(v6.2#6252)