[DERBY-6793] Stream or LOG value cannot be retrieved more than once

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.11.1.1
• Component/s: SQL
• Environment: does not matter
• Issue & fix info: Repro attached
• Bug behavior facts: Regression Test Failure, Seen in production
• Assignee: Unassigned
• Reporter: Sergey Zolotaryov
• Created: 06/Feb/15 14:22
• Updated: 10/Feb/15 08:09

Description

Since migrating from derby 10.7.1.1 to 10.11.1.1 really innocent code stopped working: retrieving resultset column data using column names if resultset contains blobs stopped working.

I am attaching a maven project with a unit test which proves the issue. If in pom.xml you change the version to 10.7.1.1 the test will pass. We are using spring-jdbc' queryForMap() which traverses resultset metadata and queries attributes by their column labels. Used to work before.

Issue Links

• is related to: DERBY-5489 getBinary() returns incorrect data after getObject() call on BLOB column