[jira] [Closed] (DERBY-6293) Alter Table->Add Default Value to already created column

["Anilkumar Kalshetti (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anilkumar Kalshetti closed DERBY-6293.
--------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.11.0.0
    
> Alter Table->Add Default Value to already created column
> --------------------------------------------------------
>
>                 Key: DERBY-6293
>                 URL: https://issues.apache.org/jira/browse/DERBY-6293
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.10.1.1
>         Environment: Windows 7, 32bit
>            Reporter: Anilkumar Kalshetti
>            Priority: Minor
>             Fix For: 10.11.0.0
>
>
> Refer:        Derby Reference Manual Version 10.10
>                  Page Number: 26, Second Last Line
> Sentence:  [ Derby also raises an error if you try to add a DEFAULT clause to a generated column.]
> Steps to reproduce:
> 1a. Create table t1 with column c1    , datatype: INTEGER
> Note:(NULL allowed)
> CREATE TABLE "APP"."t1"  ( 
> 	"c1"	INTEGER 
> 	)
> 1b. Alter table, for c1   , give Default value: 9
> ALTER TABLE "APP"."t1"
> 	ALTER "c1" DEFAULT 9
> GO
> -------------------------------------------------------------------
> 2a.
> CREATE TABLE "APP"."t2"  ( 
> 	"c1"	INTEGER NOT NULL 
> 	)
> 2b.
> ALTER TABLE "APP"."t2"
> 	ALTER "c1" DEFAULT 2
> GO
> Issue is that according to document we cannot add default value to already created column, but here it gets added.

--
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