[DERBY-5121] Data corruption when executing an UPDATE trigger

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1, 10.8.1.2
• Fix Version/s: 10.7.1.4, 10.8.1.2
• Component/s: SQL
• Labels: derby_backport_reject_10_5
• Urgency: Blocker
• Issue & fix info: Release Note Needed, Repro attached
• Bug behavior facts: Data corruption, Regression, Seen in production
• Assignee: Mamta A. Satoor
• Reporter: Richard N. Hillegas
• Created: 10/Mar/11 02:40
• Updated: 14/Jun/13 17:29
• Resolved: 29/Mar/11 16:55

Description

When executing an UPDATE trigger, the following error is raised. I will attach a test case:

ERROR XCL12: An attempt was made to put a data value of type 'org.apache.derby.impl.jdbc.EmbedClob' into a data value of type 'INTEGER'.

Issue Links

• is broken by: DERBY-1482 Update triggers on tables with blob columns stream blobs into memory even when the blobs are not referenced/accessed.