Documentation bug. Doc says column default can be edited - it looks like it cannot

• Key: DERBY-126
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Unassigned
• Reporter: Bernd Ruehlicke
• Component/s: Documentation
• Fix Version/s: 10.1.1.0

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 [mailto:[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 [mailto:[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-)

Comments

[Bernd Ruehlicke]

Oops - created this as a "Major" priority by accident - sorry.

Of course is this Minor - hope somebody can change this.

B-)

[Jean T. Anderson]

Set component to "Documentation" to keep it on the doc radar.

[Jeff Levitt]

I think I fixed this before I contributed the DITA converted docs. See the current docs:

http://incubator.apache.org/derby/docs/ref/rrefsqlj81859.html

There is no section marked "Modifying columns," and the sentence:
 "You can specify a default value for a new column or add a default value
to an existing column (see Modifying Columns)."

now says:

 "You can specify a default value for a new column."

Can this issue be closed?

[Jeff Levitt]

Looking at this further, there are some strange names for some of these headings that don't appear in the original doc. I think they may have occurred when I converted to DITA, so I will create a patch to fix them. In the meantime, the "Modifying Columns" section DOES exist here, under the label "Messages". Is the information currently in the nightly build version of the docs under the area erroneously labeled "Messages" correct as related to this issue?

[Jeff Levitt]

The attached zip (derby126.zip) fixes the labeling of the sections on the ALTER TABLE page. Please see the included html output. Please provide feedback as to whether it looks good as my patch currently stands, or if there needs to be further changes. Specifically, under "Modifying columns," I wasn't sure whether this issue is asking that the first two bullets be removed? As of now, they are left in.

[Jeff Levitt]

Attached zip includes Satheesh's feedback from:

http://article.gmane.org/gmane.comp.apache.db.derby.devel/5904

Please let me know if this is OK to have committed. Thanks!

[Satheesh Bandaram]

Looks good. Can be committed.

[Jean T. Anderson]

Committed, revision 201501, Jeff Levitt's patch that corrects documentation about column defaults. Changed file:
$ svn status
M src/ref/rrefsqlj81859.dita