[#DERBY-168] Can't ALTER a column to have a new DEFAULT value.

Derby

Can't ALTER a column to have a new DEFAULT value.

Created: 09/Mar/05 11:36 AM Updated: 17/Oct/05 10:37 PM

Return to search

Component/s:

Documentation

Affects Version/s:

10.0.2.0

Fix Version/s:

10.1.1.0

Time Tracking:

Not Specified

File Attachments:

	File Name	Date Attached	Attached By	Size
	derby168.diff	2005-05-09 01:08 PM	Jeff Levitt	2 kB

Environment:

Windows XP SP1 Professional

Issue Links:

Reference

This issue is related to:

~~DERBY-396~~ Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN

Resolution Date:

12/May/05 03:18 AM

Description

« Hide

Documentation states that an existing column in a table can have a DEFAULT value added via the ALTER TABLE statement. Unfortunately, none of the syntax provided gives a way of accomplishing this. An equivalent command from DB2 would be:

ALTER TABLE EMPL ALTER COLUMN BONUS SET DEFAULT 1000;

Is this an error in the documentation, and omission in the product, or is there a different command to accomplish this?

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Satheesh Bandaram made changes - 09/Mar/05 01:21 PM

Field	Original Value	New Value
Component/s		Documentation [ 11406 ]
Component/s	SQL [ 11408 ]

Jeff Levitt made changes - 09/May/05 01:08 PM

Attachment

derby168.diff [ 19954 ]

Jean T. Anderson made changes - 12/May/05 03:18 AM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		10.1.0.0 [ 10993 ]

Jeff Levitt made changes - 07/Jun/05 09:40 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

Rick Hillegas made changes - 17/Oct/05 10:37 PM

Link

This issue is related to ~~DERBY-396~~ [ ~~DERBY-396~~ ]