[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7321) HQL: Combining a CROSS JOIN with a LEFT JOIN which requires a WITH clause triggers an exception.

[negora (JIRA)]

HQL: Combining a CROSS JOIN with a LEFT JOIN which requires a  WITH clause triggers an exception.
-------------------------------------------------------------------------------------------------

                 Key: HHH-7321
                 URL: https://hibernate.onjira.com/browse/HHH-7321
             Project: Hibernate ORM
          Issue Type: Bug
          Components: query-hql
    Affects Versions: 4.1.3, 4.1.0
         Environment: JDK 7.0 Update 4
JBoss AS 7.0.1 Final
            Reporter: negora


I'm trying to combine a CROSS JOIN with a LEFT JOIN. The last one requires a WITH clause that references one of tables used in the CROSS JOIN. For example, I want to list students, questions of an exam, and their answers to them. Some answers may not exist, thus I'm using a LEFT JOIN:

SELECT s.studentId, q.questionId, sa.answer
FROM Student s, Question q
LEFT JOIN s.studentAnswerList AS sa WITH sa.question.questionId = q.questionId

This causes an exception: javax.ejb.EJBException: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements .

The entities are really simple. These are their attributes:

- Student.studentId

- Question.questionId

- StudentAsnwer.studentAnswerId
- StudentAsnwer.studentId
- StudentAsnwer.questionId
- StudentAsnwer.answer

I've been suffering from the same problem in both 3.x and 4.x versions of Hibernate.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira