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

Incorrect reading of nullable Blob/Clob columns during soft upgrade with client/server

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.3.1.4, 10.4.1.3
    • Component/s: Network Server
    • Labels:
      None
    • Environment:
      Client/server soft upgrade
    • Bug behavior facts:
      Regression

      Description

      Select operations with client/server and soft upgrade mode will not see first byte of the Blob/Clob if the LOB column is nullable.

      The reason seems to be that during soft upgrade, the network server does not prepend the LOB data with the byte indicating whether the column is null or not. Hence, the first data byte will be interpreted by the client as the null byte, and the reading of the LOB will start at the second byte.

        Attachments

        1. softupgradefix.diff
          0.7 kB
          Oystein Grovlen
        2. SimpleBlobTest.java
          5 kB
          Oystein Grovlen

          Activity

            People

            • Assignee:
              oysteing Oystein Grovlen
              Reporter:
              oysteing Oystein Grovlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: