[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-333) QuerySyntaxError when using JOIN index(...) in HQL query

[<no...@at...>]

The following comment has been added to this issue:

     Author: Etienne Bernard
    Created: Tue, 12 Apr 2005 4:29 AM
       Body:
Oops, forgot to add : run "ant testh2" for hibernate 2.1 test, "ant testh3" for hibernate 3.
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_17092

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-333

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-333
    Summary: QuerySyntaxError when using JOIN index(...) in HQL query
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
   Versions:
             3.0 final

   Assignee: 
   Reporter: Etienne Bernard

    Created: Tue, 12 Apr 2005 4:25 AM
    Updated: Tue, 12 Apr 2005 4:29 AM

Description:
I've been using this syntax since hibernate 2.0 :

FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1

with the following mapping :

[...]
    <class name="test.A" table="a">
[...]
        <map name="abs" table="ab" lazy="true">
              <key column="a"></key>
              <index-many-to-many class="test.B" column="b"/>
              <composite-element class="test.AB">
                  <property name="status" type="int"/>
              </composite-element>
        </map>
[...]
    </class>
[...]

It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final.

See the attached example for a complete test case.

Thanks.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira