-
Bug
-
Resolution: Duplicate
-
Low
-
None
-
2.3
-
None
An error occurs when running the encoding test when using DB2.
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: LOWER;FUNCTION
at com.ibm.db2.jcc.b.id.e(id.java:1640)
at com.ibm.db2.jcc.b.id.a(id.java:1229)
at com.ibm.db2.jcc.c.fb.h(fb.java:149)
at com.ibm.db2.jcc.c.fb.a(fb.java:43)
at com.ibm.db2.jcc.c.s.a(s.java:30)
at com.ibm.db2.jcc.c.wb.g(wb.java:152)
at com.ibm.db2.jcc.b.id.n(id.java:1209)
at com.ibm.db2.jcc.b.id.a(id.java:1889)
at com.ibm.db2.jcc.b.id.a(id.java:517)
at com.ibm.db2.jcc.b.id.executeQuery(id.java:501)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
at com.atlassian.confluence.admin.actions.debug.EncodingTestAction.retrieveLowerDatabaseTestString(EncodingTestAction.java:117)
The IBM Documentation on the LOWER function says:
> The argument must be an expression whose value is a CHAR or VARCHAR data type.
Looks like DB2 doesn't support LOWER on a BLOB