composite-id master-detail doesn't bound correctly variables ------------------------------------------------------------ Key: HHH-2121 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2121 Project: Hibernate3 Type: Bug Components: query-hql Versions: 3.2.0.cr4 Environment: hibernate-3.2.CR4, oracle 9i Reporter: German de la Cruz Priority: Blocker Attachments: CompositeIdTest.java After issue HHH-2120, we decided to migrate from Hibernate 3.0.5 to 3.2.CR4. But, after have made the migration, we receive another error related to the variables bound. When I run the attached code (You can see it is the same class in tests in distribution file, but with a new method called testQuery2 that can reproduce the bug) Hibernate generate the following query. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 16:18:19,492 DEBUG AST:266 - --- HQL AST --- \-[QUERY] 'query' +-[SELECT_FROM] 'SELECT_FROM' | \-[FROM] 'from' | \-[RANGE] 'RANGE' | +-[DOT] '.' | | +-[DOT] '.' | | | +-[DOT] '.' | | | | +-[DOT] '.' | | | | | +-[IDENT] 'org' | | | | | \-[IDENT] 'hibernate' | | | | \-[IDENT] 'test' | | | \-[IDENT] 'cid' | | \-[IDENT] 'LineItem' | \-[ALIAS] 'ol' \-[WHERE] 'where' \-[AND] 'and' +-[EQ] '=' | +-[DOT] '.' | | +-[IDENT] 'ol' | | \-[IDENT] 'order' | \-[COLON] ':' | \-[WEIRD_IDENT] 'order' \-[EQ] '=' +-[IDENT] 'quantity' \-[COLON] ':' \-[IDENT] 'quantity' 16:18:19,532 DEBUG AST:232 - --- SQL AST --- \-[SELECT] QueryNode: 'SELECT' querySpaces (LineItem) +-[SELECT_CLAUSE] SelectClause: '{derived select clause}' | +-[SELECT_EXPR] SelectExpressionImpl: 'lineitem0_.customerId as customerId2_, lineitem0_.orderNumber as orderNum2_2_, lineitem0_.productId as productId2_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ol,role=null,tableName=LineItem,tableAlias=lineitem0_,origin=null,colums={,className=org.hibernate.test.cid.LineItem}}} | \-[SQL_TOKEN] SqlFragment: 'lineitem0_.quantity as quantity2_' +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[ol], fromElementByTableAlias=[lineitem0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} | \-[FROM_FRAGMENT] FromElement: 'LineItem lineitem0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ol,role=null,tableName=LineItem,tableAlias=lineitem0_,origin=null,colums={,className=org.hibernate.test.cid.LineItem}} \-[WHERE] SqlNode: 'where' \-[AND] SqlNode: 'and' +-[AND] BinaryLogicOperatorNode: 'AND' | +-[EQ] BinaryLogicOperatorNode: '=' | | +-[SQL_TOKEN] SqlFragment: 'lineitem0_.customerId' | | \-[SQL_TOKEN] SqlFragment: '?' | \-[EQ] BinaryLogicOperatorNode: '=' | +-[SQL_TOKEN] SqlFragment: 'lineitem0_.orderNumber' | \-[SQL_TOKEN] SqlFragment: '?' \-[EQ] BinaryLogicOperatorNode: '=' +-[DOT] DotNode: 'lineitem0_.quantity' {propertyName=quantity,dereferenceType=4,propertyPath=quantity,path={synthetic-alias}.quantity,tableAlias=lineitem0_,className=org.hibernate.test.cid.LineItem,classAlias=ol} | +-[IDENT] IdentNode: '{synthetic-alias}' {originalText={synthetic-alias}} | \-[IDENT] IdentNode: 'quantity' {originalText=quantity} \-[NAMED_PARAM] ParameterNode: '?' {name=quantity, expectedType=org.hibernate.type.IntegerType@d81b4} 16:18:21,968 DEBUG SQL:393 - select lineitem0_.customerId as customerId2_, lineitem0_.orderNumber as orderNum2_2_, lineitem0_.productId as productId2_, lineitem0_.quantity as quantity2_ from LineItem lineitem0_ where lineitem0_.customerId=? and lineitem0_.orderNumber=? and lineitem0_.quantity=? 16:18:21,988 DEBUG StringType:80 - binding 'C111' to parameter: 1 16:18:21,993 DEBUG IntegerType:80 - binding '0' to parameter: 2 16:18:21,997 DEBUG IntegerType:80 - binding '2' to parameter: 2 16:18:22,019 WARN JDBCExceptionReporter:71 - SQL Error: 1008, SQLState: 72000 16:18:22,024 ERROR JDBCExceptionReporter:72 - ORA-01008: not all variables bound -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= As you can see, two variables are binded to parameter 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