[DERBY-6664] Schema 'null' does not exist when trigger inserts into table with deferred foreign key

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.11.1.1
• Component/s: SQL
• Labels: derby_backport_reject_10_10
• Urgency: Blocker
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 15/Jul/14 14:20
• Updated: 09/Sep/16 09:51
• Resolved: 15/Jul/14 20:25

Description

If you modify the repro attached to DERBY-6663 so that the foreign key constraint TREF is INITIALLY DEFERRED, the final insert statement will fail like this:

ij> insert into othertable values 1;
ERROR 42Y07: Schema 'null' does not exist

I think the fix will be similar to DERBY-6663. FKInfo needs to store its schemaName field.

Issue Links

• relates to: DERBY-6663 NPE when a trigger tries to insert into a table with a foreign key