Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3605

Remove confusing statement "If there is an index defined on the table, the table can be renamed."

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.3.2.1
    • 10.6.1.0
    • Documentation
    • None
    • N/A
    • Normal

    Description

      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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bryanpendleton Bryan Pendleton
            al0 Oleksandr Alesinskyy
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment