db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-4011) ALTER COLUMN is only allowed to change default value of some types of generated columns
Date Sun, 30 Sep 2012 01:52:08 GMT

     [ 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

Mime
View raw message