[ http://issues.apache.org/jira/browse/DDLUTILS-118?page=all ]
Niklas Ekman updated DDLUTILS-118:
----------------------------------
Description:
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)
was:
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 fields ALTER COLUMN test TYPE VARCHAR(111)
> 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
