unexpected AST node on HQL UPDATE with composite ID
---------------------------------------------------
Key: HHH-5936
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5936
Project: Hibernate Core
Issue Type: Bug
Components: core
Reporter: Kevin Ferrare
I am trying to execute the following simple HQL update :
UPDATE ProductStorage SET id=:newId WHERE id=:oldId
id is a composite id (composed of "code" and "saleOfficeId")
I get the following exception :
unexpected AST node: AND
I think the cause is that when hibernate tries to split the id in the SET clause, it uses
an "AND" instead of a comma
Here is the generated tree that fails (trace log) :
\-[UPDATE] UpdateStatement: 'UPDATE' querySpaces ("product_3f")
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1,
fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[productsto0_],
fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: '"product_3f"'
FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy
properties,classAlias=null,role=null,tableName="product_3f",tableAlias=productsto0_,origin=null,columns={,className=dto.ProductStorage}}
+-[SET] SqlNode: 'SET'
| \-[AND] BinaryLogicOperatorNode: 'AND'
| +-[EQ] BinaryLogicOperatorNode: '='
| | +-[SQL_TOKEN] SqlFragment: '"code"'
| | \-[SQL_TOKEN] SqlFragment: '?'
| \-[EQ] BinaryLogicOperatorNode: '='
| +-[SQL_TOKEN] SqlFragment: '"saleOfficeId"'
| \-[SQL_TOKEN] SqlFragment: '?'
\-[WHERE] SqlNode: 'WHERE'
\-[AND] BinaryLogicOperatorNode: 'AND'
+-[EQ] BinaryLogicOperatorNode: '='
| +-[SQL_TOKEN] SqlFragment: '"code"'
| \-[SQL_TOKEN] SqlFragment: '?'
\-[EQ] BinaryLogicOperatorNode: '='
+-[SQL_TOKEN] SqlFragment: '"saleOfficeId"'
\-[SQL_TOKEN] SqlFragment: '?'
--
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