XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Low
    • Resolution: Duplicate
    • 2.3
    • None
    • None

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            mjensen m@
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: