7:50 a.m.
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Patch
Components: EntityManager
Environment: PostgreSQL 8.2.3 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
--
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
4:44 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling commented on EJB-403:
--------------------------------------------
Is it ok to commit this patch? Is the "alias" in the update statement part of
the test?
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Patch
Components: EntityManager
Environment: PostgreSQL 8.2.3 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
--
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
8:36 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Emmanuel Bernard commented on EJB-403:
--------------------------------------
The patch is not solving the root problem.
identification variables in update statements are legal as per the JPA spec.
The proper fix is to generate a SQL that "removes" the identification variable
for PostgreSQL (probably triggered by a Dialect flag).
Let's open a Hibernate Core JIRA for it and see what Steve has to say.
In the mean time, let's treat that as a limitation of PostgreSQL and a known failing
test.
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Patch
Components: EntityManager
Environment: PostgreSQL 8.2.3 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
--
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
6:59 a.m.
New subject: [Hibernate-JIRA] Updated: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling updated EJB-403:
---------------------------------------
Assignee: Emmanuel Bernard (was: Juraci Paixao Krohling)
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager (was: PostgreSQL
8.2.3 and Entity Manager )
Description:
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
was:
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
Issue Type: Bug (was: Patch)
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Emmanuel Bernard
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
5:09 p.m.
New subject: [Hibernate-JIRA] Commented: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Gail Badner commented on EJB-403:
---------------------------------
The following works for Sybase ASE 15:
update item set descr = 'Logitech Mouse' from item i where i.name =
'Mouse'
Syntax for Sybase update command is at:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter....
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Emmanuel Bernard
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
3:29 p.m.
New subject: [Hibernate-JIRA] Commented: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Steve Ebersole commented on EJB-403:
------------------------------------
Emmanuel, where do you see in the spec that *native sql* queries have to support aliases
(identification variables) in UPDATE/DELETE queries? I see that for EJBQL queries, but
could not for native-sql queries....
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Emmanuel Bernard
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
3:54 p.m.
New subject: [Hibernate-JIRA] Commented: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Steve Ebersole commented on EJB-403:
------------------------------------
The spec, afaict, never discusses the syntax of update/delete native-sql queries. 3.6.6
discusses native-sql queries, but never explicitly update/delete variety. And
furthermore, that section specifically states -> "Native SQL queries are not
expected to be portable across databases."
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Emmanuel Bernard
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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:10 a.m.
New subject: [Hibernate-JIRA] Updated: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Emmanuel Bernard updated EJB-403:
---------------------------------
Fix Version/s: 3.5
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Emmanuel Bernard
Fix For: 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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:10 a.m.
New subject: [Hibernate-JIRA] Commented: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Emmanuel Bernard commented on EJB-403:
--------------------------------------
I think I read too fast and I thought it was a JPA-QL query. The patch can be assigned
then.
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Emmanuel Bernard
Fix For: 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
4:15 a.m.
New subject: [Hibernate-JIRA] Assigned: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling reassigned EJB-403:
------------------------------------------
Assignee: Juraci Paixao Krohling (was: Emmanuel Bernard)
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Fix For: 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
8:41 a.m.
New subject: [Hibernate-JIRA] Resolved: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling resolved EJB-403.
----------------------------------------
Resolution: Fixed
Fixed for trunk (revision 16380), v3_3_2_GA_CP (16379) and v3_4_0_GA_CP (16378)
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Fix For: 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
6:42 a.m.
New subject: [Hibernate-JIRA] Reopened: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling reopened EJB-403:
----------------------------------------
Also affects Branch_3_2.
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Fix For: 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
6:44 a.m.
New subject: [Hibernate-JIRA] Updated: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling updated EJB-403:
---------------------------------------
Fix Version/s: 3.4.1
3.3.3
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Fix For: 3.3.3, 3.4.1, 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
6:52 a.m.
New subject: [Hibernate-JIRA] Resolved: (EJB-403) QueryTest - Native Query for Update using alias causes failure
[
http://opensource.atlassian.com/projects/hibernate/browse/EJB-403?page=co...
]
Juraci Paixao Krohling resolved EJB-403.
----------------------------------------
Resolution: Fixed
Fixed for Branch_3_2 in revision 16489.
QueryTest - Native Query for Update using alias causes failure
--------------------------------------------------------------
Key: EJB-403
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-403
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Environment: PostgreSQL 8.2.3/Sybase ASE 15 and Entity Manager
Reporter: Juraci Paixao Krohling
Assignee: Juraci Paixao Krohling
Fix For: 3.3.3, 3.4.1, 3.5
Attachments: QueryTest.diff
Even though it says in documentation that it supports table aliases in "update"
clauses[1], the below test fails when using it. Removing the table alias is enough to make
it successful.
org.hibernate.ejb.test.QueryTest#testUpdateQuery
[1] http://www.postgresql.org/docs/8.2/interactive/sql-update.html
It also affects Sybase.
--
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
5546
days inactive
5699
days old
hibernate-issues@lists.jboss.org
13 comments
4 participants
participants (4)
-
Emmanuel Bernard (JIRA) -
Gail Badner (JIRA)
-
Juraci Paixao Krohling (JIRA)
-
Steve Ebersole (JIRA)