Doctrine DBAL

Mysql Numeric / Decimal fields

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Can't Fix
  • Affects Version/s: 2.0.0-BETA4, 2.0, 2.0.1
  • Fix Version/s: None
  • Component/s: None
  • Labels:
    None
  • Environment:
    mysql 5.1.49 for debian-linux-gnu (x86_64), Ubuntu 10.10 Doctrine DBAL Beta4 Doctrine ORM Beta4 Doctrine Common RC1

Description

class product {
/**
*Column(type="decimal", scale="2")
*
*/
private $discount;
}

generate SQL

create table product {
discount DECIMAL(10,2) NOT NULL
}

if you have a field in a database type DECIMAL doctrine tries to
generate for him diff

doctrine orm:schema-tool
>
ALTER TABLE product CHANGE discrount discrount NUMERIC (10, 2) NOT NULL

but mysql ignore the alter, as a result of these diff stretch from
migration to migration

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment -

This is fixed in RC1 or RC2.

Show
Benjamin Eberlei added a comment - This is fixed in RC1 or RC2.
Hide
Permalink
Eugene added a comment -

checked for the version of doctrine 2.1.0-DEV
result is the same

Show
Eugene added a comment - checked for the version of doctrine 2.1.0-DEV result is the same
Hide
Permalink
Oleg Anashkin added a comment -

I have the same issue with the latest doctrine build. Please fix it because it makes schema migration scripts dirty with redundant changes.

Show
Oleg Anashkin added a comment - I have the same issue with the latest doctrine build. Please fix it because it makes schema migration scripts dirty with redundant changes.
Hide
Permalink
Benjamin Eberlei added a comment -

I cannot reproduce this, does this happen if you also specify precision=10 ?

Show
Benjamin Eberlei added a comment - I cannot reproduce this, does this happen if you also specify precision=10 ?
Hide
Permalink
Alexander added a comment -

Closing until someone can provide more feedback.

Show
Alexander added a comment - Closing until someone can provide more feedback.
Hide
Permalink
Joel Simpson added a comment -

I am seeing this bug for a definition specified as:

  • @ORM\Column(type="decimal", precision=20, scale=0, nullable=false, unique=true)

Doctrine Command Line Interface version 2.3.2-DEV

Show
Joel Simpson added a comment - I am seeing this bug for a definition specified as: @ORM\Column(type="decimal", precision=20, scale=0, nullable=false, unique=true) Doctrine Command Line Interface version 2.3.2-DEV

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Eugene
Vote (2)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: