[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4991) ManyToMany table not joined due to max_join_depth parameter, results to SQL exceptions

[Sergii Novotarskyi (JIRA)]

ManyToMany table not joined due to max_join_depth parameter, results to SQL exceptions
--------------------------------------------------------------------------------------

                 Key: HHH-4991
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4991
             Project: Hibernate Core
          Issue Type: Bug
          Components: query-criteria
    Affects Versions: 3.5.0-CR-2
         Environment: Hibernate 3.5.0-CR-2, MacOS X, MySQL 5.1
            Reporter: Sergii Novotarskyi
         Attachments: Example.zip

*max_join_depth* parameter prevents Hibernate from joining one end of ManyToMany relationship when using Criteria API, if the relationship is "far" enough from the root entity.

{quote}
            Criteria c = session.createCriteria(SubEntity.class)
            					.createAlias("entity", "e") // ManyToOne, inner join
            					.createAlias("e.entity", "ee") // ManyToOne, inner join
            					.createAlias("ee.sides", "s") // ManyToMany, inner join + left outer join
            					.setProjection(Projections.count("id"))
            					.add(Restrictions.ne("s.data", "abc"));
{quote}

When *max_join_depth* is set to *2* (default) the above example generates following SQL query

{quote}
    select count(this_.sub_id) as y0_ from SubEntity this_ 
    inner join SubMainEntity e1_ on this_.submain_id=e1_.submain_id 
    inner join MainEntity ee2_ on e1_.main_id=ee2_.main_id 
    inner join MainSide sides7_ on ee2_.main_id=sides7_.main_id 
    where s3_.data<>?
{quote}

The query, naturally, throws the "Unknown column 's3_.data' in 'where clause'" exception.

Expected query would be

{quote}
   select count(this_.sub_id) as y0_ from SubEntity this_ 
    inner join SubMainEntity e1_ on this_.submain_id=e1_.submain_id 
    inner join MainEntity ee2_ on e1_.main_id=ee2_.main_id 
    inner join MainSide sides7_ on ee2_.main_id=sides7_.main_id 
    left outer join SideEntity s3_ on sides7_.side_id=s3_.side_id 
    where s3_.data<>?
{quote}

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira