db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6571) Document deferrable constraints
Date Mon, 02 Jun 2014 23:10:01 GMT

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

Dag H. Wanvik commented on DERBY-6571:
--------------------------------------

Hi Kim, I have added a limitation to the implementation which we should document, cf. version
1.9 of the functional specification.
It should go under foreign keys (section rrefsqlj13590.html, subsection "Foreign key constraints"),
just before the final "Note" paragraph, perhaps - no, make it the third but the last paragraph:
"If the references clause contains a CASCADE or SET NULL referential action, the primary or
unique key referenced must not be deferrable".

Now that I look at this section again, I also see the following statement which is no longer
accurate:

(subsection "Foreign key constraints and DML"):

"Derby performs constraint checks at the time the statement is executed, not when the transaction
commits."

This should be, now that a foreign key constraint can deferred,

"Derby performs constraint checks at the time the statement is executed, unless the constraint's
mode is DEFERRED, see above." ?

> Document deferrable constraints
> -------------------------------
>
>                 Key: DERBY-6571
>                 URL: https://issues.apache.org/jira/browse/DERBY-6571
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>              Labels: derby_backport_reject_10_10
>             Fix For: 10.11.0.0
>
>         Attachments: DERBY-6571-2.diff, DERBY-6571-2.stat, DERBY-6571-2.zip, DERBY-6571-3.diff,
DERBY-6571-3.stat, DERBY-6571-3.zip, DERBY-6571-4.diff, DERBY-6571-4.stat, DERBY-6571-4.zip,
DERBY-6571-5.diff, DERBY-6571-5.stat, DERBY-6571-5.zip, DERBY-6571.diff, DERBY-6571.stat,
DERBY-6571.zip
>
>
> The contents of functional specification attached to DERBY-532 should be included in
the documentation.



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

Mime
View raw message