[DBAL-199] MSSQL change column name Created: 15/Nov/11 Updated: 14/Nov/12 Resolved: 09/Jan/12
|Affects Version/s:||2.1.2, 2.1.7|
|Reporter:||Diego Vidal||Assignee:||Benjamin Eberlei|
Symfony console, MSSQL Server 2008 r2
to create a schema for mssql works ok, but to alter the name of a column, use the SQL command "CHANGE" and Mssql not recognize this command.
Do not know if I'm doing something the wrong way, but the command "php app \ console doctrine: schema: update" does not work by altering the name of the column
sorry my english it's very poor
|Comment by Fred Jiles [ 30/Nov/11 ]|
I get this error as well. Just trying to change a field from nvarchar(40) to nvarchar(60) outputs this sql
It should be ALTER TABLE offense_extension ALTER COLUMN disposition NVARCHAR(60) NULL
|Comment by Benjamin Eberlei [ 09/Jan/12 ]|
This is fixed in another ticket i just realized and is included in the latest 2.1 DBAL release.
|Comment by PandD [ 14/Nov/12 ]|
This problem still exists.
Here are some of the sql lines generated with :
ALTER TABLE msrs CHANGE Temp27 Temp27 SMALLINT NOT NULL;
Doctrine DBAL Version: 2.1.7