Derby
  1. Derby
  2. DERBY-1515

Provide ALTER TABLE functionality to change a column's data type

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Won't Fix
    • Affects Version/s: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
    • Fix Version/s: None
    • Component/s: Documentation, SQL
    • Labels:
      None

      Description

      Derby should provide a feature which allows a user to change the data type of an existing column in an existing table.

      Currently, there exists the statement:

      ALTER TABLE tablename ALTER COLUMN columnname SET DATA TYPE datatype

      However, this statement currently only allows increasing the length of a VARCHAR column. You are not allowed to decrease the width or to change the data type.

      It would be nice if this restriction could be lifted, and the datatype could be changed.

        Issue Links

          Activity

          Bryan Pendleton created issue -
          Bryan Pendleton made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-396 [ DERBY-396 ]
          Bryan Pendleton made changes -
          Link This issue is related to DERBY-396 [ DERBY-396 ]
          Bryan Pendleton made changes -
          Resolution Won't Fix [ 2 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Andrew McIntyre made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Gavin made changes -
          Workflow jira [ 12375509 ] Default workflow, editable Closed status [ 12799460 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development