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

[Shawn Clowater (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36112#action_36112 ] 

Shawn Clowater commented on HHH-4991:
-------------------------------------

Blah, this is an absolute show stopper for us.  I can't even turn on the max_fetch_depth as a workaround due to invalid sql getting generated due to some of our filters (i think).  

Does anyone know what change might be causing this issue or how widespread it might actually be? i.e. does it only affect criteria api?

> 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