Doctrine Migrations
  1. Doctrine Migrations
  2. DMIG-8

MySQL + Doctrine 2 + Column of type decimal with no precision or scale manually set results in infinite migration diffs generated

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Labels:
      None
    • Environment:
      Debian 5.0, PHP 5.3.3, MySQL 5.1.50, Doctrine 2.0.0BETA4, Annotations

      Description

      To reproduce:

      Create a new entity with a column type decimal @Column(type="decimal")

      Run the CLI tool "migrations:diff"

      Run the CLI tool "migrations:migrate"

      If you run "migrations:diff" again a new migration will be created with an ALTER TABLE that only affects the columns of type Decimal. You can apply these new migrations and generate more using Diff ad nauseum.

      My assumption is there is a mismatch between the Migrations Diff and annotation's defaults, causing it to continually identify decimal columns as requiring a migration.

      To avoid this issue manually set a precision and scale, everything will then work as expected.

        Activity

        Daniel Cousineau created issue -
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Assignee Jonathan H. Wage [ jwage ] Benjamin Eberlei [ beberlei ]

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DMIG-8, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Daniel Cousineau
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: