[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[Martin Kouba (JIRA)]

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

Martin Kouba commented on HHH-2667:
-----------------------------------

Would you kindly not close an issue related to a bug and could you kindly reopen this issue.

This is not a misuse or something. I guess I have described the situation clear enough in my original statement. Also according to the current manual at

14.17. Components
eg. "select p.name from from Person p"
eg. "from Person p order by p.name.first"
(I don't know why the manual says from from but this is a different story)

you can find examples that will not work without fixing this bug.

So if you plan to remove this feature and make it necessary to work aroung such cases using native SQL than please state that in the manual that this is no longer supported.

> 'illegal attempt to dereference collection' when using auto-join
> ----------------------------------------------------------------
>
>                 Key: HHH-2667
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667
>             Project: Hibernate3
>          Issue Type: Bug
>    Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1
>         Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1)
> Database: ORACLE 10g
>            Reporter: Martin Kouba
>
> After upgrading to the latest Hibernate version I got this error.
> I try to use a statement like this
> from cat c where c.mate.id = 13
> the expected resulting SQL should be something like
> SELECT * FROM CAT C WHERE C.MATE_ID = 13
> which is much more performant than making a join
> from cat c join c.mate m where m.id = 13
> which would result in something like that
> SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13
> This works as expected in 3.1.3, 3.2.0 and 3.2.2
> It doesn't work with version 3.2.3 and with 3.2.4.sp1.

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