Can't ALTER a column to have a new DEFAULT value.
-------------------------------------------------
Key: DERBY-168
URL: http://issues.apache.org/jira/browse/DERBY-168
Project: Derby
Type: Bug
Components: SQL
Versions: 10.0.2.0
Environment: Windows XP SP1 Professional
Reporter: George Baklarz
Priority: Minor
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?
--
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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
