[DERBY-2992] getBinaryStream returns incorrect result (truncated value) if underlying blob is deleted

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0, 10.3.1.4, 10.4.1.3, 10.5.3.0, 10.6.1.0
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: JDBC
• Urgency: Normal
• Issue & fix info: High Value Fix, Repro attached
• Bug behavior facts: Regression, Wrong query result
• Assignee: Kristian Waagan
• Reporter: Katherine Marsden
• Created: 03/Aug/07 14:48
• Updated: 12/Jan/11 22:24
• Resolved: 07/Jul/10 20:37

Description

If getBinaryStream is reading a value (READ_UNCOMMITTED) and the row is deleted by another connection, a truncated value will be returned without error. I believe instead either the whole value or an IOException should occur.

With 10.2 and higher with the repro attahed we get:
> java TruncatedBlob
Embedded:
Read 32669 bytes
0 rows in BLOBCLOB

With 10.1
Embedded:
Read 40000 bytes (OK)
0 rows in BLOBCLOB

Note network server returns the full value for both 10.1 and 10.2 but gives a lock timeout for 10.2+. I will file a separate issue for that.

Issue Links

• is part of: DERBY-2034 Tracking of bugs that lead to incorrect results being stored or returned to the client
• is required by: DERBY-4728 10.5 backport effort tracking issue