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

[Etienne B. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_22240 ] 

Etienne Bernard commented on HHH-333:
-------------------------------------

err shame on me...

I just noticed that I had hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory in my hibernate.properties so the bug is not fixed at all...

> QuerySyntaxError when using JOIN index(...) in HQL query
> --------------------------------------------------------
>
>          Key: HHH-333
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333
>      Project: Hibernate3
>         Type: Bug

>   Components: query-hql
>     Versions: 3.0 final
>     Reporter: Etienne Bernard
>     Priority: Minor

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

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