Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-687

orm:schema-tool:update reports already updated NUMERIC fields

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: 2.3.4
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:
      None
    • Environment:
      PHP 5.3.10-1ubuntu3.6 with Suhosin-Patch (cli) (built: Mar 11 2013 14:31:48)
      Mysql version: 5.5.31-0ubuntu0.12.04.1 (Ubuntu)

      Description

      I have a table defined in this way:

      CREATE TABLE `my_table` (
      `id` int(10) NOT NULL AUTO_INCREMENT,
      `subtotal` decimal(10,2) DEFAULT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

      When I run
      php doctrine.php orm:schema-tool:update --dump-sql

      I get
      ALTER TABLE my_table CHANGE subtotal subtotal NUMERIC(10, 2) DEFAULT NULL;

      While of course the field is already updated. The same happens in SQL Server 2008 and Postgres 9.

        Activity

        Francesco Montefoschi created issue -
        Steve Müller made changes -
        Field Original Value New Value
        Project Doctrine 2 - ORM [ 10032 ] Doctrine DBAL [ 10040 ]
        Key DDC-2448 DBAL-687
        Affects Version/s 2.3.4 [ 10421 ]
        Affects Version/s 2.3.4 [ 10420 ]
        Component/s Tools [ 10015 ]
        Security All [ 10000 ]
        Benjamin Eberlei made changes -
        Status Open [ 1 ] Awaiting Feedback [ 10000 ]
        Benjamin Eberlei made changes -
        Status Awaiting Feedback [ 10000 ] Open [ 1 ]
        Benjamin Eberlei made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Francesco Montefoschi
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: