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 "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2014/05/07 00:14:14 UTC
[jira] [Comment Edited] (DERBY-6527) Fix errors in foreign keys
documentation
[ https://issues.apache.org/jira/browse/DERBY-6527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13991225#comment-13991225 ]
Dag H. Wanvik edited comment on DERBY-6527 at 5/6/14 10:12 PM:
---------------------------------------------------------------
1. "What does the parenthesized sentence mean?" I don't know the answer here, I'll write a test and see what we do...
3. "Same proviso as above" I think this means that if an FK (call it FK-1) is also a parent key for another FK (FK-2), then if FK-1 has ON DELETE CASCADE, then FK-2 must also have ON DELETE CASCADE, i.e. if it has NO ACTION or RESTRICT, a delete of a row in the primary table referenced by FK-1 will fail. (Since otherwise its cascading delete of the row containing FK-1 would lead to a conflict: the NO ACTION/RESTRICT would make that delete illegal.)
was (Author: dagw):
1. "What does the parenthesized sentence mean?" I don't know the answer here, I'll write a test and see what we do...
3. "Same proviso as above" I think this means that if an FK (call it FK-1) is also a parent key for another FK (FK-2), then is FK-1 has ON DELETE CASCADE, then FK-2 must also have ON DELETE CASCADE, i.e. if it has NO ACTION or RESTRICT, a delete of a row in the primary table referenced by FK-1 will fail. (Since otherwise it's cascading delete of the row containing FK-1 would lead to a conflict: the NO ACTION/RESTRICT would make that delete illegal.)
> Fix errors in foreign keys documentation
> ----------------------------------------
>
> Key: DERBY-6527
> URL: https://issues.apache.org/jira/browse/DERBY-6527
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
>
> Cf this email thread: http://apache-database.10148.n7.nabble.com/Foreign-key-semantics-as-documented-td138227.html
> Our documentation in the reference manual on foreign keys/referential actions has errors.
--
This message was sent by Atlassian JIRA
(v6.2#6252)