Documentation bug. Doc sais column default can be edited - it looks like it
cannot
----------------------------------------------------------------------------------
Key: DERBY-126
URL: http://issues.apache.org/jira/browse/DERBY-126
Project: Derby
Type: Bug
Reporter: Bernd Ruehlicke
>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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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-)
--
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
