[DERBY-4683] NPE in parameterized INSERT/SELECT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.6.2.1
• Component/s: SQL
• Bug behavior facts: Regression, Seen in production
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 31/May/10 16:34
• Updated: 14/Oct/10 20:24
• Resolved: 31/May/10 17:35

Description

The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4671.

ij version 10.6
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table t
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> create table s
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> – fails on 10.6.1.0 but succeeds on 10.5.3.0
prepare foo as 'insert into t select ?, c from s';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

Issue Links

• duplicates: DERBY-4671 Embedded driver does not work with jbossCache