Doctrine DBAL

MSSQL change column name

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Duplicate
  • Affects Version/s: 2.1.2, 2.1.7
  • Fix Version/s: None
  • Component/s: Platforms
  • Security Level: All
  • Labels:
    None
  • Environment:
    Symfony console, MSSQL Server 2008 r2

Description

Hello,

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.
to alter the name of a column in MSSQL you should use the store procedure "sp_rename"

http://msdn.microsoft.com/en-us/library/ms188351.aspx

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

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Fred Jiles added a comment -

I get this error as well. Just trying to change a field from nvarchar(40) to nvarchar(60) outputs this sql
ALTER TABLE offense_extension CHANGE disposition disposition NVARCHAR(60) DEFAULT NULL

It should be ALTER TABLE offense_extension ALTER COLUMN disposition NVARCHAR(60) NULL

Show
Fred Jiles added a comment - I get this error as well. Just trying to change a field from nvarchar(40) to nvarchar(60) outputs this sql ALTER TABLE offense_extension CHANGE disposition disposition NVARCHAR(60) DEFAULT NULL It should be ALTER TABLE offense_extension ALTER COLUMN disposition NVARCHAR(60) NULL
Hide
Permalink
Benjamin Eberlei added a comment -

This is fixed in another ticket i just realized and is included in the latest 2.1 DBAL release.

Show
Benjamin Eberlei added a comment - This is fixed in another ticket i just realized and is included in the latest 2.1 DBAL release.
Hide
Permalink
PandD added a comment - - edited

This problem still exists.

Here are some of the sql lines generated with :

ALTER TABLE msrs CHANGE Temp27 Temp27 SMALLINT NOT NULL;
ALTER TABLE batches CHANGE status status BIT DEFAULT NULL;

Doctrine DBAL Version: 2.1.7
MSSQL 2008 R2

Show
PandD added a comment - - edited This problem still exists. Here are some of the sql lines generated with : ALTER TABLE msrs CHANGE Temp27 Temp27 SMALLINT NOT NULL; ALTER TABLE batches CHANGE status status BIT DEFAULT NULL; Doctrine DBAL Version: 2.1.7 MSSQL 2008 R2

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Diego Vidal
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: