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 "Oleksandr Alesinskyy (JIRA)" <ji...@apache.org> on 2008/04/08 10:23:24 UTC
[jira] Created: (DERBY-3605) Remove restriction "If there is an
index defined on the table, the table can be renamed."
Remove restriction "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
Affects Versions: 10.3.2.1
Environment: N/A
Reporter: Oleksandr Alesinskyy
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.
[jira] Commented: (DERBY-3605) Remove restriction "If there is an
index defined on the table, the table can be renamed."
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785110#action_12785110 ]
Dag H. Wanvik commented on DERBY-3605:
--------------------------------------
I'd be ok just removing this sentence. But either way is fine with me. +1
> Remove restriction "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: SQL
> Affects Versions: 10.3.2.1
> Environment: N/A
> Reporter: Oleksandr Alesinskyy
>
> 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.
[jira] Commented: (DERBY-3605) Remove confusing statement "If there
is an index defined on the table, the table can be renamed."
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785357#action_12785357 ]
Kim Haase commented on DERBY-3605:
----------------------------------
Looks fine to me -- thanks, Bryan.
> 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.
[jira] Commented: (DERBY-3605) Remove restriction "If there is an
index defined on the table, the table can be renamed."
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785072#action_12785072 ]
Bryan Pendleton commented on DERBY-3605:
----------------------------------------
I think maybe this is just a documentation problem, and that sentence can simply be
removed from the RENAME TABLE page in the reference guide.
Please note that the sentence says "can be renamed", not "cannot be renamed".
I think this might be confusing; people might have thought it was saying that the
table *cannot* be renamed if there is an index defined on it, but I think that the
documentation is correctly stating that the table *can* be renamed if there is an
index defined on it.
As far as I know, a table can be renamed even if it has one or more indexes on it,
and we have at least 1 regression test (in RenameTableTest.java) which verifies this.
Perhaps the best thing to do would be to re-word that sentence slightly:
Note that a table can be renamed even if it has one or more indexes defined on it;
the presence of an index defined on the table does not prevent the table from
being renamed.
Or, we could just remove the sentence.
> Remove restriction "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: SQL
> Affects Versions: 10.3.2.1
> Environment: N/A
> Reporter: Oleksandr Alesinskyy
>
> 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.
[jira] Updated: (DERBY-3605) Remove confusing statement "If there
is an index defined on the table, the table can be renamed."
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-3605) Remove confusing statement "If there
is an index defined on the table, the table can be renamed."
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-3605:
-----------------------------------
Component/s: (was: SQL)
Documentation
Assignee: Bryan Pendleton
Summary: Remove confusing statement "If there is an index defined on the table, the table can be renamed." (was: Remove restriction "If there is an index defined on the table, the table can be renamed.")
Reclassified as a documentation issue.
> 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
>
> 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.
[jira] Resolved: (DERBY-3605) Remove confusing statement "If there
is an index defined on the table, the table can be renamed."
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-3605) Remove restriction "If there is an
index defined on the table, the table can be renamed."
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-3605:
----------------------------------
Component/s: SQL
> Remove restriction "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: SQL
> Affects Versions: 10.3.2.1
> Environment: N/A
> Reporter: Oleksandr Alesinskyy
>
> 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.