[DERBY-4779] NPE while inserting into a table which has a generated column and an insert trigger

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.3.0, 10.6.1.0, 10.7.1.1
• Fix Version/s: 10.5.3.2, 10.6.2.4, 10.7.1.4, 10.8.2.2, 10.9.1.0
• Component/s: SQL
• Labels: derby_triage10_8
• Urgency: Normal
• Issue & fix info: High Value Fix, Repro attached
• Assignee: Siddharth Srivastava
• Reporter: Richard N. Hillegas
• Created: 17/Aug/10 19:40
• Updated: 14/Jun/13 17:34
• Resolved: 16/Mar/12 21:19

Description

The following script generates an NPE on the concluding insert:

connect 'jdbc:derby:memory:dummy;create=true';

create function getRegion( v int )
returns varchar( 20 )
language java parameter style java deterministic no sql
external name 'java.lang.Integer.toString'
;

create table orders
(
orderID bigint primary key,
salesPrice int not null,
region generated always as ( getRegion( salesPrice ) )
)
;
create table dummy( a int );

create trigger newOrderTrigger
after insert on orders
for each row
insert into dummy( a ) values ( 1 )
;

insert into orders( orderID, salesPrice ) values ( 1, 2 )
;

------------------------

Here is the NPE:

java.lang.NullPointerException
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.objectifyStreams(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
at org.apache.derby.tools.ij.main(Unknown Source)

Issue Links

• is required by: DERBY-5654 10.5 Backport issue (2012)