[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-6063) The fix for HHH-5126 breaks array constructor in PostgreSQL

The fix for HHH-5126 breaks array constructor in PostgreSQL ----------------------------------------------------------- Key: HHH-6063 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6063 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.1, 3.6.2, 4.0.0.Alpha1 Environment: PostgreSQL, any version Reporter: Jon Vincent Assignee: Gail Badner Fix For: 4.0.0.next The fix for HHH-5126 supports this JPA2-compliant IN query: {{{ SELECT * FROM my_table WHERE id IN :collection }}} Before HHH-5126 was fixed, Hibernate required the developer to surround collection-valued parameters with parentheses: {{{ SELECT * FROM my_table WHERE id IN (:collection) }}} The implemented fix was simply to output parentheses in the generated SQL. Unfortunately, this breaks _other_ uses of collection-values parameters, such as for arrays in PostgreSQL: {{{ CREATE TABLE my_table (some_array INTEGER[]); INSERT INTO my_table (some_array) VALUES (ARRAY[:collection]); }}} Is there a way to turn off the fix for HHH-5126? For us, at least, the old code was more flexible and allowed access to important database features.