[
https://issues.apache.org/jira/browse/DERBY-4011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-4011:
-----------------------------------
Urgency: Normal
Labels: derby_triage10_10 (was: )
> 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.1.1
> Reporter: Knut Anders Hatlen
> Priority: Minor
> Labels: derby_triage10_10
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
