ALTER COLUMN is only allowed to change default value of some types of generated
columns
---------------------------------------------------------------------------------------
Key: DERBY-4011
URL: https://issues.apache.org/jira/browse/DERBY-4011
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Versions: 10.5.0.0
Reporter: Knut Anders Hatlen
Priority: Minor
ALTER TABLE ... ALTER COLUMN is allowed to change the default of columns that
are GENERATED ALWAYS AS IDENTITY, but it's not allowed to change the default of
columns that are GENERATED ALWAYS AS (expression). It would be good if it had
the same behaviour for all generated columns.
ij> create table t1(x int generated always as (-1));
0 rows inserted/updated/deleted
ij> alter table t1 alter column x default 22;
ERROR 42XA7: 'X' is a generated column. You cannot change its default value.
ij> create table t2(x int generated always as identity);
0 rows inserted/updated/deleted
ij> alter table t2 alter column x default 22;
0 rows inserted/updated/deleted
ij> insert into t2 values default;
1 row inserted/updated/deleted
ij> select * from t2;
X
-----------
22
1 row selected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
