[
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)
