Doctrine DBAL

Schema tools will alter tables with custom column definitions forever

Details

  • Type: Bug Bug
  • Status: Resolved 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
Permalink
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
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: