[DERBY-1208] Attempts to reuse a prepared statement after an execution-time error causes ASSERT failure in SANE mode, but work fine in INSANE.

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.2.1.6
• Component/s: JDBC
• Labels: derby_triage10_8
• Urgency: Low
• Issue & fix info: Repro attached
• Bug behavior facts: Seen in production
• Assignee: Unassigned
• Reporter: A B
• Created: 13/Apr/06 00:21
• Updated: 16/Feb/11 14:39

Description

Please see the comments in DERBY-1196 for the discussion that prompted the filing of this issue. In short, if one attempts to reuse a prepared statement with a new set of parameters after a previous call to execute that statement has failed, the result will be an ASSERT failure in SANE mode. When the same thing is done in INSANE mode, everything works as one might expect it to.