mirror of
https://github.com/doctrine/orm.git
synced 2026-03-24 06:52:09 +01:00
DDC-1622: Doctrine 2.1 CLI orm:schema-tool update/create reverses scale and precision values for decimal columns #2040
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @doctrinebot on GitHub (Jan 26, 2012).
Originally assigned to: @beberlei on GitHub.
Jira issue originally created by user fosberyi:
This property definition (or anything with decimal, scale and precision defined):
/****
* @var decimal $cost
*
* @Column(name="cost", type="decimal", scale=6, precision=2, nullable=true)
*/
private $cost;
Produces this in the orm:schema-tool CLI:
ALTER TABLE items CHANGE cost cost NUMERIC(2, 6) DEFAULT NULL, ...
Which fails. Have to go through the SQL code and change manually.
@doctrinebot commented on GitHub (Jul 8, 2012):
Comment created by @beberlei:
You mixed up scale and precision.
@doctrinebot commented on GitHub (Jul 8, 2012):
Issue was closed with resolution "Invalid"
@mscodemonkey commented on GitHub (May 27, 2019):
Is this still a bug because i'm still having to reverse scale and precision to make it create it correctly in the database when creating migrations.
E.g.
<field name="value" type="decimal" column="value" scale="11" precision="2" nullable="false"/>when creating a migration generates the following code for postgresql...
$this->addSql('ALTER TABLE payment ALTER value TYPE NUMERIC(2, 11)');