[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-3519) account for parameters in select clause of INSERT-SELECT for DB2

account for parameters in select clause of INSERT-SELECT for DB2 ---------------------------------------------------------------- Key: HHH-3519 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3519 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.6, 3.3.1 Environment: DB2 Reporter: Gail Badner Assignee: Steve Ebersole Fix For: 3.2.x, 3.3.x, 3.4 DB2 is somewhat restrictive in terms of where/how parameters can occur. One such restriction is that parameters in a select clause must be wrapped by a call to the CAST() function so that the DB2 parser can determine the datatype to expect. In the case of an HQL INSERT statement with a versioned entity where the version is VM-based, Hibernate generates an INSERT-SELECT statement in which it attempts to set the inserted row's version using a parameter. For that usage, at minimum we need to account for this CAST() wrapping.