Uploaded image for project: 'Liquibase Core'
  1. CORE-1833

Roll up addColumn and dropColumn changes for MySQL

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.1.1
    • Fix Version/s: None
    • Environment:

      MySQL

    • Sprint:

      Description

      Currently the produced SQL for MySQL for the addColumn change is inefficient, if multiple columns are added at once. In that case, only one ALTER TABLE statement should be produced which can add the new columns in one go and therefore speed up the database migration. This is especially painful for large tables, as MySQL needs to copy the whole table in order to add columns. If the statements are combined into one alter table, the copy needs to be done only once.

      A similar approach should be possible with dropColumn.

      Note: This improvement is similar to CORE-46 Open but only for one single change.

        Attachments

          Activity

            People

            • Reporter:
              adangel Andreas Dangel
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: