[DERBY-6348] NPE or assert failure in recursive trigger

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1, 10.6.1.0, 10.7.1.1, 10.8.1.2, 10.9.1.0, 10.10.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: SQL
• Issue & fix info: Repro attached
• Bug behavior facts: Regression
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 18/Sep/13 12:16
• Updated: 21/Jan/15 00:23
• Resolved: 15/Nov/13 10:43

Description

With 10.5.1.1 and newer, the following ij session fails with a NullPointerException (production jars) or an assert failure (debug jars):

ij version 10.10
ij> connect 'jdbc:derby:db;create=true';
ij> create table t(x int);
0 rows inserted/updated/deleted
ij> insert into t values 0;
1 row inserted/updated/deleted
ij> create trigger tr1 after update on t values 1;
0 rows inserted/updated/deleted
ij> create trigger tr2 after update on t for each row update t set x = x + 1 where x < 3;
0 rows inserted/updated/deleted
ij> update t set x = x + 1;
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

It does not fail on 10.4.2.0:

ij version 10.4
ij> connect 'jdbc:derby:db;create=true';
ij> create table t(x int);
0 rows inserted/updated/deleted
ij> insert into t values 0;
1 row inserted/updated/deleted
ij> create trigger tr1 after update on t values 1;
0 rows inserted/updated/deleted
ij> create trigger tr2 after update on t for each row update t set x = x + 1 where x < 3;
0 rows inserted/updated/deleted
ij> update t set x = x + 1;
1 row inserted/updated/deleted
ij> select * from t;
X
-----------
3

1 row selected

Issue Links

• is broken by: DERBY-3897 SQLSessionContext not correctly initialized in some non-method call nested contexts
• relates to: DERBY-534 Support use of the WHEN clause in CREATE TRIGGER statements