[ http://issues.apache.org/jira/browse/DDLUTILS-118?page=all ]
Thomas Dudziak resolved DDLUTILS-118.
-------------------------------------
Resolution: Fixed
This only appeared when using writeSchemaSqlToFile, which for some reason used
the old alteration algorithm. I've removed this old algorithm, and now the
correct SQL is generated.
> Modifying columns generates wrong SQL statement
> -----------------------------------------------
>
> Key: DDLUTILS-118
> URL: http://issues.apache.org/jira/browse/DDLUTILS-118
> Project: DdlUtils
> Issue Type: Bug
> Components: Core - PostgreSql
> Environment: PostgreSQL Database Server 8.1, Windows XP SP2, JDBC
> driver version 8.1-407 JDBC3
> Reporter: Niklas Ekman
> Assigned To: Thomas Dudziak
> Priority: Minor
>
> When changing a column size the following SQL statement is generated:
> ALTER TABLE testtable MODIFY test VARCHAR(100)
> But according to the PostgreSQL manual it should look like
> ALTER TABLE testtable ALTER COLUMN test TYPE VARCHAR(111)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
