cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-1928) Second INNER join generated for OUTER flattended relationships in disjoint prefetches
Date Sat, 03 May 2014 09:32:14 GMT
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)

Mime
View raw message