[DERBY-714] NullPointerException or ClassCastException if UPDATE or DELETE is performed on a diagnostic VTI

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.1.1.0
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Assignee: Daniel John Debrunner
• Reporter: Daniel John Debrunner
• Created: 18/Nov/05 05:49
• Updated: 19/Nov/05 06:59
• Resolved: 19/Nov/05 06:58

Description

UPDATE and DELETE statements on read-only vtis will hit NullPointerException in insane mode, and ClassCastException in sane mode.

ij> delete from new org.apache.derby.diag.TransactionTable();
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

While these statements make no sense, a more graceful error should be returned, especially as in insane mode this causes the engine to shutdown. Code already exists to detect this situation but is not being called.

Found through adding negative tests for DERBY-571

Issue Links

• blocks: DERBY-571 Virtual Table Mapping for no argument Diagnostic tables