Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 41169 invoked from network); 3 Dec 2009 15:39:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Dec 2009 15:39:44 -0000 Received: (qmail 14509 invoked by uid 500); 3 Dec 2009 15:39:44 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 14440 invoked by uid 500); 3 Dec 2009 15:39:44 -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 14432 invoked by uid 99); 3 Dec 2009 15:39:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Dec 2009 15:39:44 +0000 X-ASF-Spam-Status: No, hits=-10.5 required=5.0 tests=AWL,BAYES_00,RCVD_IN_DNSWL_HI X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Dec 2009 15:39:41 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id EEC41234C498 for ; Thu, 3 Dec 2009 07:39:20 -0800 (PST) Message-ID: <1674286502.1259854760976.JavaMail.jira@brutus> Date: Thu, 3 Dec 2009 15:39:20 +0000 (UTC) From: "Bryan Pendleton (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Resolved: (DERBY-3605) Remove confusing statement "If there is an index defined on the table, the table can be renamed." In-Reply-To: <1188340187.1207643004310.JavaMail.jira@brutus> 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-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton resolved DERBY-3605. ------------------------------------ Resolution: Fixed Fix Version/s: 10.6.0.0 Thanks Kim! Committed to the documentation trunk as revision 886824. > Remove confusing statement "If there is an index defined on the table, the table can be renamed." > ------------------------------------------------------------------------------------------------- > > Key: DERBY-3605 > URL: https://issues.apache.org/jira/browse/DERBY-3605 > Project: Derby > Issue Type: Improvement > Components: Documentation > Affects Versions: 10.3.2.1 > Environment: N/A > Reporter: Oleksandr Alesinskyy > Assignee: Bryan Pendleton > Fix For: 10.6.0.0 > > Attachments: docs.diff, rrefsqljrenametablestatement.html > > > Remove following restriction for "RENAME TABLE" statement: > "If there is an index defined on the table, the table can be renamed." > I really do not see any valid reasons (except, probably not very wise implementation) for existence this restriction. And it may come very inconvinient if table to be renamed has an index(ses) referenced by foreign keys from other tables. > Regards, > Oleksandr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.