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 "Bryan Pendleton (JIRA)" <ji...@apache.org> on 2009/12/03 16:39:20 UTC

[jira] Resolved: (DERBY-3605) Remove confusing statement "If there is an index defined on the table, the table can be renamed."

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