[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Steve Ebersole updated HHH-3538: -------------------------------- Assignee: Steve Ebersole Description: The underlying cause is an invalid assumption made in JoinWalker that every association found in its association member list is to be fetched (added to the select fragment). was: The JoinWalker creates for all given associations a select fragment. An associations should have a flag, if it is necessary to be included on the select fragment. If you need an association only for a specific where fragment why should it be fetched? Affects Version/s: 3.2.6 Fix Version/s: 3.4 3.3.x 3.2.x Summary: Criteria.createAlias/Criteria.createCriteria forces join fetching of association (was: Unnecessary complete select fragment for all associations) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Gérald Quintana updated HHH-3538: --------------------------------- Attachment: hhh-3538b.zip Upload fixed test case (previous test case didn't work). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Steve Ebersole updated HHH-3538: -------------------------------- Fix Version/s: (was: 3.3.2) 3.3.x -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Shawn Clowater commented on HHH-3538: ------------------------------------- This also occurs where using the createAlias methods. It will also throw off any paging you're doing, i.e. since the joined tables are being fetched upfront if you have any sort of max results set on the criteria you're going to end up with a reduced number of what you're actually looking for. Work around is to use explicit subqueries instead of inner joins. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Shawn Clowater commented on HHH-3538: ------------------------------------- I don't know what I was smoking with my previous comment. Even w/o the explicit fetching it can throw off your paging. I think I was trying to reduce the amount of data coming back from a query one day and had noticed that I was getting a bunch of dupes in my results prior to getting to the distinct result transformer and a bad synapse fired in my brain. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Gail Badner updated HHH-3538: ----------------------------- Assignee: Gail Badner (was: Steve Ebersole) Affects Version/s: 3.5.1 Fix Version/s: 3.6 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Gail Badner updated HHH-3538: ----------------------------- Fix Version/s: (was: 3.5.4) 3.5.x -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Steve Ebersole updated HHH-3538: -------------------------------- Fix Version/s: (was: 3.6.0.Beta1) 3.6.x -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Steve Ebersole updated HHH-3538: -------------------------------- Fix Version/s: (was: 3.6.0) 3.6.1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Gérald Quintana updated HHH-3538: --------------------------------- Attachment: hhh-3538-3.6.1.zip Retested with Hibernate Core 3.6.1, problem still here -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Steve Ebersole updated HHH-3538: -------------------------------- Fix Version/s: (was: 3.6.next) 3.6.3 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Steve Ebersole closed HHH-3538. ------------------------------- Resolution: Duplicate Fix Version/s: (was: 3.6.4) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3538?page=c... ] Gail Badner reopened HHH-3538: ------------------------------ Reopening because HHH-2049 specifically dealt with collection associations. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira