[DERBY-4130] Using large stream with 'values cast(? as clob)' causes OutOfMemoryError

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.6.1.0
• Component/s: Store
• Labels: derby_triage10_5_2
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Crash
• Assignee: Unassigned
• Reporter: Kristian Waagan
• Created: 30/Mar/09 13:40
• Updated: 15/Feb/11 21:08

Description

Inserting a stream though a values clause and casting the value to a Clob causes the stream to be materialized in memory.
If the stream is sufficiently large, this will result in an OutOfMemoryError.

Issue Links

• relates to: DERBY-4102 Assert failure or ClassCastException in EmbedBlob when retrieving BLOB >= 32K