You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2014/07/16 15:39:04 UTC
[jira] [Updated] (DERBY-6667) Redundant word "referencing" in error
message for deferred constraints.
[ https://issues.apache.org/jira/browse/DERBY-6667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-6667:
---------------------------------
Description:
There is an 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}
was:
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}
Issue & fix info: Repro attached
> 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 an 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)