[DERBY-2923] Incorrect reading of nullable Blob/Clob columns during soft upgrade with client/server

• 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
• Environment: Client/server soft upgrade
• Bug behavior facts: Regression
• Assignee: Oystein Grovlen
• Reporter: Oystein Grovlen
• Created: 11/Jul/07 12:52
• Updated: 30/Jun/09 15:55
• Resolved: 13/Jul/07 11:59

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.