[DERBY-126] Documentation bug. Doc says column default can be edited - it looks like it cannot

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.1.1.0
• Component/s: Documentation
• Assignee: Unassigned
• Reporter: Bernd Ruehlicke
• Created: 19/Jan/05 05:58
• Updated: 24/Jun/05 06:43
• Resolved: 24/Jun/05 06:43

Description

From the e-mail trail on the Derby Mailing list

I think that part of the documentation needs to be changed... Unless someone actually shows Derby can support modifying default values or add a default to an existing column, either myself or you should file a JIRA documentation bug to fix the documentation.

Under the modifying columns, the document says two options are available....1) Increase a VARCHAR length 2) specify an interval between identity columns.

Satheesh

Bernd Ruehlicke wrote:

Thanx - the intresting bit here is that the documentation under "Setting
defaults" on
http://incubator.apache.org/derby/manuals/reference/sqlj26.html#HDRSII-S
QLJ-21322 sais

"You can specify a default value for a new column or add a default value
to an existing column (see Modifying Columns)."

i.e. "... or add a default value to an existing column"

That's what I am looking for.

B-)

----Original Message----
From: Satheesh Bandaram [e-mail]
Sent: Tuesday, January 18, 2005 1:32 PM
To: Derby Discussion
Subject: Re: Add a default to an existing column ?

I am not aware of a way to modify a default value in Derby.
You can add a default at the table creation time, but not
sure if you can add a default to an existing column.

Satheesh

Bernd Ruehlicke wrote:

Hmm - scary silence followed this e-mail.

To clarify the mail.

I want to be able to modify a default value for a column.

Anybody know what is supported in Derby and what isn't ?

B-)

----Original Message----
From: Bernd Ruehlicke [e-mail]
Sent: Monday, January 17, 2005 1:12 PM
To: Derby Discussion
Subject: Add a default to an existing column ?

Hmm - the documentation states that you can add
a default
value to an existing column in

http://incubator.apache.org/derby/manuals/reference/sqlj26.htm
l#HDRSII-SQLJ-21322 but I cannot find any
syntax which works for me.

Questions:

1) What is the syntax if I want to add a
default value to a column ?

2) What is the syntax if I want to modify a
default value of
a colum ? (Is this possible at all ?)

Thanx
B-)