Uploaded image for project: 'Hibernate ORM'
  1. Hibernate ORM
  2. HHH-2049

LEFT OUTER JOIN subcriteria filters children (Mattias Jiderhamn)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.3, 3.2.0.cr4, 3.5.0.Beta-1, 3.5.2, 3.6.3
    • Fix Version/s: 3.6.4, 4.0.0.Alpha3
    • Component/s: query-criteria
    • Labels:
      None
    • Environment:
      Hibernate 3.1.3/3.2.0rc4, hsqldb 1.8
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      When using the Criteria API with LEFT OUTER JOIN to add criterias to the children, i.e.
      criteria.createCriteria("children", JoinFragment.LEFT_OUTER_JOIN)
      the child collections will only contain those children matching the criteria. (Even when not using any Filters).

      The attached testcase (also found here: http://forum.hibernate.org/viewtopic.php?p=2320786) will explain it in more detail.

        Attachments

          Issue links

          causes

          Bug - A problem which impairs or prevents the functions of the product. HHH-9597 Criteria creates invalid Column aliases.

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. HHH-3807 Adding a restriction to a many-to-one entity in Criteria query causes Join fetching

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HHH-10081 Use of subcriterias produce inconsistent results

          • Major - Major loss of function.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. HHH-2931 Criteria.setMaxResults() filters children with fetch="join"

          • Major - Major loss of function.
          • Open

            Activity

              People

              • Votes:
                13 Vote for this issue
                Watchers:
                23 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: