[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1005) Criteria LEFT JOIN capability when adding Order to associations

Criteria LEFT JOIN capability when adding Order to associations --------------------------------------------------------------- Key: HHH-1005 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1005 Project: Hibernate3 Type: Patch

Components: query-criteria Versions: 3.1 rc3 Reporter: Leonardo Quijano Assignee: Steve Ebersole Fix For: 3.1.2 Attachments: CriteriaJoinTypes.patch As in: http://forum.hibernate.org/viewtopic.php?t=291&start=0&postdays=0... A way of specifying a join mode for Criteria queries would be great, such as in: criteria.createCriteria("association", JoinFragment.LEFT_OUTER_JOIN) or a similar syntax. I think this is important because is counterintuitive that order clauses add a filter to a Criteria. I know that by default a subCriteria will put an INNER_JOIN, but then again, if I have a QBE in a page with no filters, and click on a column to sort by that, I should get the same number of results as if I clicked another column, right? I would set a LEFT JOIN as default to avoid problems like that. Since that would break functionality, of course, then at least an overloaded version of createCriteria would be possible? Thanks.