Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1928

Second INNER join generated for OUTER flattended relationships in disjoint prefetches

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.1M3, 3.2.M1
    • 4.0.M2, 3.1
    • None
    • None

    Description

      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).

      Attachments

        Activity

          People

            andrus Andrus Adamchik
            andrus Andrus Adamchik
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: