Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6664

Schema 'null' does not exist when trigger inserts into table with deferred foreign key

    XMLWordPrintableJSON

    Details

    • Urgency:
      Blocker

      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.

        Attachments

        1. d6664-1a.diff
          3 kB
          Knut Anders Hatlen

          Issue Links

            Activity

              People

              • Assignee:
                knutanders Knut Anders Hatlen
                Reporter:
                knutanders Knut Anders Hatlen
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: