7:02 a.m.
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:30 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Tom Ross updated HHH-5992:
--------------------------
Attachment: TestCaseBug-HHH-5992.zip
This is the test case for the bug.
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:32 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:32 a.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Strong Liu reassigned HHH-5992:
-------------------------------
Assignee: Strong Liu
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
Assignee: Strong Liu
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:19 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Strong Liu commented on HHH-5992:
---------------------------------
https://issues.jboss.org/browse/JBPAPP-6759
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
Assignee: Strong Liu
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:45 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Strong Liu updated HHH-5992:
----------------------------
Priority: Critical (was: Major)
Affects Version/s: 4.0.0.CR6
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, 4.0.0.CR6
Environment: JBoss EAP 5.1
Reporter: Tom Ross
Assignee: Strong Liu
Priority: Critical
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:40 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Steve Ebersole updated HHH-5992:
--------------------------------
Assignee: Steve Ebersole (was: Strong Liu)
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, 4.0.0.CR6
Environment: JBoss EAP 5.1
Reporter: Tom Ross
Assignee: Steve Ebersole
Priority: Critical
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:25 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Steve Ebersole updated HHH-5992:
--------------------------------
Priority: Major (was: Critical)
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, 4.0.0.CR6
Environment: JBoss EAP 5.1
Reporter: Tom Ross
Assignee: Steve Ebersole
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:32 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Steve Ebersole commented on HHH-5992:
-------------------------------------
I have identified this condition. This is something Hibernate cannot support. The
problem is that through the JDBC {{ResultSetMetaData}} contract these 2 columns look like
the same; JDBC does not provide access to enough contextual information here.
I will make the change to throw an exception when this condition is encountered.
The workaround/solution is simple, apply an alias to the column(s) in the sql query:
{{code}}
select v1.username as v1_username, v2.username as v2_username ...
{{code}}
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, 4.0.0.CR6
Environment: JBoss EAP 5.1
Reporter: Tom Ross
Assignee: Steve Ebersole
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:52 a.m.
New subject: [Hibernate-JIRA] Closed: (HHH-5992) A query fails to return correct results silently
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5992?page=c...
]
Steve Ebersole closed HHH-5992.
-------------------------------
Resolution: Fixed
Fix Version/s: 4.0.0.next
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, 4.0.0.CR6
Environment: JBoss EAP 5.1
Reporter: Tom Ross
Assignee: Steve Ebersole
Fix For: 4.0.0.next
Attachments: TestCaseBug-HHH-5992.zip
Time Spent: 1h 10m
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4773
days inactive
5040
days old
hibernate-issues@lists.jboss.org
9 comments
3 participants
participants (3)
-
Steve Ebersole (JIRA) -
Strong Liu (JIRA)
-
Tom Ross (JIRA)