Hi Jeff,
I looked at DERBY-126 document patch. I think this needs the following
corrections:
Under Setting Defaults section, this paragraph can be removed.
This should be covered under modifying columns.
You can set the interval between consecutive values of the
identity column to an existing column in a table. If there are existing
rows in the table, the values in the column for which the SET INCREMENT
default was added do not change. Note that this means that values in
the column are not guaranteed to be unique (use a unique or primary key
constraint to guarantee uniqueness).
Under Modifying columns, the following needs to change: (Note
the change in bulletting)
- Specifying the interval between consecutive values of the
identity column.
- To set an interval between consecutive values of the identity
column, specify the integer-constant.
- You must previously define the column with the IDENTITY attribute
(SQLSTATE 42837).
To:
- Specifying the interval between consecutive values of the
identity column.
To set an interval between consecutive values of the
identity column, specify the integer-constant.
You must previously define the column with the IDENTITY attribute
(SQLSTATE 42837).
If there are existing rows in the table, the values in the column for
which the SET INCREMENT default was added do not change.
Let me know if this is not clear,
Satheesh
Jeff Levitt wrote:
Hi,
126 - Doc says column default can be edited - it looks
like it cannot
http://issues.apache.org/jira/browse/DERBY-126
|
