[#DDLUTILS-53] Incorrect syntax for modifying columns in Derby

DdlUtils

Incorrect syntax for modifying columns in Derby

Created: 17/Dec/05 08:52 AM Updated: 04/Jun/07 02:34 AM

Return to search

Component/s:

Core - Derby/Cloudscape/JavaDB

Affects Version/s:

None

Fix Version/s:

1.0 RC1

Time Tracking:

Not Specified

Resolution Date:

13/Jul/06 01:21 PM

Description

« Hide

The SQL DdlUtils generates for modifying a column in Derby 10.1 seems incorrect. specifically it cxreates statements like

ALTER TABLE "coltype"
MODIFY "COL_FLOAT" DOUBLE PRECISION;

According to the documentation the correct syntax would have to be

ALTER TABLE "coltype"
ALTER "COL_FLOAT" SET DATA TYPE DOUBLE PRECISION;

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

[ Permlink | « Hide ]

Thomas Dudziak added a comment - 13/Jul/06 01:21 PM

Since the modification of column data types is quite limited in Derby, it is no longer used. Rather the table will be rebuild now

Thomas Dudziak made changes - 13/Jul/06 01:21 PM

Field	Original Value	New Value
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

Thomas Dudziak made changes - 13/Jul/06 02:36 PM

Component/s

Core - Derby/Cloudscape/JavaDB [ 12311210 ]

Thomas Dudziak made changes - 04/Jun/07 02:34 AM

Fix Version/s

1.0 RC1 [ 12312482 ]