[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5992) A query fails to return correct results silently

[Tom Ross (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40128#action_40128 ] 

Tom Ross commented on HHH-5992:
-------------------------------

To use the test case unzip it to a directory.
Then cd TestCase-hsql and update the build.properties file to update the value of as.home that points to  JBoss EAP home directory. Then run ant to build the test case and ant test to run the junit test. The test will fail.
 

> A query fails to return correct results silently
> ------------------------------------------------
>
>                 Key: HHH-5992
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.3.2
>         Environment: JBoss EAP 5.1
>            Reporter: Tom Ross
>         Attachments: TestCaseBug-HHH-5992.zip
>
>
> The following query fails silently to return a correct result select v1.username, v2.username from user_ety v1, user_ety v2 where v1.username = '1' and v2.username = '2'. It returns one row with "1,1" instead of one row with "1,2".
> The query works with pre JPA CMP EJBs (ver 2.1) but fails when moved to JPA based persistence.
> This failure is very dangerous since it is silent and without manually checking data it is impossible to determine if a correct set is returned.
> The workaround is to use aliases and modify the query so it looks like that:
> select v1.username as username1, v2.username as username2 from user_ety v1, user_ety v2 where v1.username = '1' and v2.username = '2'.

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