Derby
  1. Derby
  2. DERBY-4245

Sorting a table containing a CLOB fails after upgrade to 10.5

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.5.2.0, 10.6.1.0
    • Component/s: Store
    • Labels:
      None
    • Urgency:
      Blocker
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      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

      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

          Activity

          Knut Anders Hatlen created issue -
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Attachment MixedVersionClob.java [ 12408910 ]
          Kristian Waagan made changes -
          Assignee Kristian Waagan [ kristwaa ]
          Kristian Waagan made changes -
          Attachment derby-4245-0a-preview.diff [ 12408935 ]
          Kristian Waagan made changes -
          Fix Version/s 10.5.1.2 [ 12313870 ]
          Kristian Waagan made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Kristian Waagan made changes -
          Attachment derby-4245-1a-test.diff [ 12410224 ]
          Kristian Waagan made changes -
          Derby Info [Regression] [Patch Available, Regression]
          Kristian Waagan made changes -
          Attachment derby-4245-1b-test.diff [ 12410320 ]
          Attachment derby-4245-2a-sqlclob_fix.diff [ 12410321 ]
          Kristian Waagan made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Derby Info [Regression, Patch Available] [Regression]
          Kristian Waagan made changes -
          Attachment derby-4245-3a-unread_bytes_fix.diff [ 12410674 ]
          Kristian Waagan made changes -
          Attachment derby-4245-1c-test.diff [ 12410763 ]
          Kristian Waagan made changes -
          Derby Info [Regression] [Patch Available, Regression]
          Dag H. Wanvik made changes -
          Bug behavior facts [Regression]
          Kristian Waagan made changes -
          Dag H. Wanvik made changes -
          Urgency Urgent
          Issue & fix info [Patch Available] [Patch Available, Repro attached]
          Kristian Waagan made changes -
          Issue & fix info [Repro attached, Patch Available] [Repro attached]
          Kathey Marsden made changes -
          Urgency Urgent Blocker
          Kristian Waagan made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Fix Version/s 10.5.2.0 [ 12314116 ]
          Fix Version/s 10.5.1.2 [ 12313870 ]
          Kristian Waagan made changes -
          Link This issue is duplicated by DERBY-4333 [ DERBY-4333 ]
          Kristian Waagan made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12464250 ] Default workflow, editable Closed status [ 12799507 ]

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development