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

Enable the adding of generated columns via ALTER TABLE

    XMLWordPrintableJSON

    Details

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

      Description

      The initial grammar patch for generated columns did not include ALTER TABLE support. This support cannot be added until we check in the UPDATE logic for generated columns. Adding a generated column to an existing table is supposed to calculate the generated column's values for all rows currently in the table.

        Attachments

        1. derby-3922-01-aa-repopulate.diff
          14 kB
          Richard N. Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                rhillegas Richard N. Hillegas
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: