Uploaded image for project: 'z - Hibernate 2'
  1. HB-1441

Ability to specify additional conditions in ON clause when doing LEFT JOIN queries.

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects versions: None
    • Fix versions: None
    • Components: None
    • Labels:
      None
    • Last commented by a user?:
      true
    • Sprint:

      Description

      I think it would be good if Hibernate could generate queries with on clause having more than just comparing ids of rows it is joining.

      Let's imagine we have a filtered collection mapped in a class. When we are left joining this collection we could expect that filter conditions will appear in ON clause of the join rather than in the WHERE clause (as putting them in the where clause somehow is against the semantics of the left join which allows to get result even if no matching rows were joined).

      Hibernate query language would be much more powerful with this.

        Attachments

          Issue links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: