Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.2.8
-
Fix Version/s: 5.2.10
-
Component/s: hibernate-core
-
Labels:None
-
Environment:DB2 on z/OS, JDBC-Driver 4.19.66
-
Bug Testcase Reminder (view):
-
Suitable for new contributors:Yes, likely
-
Last commented by a user?:true
-
Pull Request:
Description
While using DB2390Dialect a call of the function getSelectClauseNullString in DB2Dialect returns "nullif(0,0)" in default case. The database returns the following error:
Error: DB2 SQL Error: SQLCODE=-170, SQLSTATE=42605, SQLERRMC=NULLIF, DRIVER=4.13.80
SQLState: 42605
ErrorCode: -170
The meaning of SQLCODE -170 is: THE NUMBER OF ARGUMENTS SPECIFIED FOR function-name IS INVALID
(0,0) isn't interpreted as two parameters.
The solution is to insert a trailing space after the comma. Inserting the space is syntactically correct in general. So this has no negativ impact on the other sqlTypes.
