[DERBY-4425] NullPointerException with INSERT INTO ... from UNION and columns generated from expressions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 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
• Assignee: Bryan Pendleton
• Reporter: Knut Anders Hatlen
• Created: 26/Oct/09 09:52
• Updated: 13/Jan/11 17:18
• Resolved: 06/Jul/10 18:55

Description

This bug is similar to DERBY-4419, only that it uses columns that are auto-generated from expressions and not identity columns. The proposed fix for DERBY-4419 only addresses the case with an identity column.

ij> create table t1(x int);
0 rows inserted/updated/deleted
ij> create table t2(x int);
0 rows inserted/updated/deleted
ij> create table t3(x int, y generated always as (2*x));
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 required by: DERBY-4728 10.5 backport effort tracking issue
• relates to: DERBY-4419 NullPointerException with INSERT INTO ... from UNION and identity columns
• relates to: DERBY-4442 Evaluation of default value and identity in an INSERT result set evaluated too early.