[DERBY-4419] NullPointerException with INSERT INTO ... from UNION and identity columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4, 10.4.1.3, 10.5.1.1, 10.5.3.0, 10.6.1.0
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: Repro attached
• Bug behavior facts: Regression
• Assignee: Bryan Pendleton
• Reporter: Knut Anders Hatlen
• Created: 23/Oct/09 06:42
• Updated: 13/Jan/11 17:18
• Resolved: 06/Jul/10 18:53

Description

The following sequence of statements works on 10.2.2.0 and earlier, and raises a NullPointerException with 10.3.1.4 and later:

ij> create table t1(x int);
0 rows inserted/updated/deleted
ij> insert into t1 values 1,2;
2 rows inserted/updated/deleted
ij> create table t2(x int);
0 rows inserted/updated/deleted
ij> insert into t2 values 2,3;
2 rows inserted/updated/deleted
ij> create table t3(x int, y int generated always as identity);
0 rows inserted/updated/deleted
ij> insert into t3 select * from t1 union select * from t2;
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

Issue Links

• is related to: DERBY-4425 NullPointerException with INSERT INTO ... from UNION and columns generated from expressions
• is required by: DERBY-4728 10.5 backport effort tracking issue
• relates to: DERBY-4442 Evaluation of default value and identity in an INSERT result set evaluated too early.
• relates to: DERBY-1644 NPE when inserting values to a table that has a column declared as generated by default as identity