db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6667) Redundant word "referencing" in error message for deferred constraints.
Date Wed, 16 Jul 2014 13:39:04 GMT
Rick Hillegas created DERBY-6667:
------------------------------------

             Summary: Redundant word "referencing" in error message for deferred constraints.
                 Key: DERBY-6667
                 URL: https://issues.apache.org/jira/browse/DERBY-6667
             Project: Derby
          Issue Type: Bug
          Components: SQL
            Reporter: Rick Hillegas
            Priority: Trivial
             Fix For: 10.11.0.0


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

{noformat}
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)'.
{noformat}




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

Mime
View raw message