Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4245

Sorting a table containing a CLOB fails after upgrade to 10.5

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.5.1.1
    • 10.5.2.0, 10.6.1.0
    • Store
    • None
    • Blocker
    • Repro attached
    • Regression

    Description

      When sorting a table containing a CLOB column in a database that has been soft-upgraded from 10.4.2.0 to 10.5.1.1, the query fails with a NullPointerException.

      Reported on derby-user: http://mail-archives.apache.org/mod_mbox/db-derby-user/200905.mbox/%3ckk5ivy.tcwvy@email.bg%3e

      Attachments

        1. MixedVersionClob.java
          0.7 kB
          Knut Anders Hatlen
        2. derby-4245-0a-preview.diff
          4 kB
          Kristian Waagan
        3. derby-4245-1a-test.diff
          12 kB
          Kristian Waagan
        4. derby-4245-1b-test.diff
          11 kB
          Kristian Waagan
        5. derby-4245-2a-sqlclob_fix.diff
          3 kB
          Kristian Waagan
        6. derby-4245-3a-unread_bytes_fix.diff
          5 kB
          Kristian Waagan
        7. derby-4245-1c-test.diff
          11 kB
          Kristian Waagan
        8. derby-4245-4a-adjust_sort_buffer_test.diff
          2 kB
          Kristian Waagan

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4333 Exception in getMaxRows() after NullPointerException in SQLClob.readExternal() during query in table with CLOB column

          • Major - Major loss of function.
          • Closed

          Activity

            People

              kristwaa Kristian Waagan
              knutanders Knut Anders Hatlen
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: