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

ALTER TABLE DROP COLUMN needs to update GRANTed column privileges

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None

      Description

      When ALTER TABLE DROP COLUMN is used to drop a column from a table, it needs to update the GRANTed column privileges on that table.

      The following behaviors need to be provided:

      • DROP COLUMN needs to automatically revoke any privileges which have been granted on this column
      • Privileges which have been granted on other columns in this table need to be adjusted due to changed column position numbers

      When this problem is fixed, the following additional cleanup steps should occur:

      • The check that disables DROP COLUMN in sqlAuthorization mode needs to be removed
      • There is a comment in AlterTableConstantAction that needs to be revised
      • The tests in lang/altertableDropColumn.sql should be moved into altertable.sql
      • altertableDropColumn.sql and altertableDropColumn.out should be deleted

      Search for this JIRA issue number in the code to find the relevant places to change.

        Attachments

        1. d1909_partial_incomplete.diff
          6 kB
          Bryan Pendleton
        2. repro.sql
          0.3 kB
          Bryan Pendleton
        3. rewrite_syscolperms_v1.diff
          89 kB
          Bryan Pendleton
        4. rewrite_syscolperms_v1.stat
          0.8 kB
          Bryan Pendleton
        5. rewrite_syscolperms_v2.diff
          89 kB
          Bryan Pendleton
        6. rewrite_syscolperms_v3.diff
          90 kB
          Bryan Pendleton

          Issue Links

            Activity

              People

              • Assignee:
                bryanpendleton Bryan Pendleton
                Reporter:
                bryanpendleton Bryan Pendleton
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: