[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2451) HQL: selecting subselects within subselects doesn't work

[Jay Merrifield (JIRA)]

HQL: selecting subselects within subselects doesn't work
--------------------------------------------------------

         Key: HHH-2451
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2451
     Project: Hibernate3
        Type: Bug

  Components: core, query-hql  
    Versions: 3.2.2    
    Reporter: Jay Merrifield


This is similar to the bug in HHH-2284. Instead this time I have the following HQL query: 

select eb from EarlyBird as eb, Topic as t  where eb.id = t.criteriaLinks_.documents_.id and t = ?

where Topic contains

<set access="field" name="criteriaLinks_" table="TopicCriteria" lazy="true" inverse="true">
      <key column="topicId" />
      <many-to-many column="criteriaLinkId" class="org.illumen.oasdpa.CriteriaLink" />
</set>

and CriteriaLink contains

<set access="field" name="documents_" table="CriteriaDocument" lazy="true" inverse="false">
      <key column="criteriaLinkId"/>
      <many-to-many column="documentId" class="org.illumen.document.Document"/>
</set>

This works under 3.0. But it's failing with the error: 

2007-02-26 17:27:02,775 DEBUG [DotNode] getDataType() : documents_ -> org.hibernate.type.IdentifierBagType(org.illumen.oasdpa.CriteriaLink.documents_)
 org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:555)
2007-02-26 17:27:02,775 ERROR [PARSER]  illegal syntax near collection: documents_
 org.hibernate.hql.ast.ErrorCounter.reportError(ErrorCounter.java:33)
2007-02-26 17:27:02,790 DEBUG [ErrorCounter]  illegal syntax near collection: documents_
 org.hibernate.hql.ast.ErrorCounter.reportError(ErrorCounter.java:28)
 illegal syntax near collection: documents_
	at org.hibernate.hql.ast.tree.DotNode.checkLhsIsNotCollection(DotNode.java:500)
	at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:205)
	at org.hibernate.hql.ast.tree.DotNode.resolveFirstChild(DotNode.java:143)
	at org.hibernate.hql.ast.HqlSqlWalker.lookupProperty(HqlSqlWalker.java:460)


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