[DERBY-4420] NullPointerException with INSERT INTO ... from EXCEPT/INTERSECT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0, 10.2.1.6, 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
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 23/Oct/09 06:56
• Updated: 21/May/10 10:53
• Resolved: 03/Nov/09 11:51

Description

The sequence of statements below give a NullPointerException. The statements are very similar to the ones in DERBY-4419, but this is a separate bug since the stack traces are different, and this bug can be seen all the way back to 10.1.1.0, whereas DERBY-4419 was a regression in 10.3. (On 10.0.2.1, a syntax error is raised instead of the NPE.)

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 except select * from t2;
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

Same error if INTERSECT is used instead of EXCEPT.

Issue Links

• is related to: DERBY-4433 Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source
• is related to: DERBY-4671 Embedded driver does not work with jbossCache