db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3605) Remove confusing statement "If there is an index defined on the table, the table can be renamed."
Date Thu, 03 Dec 2009 03:07:21 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Bryan Pendleton updated DERBY-3605:
-----------------------------------

    Attachment: rrefsqljrenametablestatement.html
                docs.diff

Attached is the patch to remove the confusing sentence, and the HTML page that results.

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


Mime
View raw message