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

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development