[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4266) Unit tests fail because Insert into ... values(upper(?)) fails on DB2

[Emmanuel Bernard (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35985#action_35985 ] 

Emmanuel Bernard commented on HHH-4266:
---------------------------------------

https://jira.jboss.org/jira/browse/JBPAPP-948 is a different problem: it is about HQL queries failing on DB2.
In our case, we are talking about SQL queries failing on DB2. We unfortunately cannot use different SQL queries depending on the underlying database. That would be an interesting feature to have by the way.

> Unit tests fail because Insert into ... values(upper(?)) fails on DB2
> ---------------------------------------------------------------------
>
>                 Key: HHH-4266
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4266
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: annotations
>            Reporter: Gail Badner
>            Assignee: Emmanuel Bernard
>
> The following tests fail with DB2Dialect:
>    org.hibernate.test.annotations.join.JoinTest.testFetchModeOnSecondaryTable()
>    org.hibernate.test.annotations.join.JoinTest.testCustomSQL()
> due to failure on:
>     insert into Cat2 (storyPart2, id) values (upper(?), ?)
> The following tests fail:
>   org.hibernate.test.annotations.query.QueryAndSQLTest.testEntitySQLOverriding()
>   org.hibernate.test.annotations.query.QueryAndSQLTest.testCollectionSQLOverriding()
> due to failure on:
>   INSERT INTO CHAOS(name, nick_name, chaos_size, id) VALUES(upper(?),?,?,?)
> The tests pass if upper(?) is changed to upper(? || ''), but this may not work on all dialects.

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira