[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2664) full join not working

[Alexandre Oliveira (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29737 ] 

Alexandre Oliveira commented on HHH-2664:
-----------------------------------------

In JoinProcessor class, in the toHibernateJoinType method, the case clause that should handle the full join is missing:
			case FULL:
				return JoinFragment.FULL_JOIN;	

After I add this, it seems to work (didn't work for me because I'm using hsqldb, that doesn't support full outer joins).

> full join not working
> ---------------------
>
>                 Key: HHH-2664
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2664
>             Project: Hibernate3
>          Issue Type: Bug
>    Affects Versions: 3.1.2, 3.2.4
>         Environment: Any DB, tested on Windows
>            Reporter: Fabio Tudone
>         Attachments: test.jar
>
>
> I get this error when trying to full join:
> - an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
> org.hibernate.AssertionFailure: undefined join type 23
> 	at org.hibernate.hql.ast.util.JoinProcessor.toHibernateJoinType(JoinProcessor.java:68)
> 	at org.hibernate.hql.ast.HqlSqlWalker.setImpliedJoinType(HqlSqlWalker.java:433)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3157)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3067)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
> 	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
> 	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
> 	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
> 	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
> 	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
> 	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
> 	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
> 	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
> 	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
> 	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
> 	at com.finantix.test.Main.main(Main.java:63)

-- 
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