Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-52

Schema tools will alter tables with custom column definitions forever

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Critical Critical
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      MySQL 5.1, PDO MySQL

      Description

      When using custom column definition, schema tool will execute the same update statements over and over. It looks like schema tool can't find out yet, if the custom column definition has already been applied.
      As MySQL does full table rebuilds quite often (sometimes for no or at least debatable reasons), this makes the schema tool for large migrations quite hard to use in a production system deployment scenario.

        Activity

        Hide
        Benjamin Eberlei added a comment - - edited

        Yes this is a known issue, i plan to fix this with DDC-42, however it will take until 2.1 i guess. It annoys me too

        Maybe we should also add a note to the manual, schema-tool incremental update is a development tool and should not be used on the production server.

        Show
        Benjamin Eberlei added a comment - - edited Yes this is a known issue, i plan to fix this with DDC-42 , however it will take until 2.1 i guess. It annoys me too Maybe we should also add a note to the manual, schema-tool incremental update is a development tool and should not be used on the production server.

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Lars Strojny
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: