db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6664) Schema 'null' does not exist when trigger inserts into table with deferred foreign key
Date Tue, 15 Jul 2014 14:22:04 GMT
Knut Anders Hatlen created DERBY-6664:
-----------------------------------------

             Summary: Schema 'null' does not exist when trigger inserts into table with deferred
foreign key
                 Key: DERBY-6664
                 URL: https://issues.apache.org/jira/browse/DERBY-6664
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.11.0.0
            Reporter: Knut Anders Hatlen


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:

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

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



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message