Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1365

DISTINCT keyword has no effect with JOIN FETCH queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.0.4, 1.2.2, 1.3.0, 2.0.0-beta
    • None
    • jpa, query
    • None

    Description

      This issue occurs if the proposed fix for OPENJPA-894 is in place. Without that fix there results of a JOIN FETCH are always distinct when obtained from the database or non-distinct when returned from the persistence context's L1 cache.

      I started a discussion on this topic on the dev mailing list. The entire thread can be seen on Nabble here : http://n2.nabble.com/How-should-we-handle-the-JPQL-DISTINCT-keyword-td3908400.html#a3908400

      Attachments

        1. OPENJPA-1365-1.0.x-patch.txt
          73 kB
          Michael Dick

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. OPENJPA-894 LEFT JOIN FETCH queries with fresh fetches from the db do not follow JPA Spec 4.4.5.3

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              mikedd Michael Dick
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: