Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C24561135E for ; Tue, 6 May 2014 22:14:16 +0000 (UTC) Received: (qmail 49983 invoked by uid 500); 6 May 2014 22:14:16 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 49967 invoked by uid 500); 6 May 2014 22:14:15 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 49956 invoked by uid 99); 6 May 2014 22:14:14 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 May 2014 22:14:14 +0000 Date: Tue, 6 May 2014 22:14:14 +0000 (UTC) From: "Dag H. Wanvik (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Comment Edited] (DERBY-6527) Fix errors in foreign keys documentation MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)