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

Redundant word "referencing" in error message for deferred constraints.

    XMLWordPrintableJSON

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached

      Description

      There is an extra "referencing" in the error message when committing a violated deferred foreign key.

      ij version 10.11
      ij> connect 'jdbc:derby:memory:db;create=true';
      ij> create table tprim
      (
        a int primary key
      );
      0 rows inserted/updated/deleted
      ij> create table tref
      (
        a int,
        constraint tref foreign key( a ) references tprim( a ) initially deferred
      );
      0 rows inserted/updated/deleted
      ij> insert into tprim values ( 1 );
      1 row inserted/updated/deleted
      ij> autocommit off;
      ij> insert into tref values ( 1 );
      1 row inserted/updated/deleted
      ij> delete from tprim;
      1 row inserted/updated/deleted
      ij> commit;
      ERROR 23516: The transaction was aborted because of a deferred constraint violation: Foreign key 'TREF' defined on "APP"."TPRIM" referencing referencing constraint 'SQL140716063201410' defined on "APP"."TPRIM", key '(1)'.
      

        Attachments

        1. derby-6667-01-aa-removeRedundantWord.diff
          0.8 kB
          Richard N. Hillegas

          Activity

            People

            • Assignee:
              DimuthuW Dimuthu Wickramanayake
              Reporter:
              rhillegas Richard N. Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: