db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6667) Redundant word "referencing" in error message for deferred constraints.
Date Mon, 28 Jul 2014 17:10:38 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14076402#comment-14076402
] 

ASF subversion and git services commented on DERBY-6667:
--------------------------------------------------------

Commit 1614077 from [~rhillegas] in branch 'code/trunk'
[ https://svn.apache.org/r1614077 ]

DERBY-6667: Make Test_6661 create its own, empty, single-use database; commit derby-6676-01-aa-singleUseDecorator.diff.

> 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
>            Assignee: Rick Hillegas
>            Priority: Trivial
>             Fix For: 10.11.0.0
>
>         Attachments: derby-6667-01-aa-removeRedundantWord.diff
>
>
> 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)

Mime
View raw message