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 5B20117250 for ; Thu, 9 Oct 2014 16:04:35 +0000 (UTC) Received: (qmail 71504 invoked by uid 500); 9 Oct 2014 16:04:34 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 71427 invoked by uid 500); 9 Oct 2014 16:04:34 -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 71202 invoked by uid 99); 9 Oct 2014 16:04:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Oct 2014 16:04:34 +0000 Date: Thu, 9 Oct 2014 16:04:34 +0000 (UTC) From: "Mike Matrigali (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DERBY-6576) A immediate Fk constraint blows up iff its referenced PK is deferred and we modify a duplicate key column 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-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-6576: ---------------------------------- Labels: derby_backport_reject_10_10 (was: ) bug is dependent on deferred constraint work which was introduced in 10.11, settling label to not backport. > A immediate Fk constraint blows up iff its referenced PK is deferred and we modify a duplicate key column > --------------------------------------------------------------------------------------------------------- > > Key: DERBY-6576 > URL: https://issues.apache.org/jira/browse/DERBY-6576 > Project: Derby > Issue Type: Bug > Components: SQL > Reporter: Dag H. Wanvik > Assignee: Dag H. Wanvik > Labels: derby_backport_reject_10_10 > Fix For: 10.11.1.1 > > Attachments: derby-6576-2.diff, derby-6576-3.diff, derby-6576-3.status, derby-6576-cascade-setnull.diff, derby-6576-cascade-setnull.status, derby-6576-forbid-deferred+cascade-set-null-1.diff, derby-6576-forbid-deferred+cascade-set-null-1.status, derby-6576-repeatable-read.diff, derby-6576.diff, derby-6576.status > > > Similar to the issue in DERBY-6559, except here we modify the key in the referenced table. This leads Derby to check for any referencing FK and throw, even if there are other (formerly) duplicate rows that satisfy the FK constraint. -- This message was sent by Atlassian JIRA (v6.3.4#6332)