db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value
Date Mon, 31 Jul 2006 21:06:16 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1491?page=comments#action_12424658 ] 
            
Bryan Pendleton commented on DERBY-1491:
----------------------------------------

Note to reviewers: I believe that the only changes needed for this new feature are parser
changes and tests. I believe that the existing execution code in AlterTableConstantAction.java
is fine as is. When I apply the patch in my environment, the feature seems to be working fine.

The two patches attached to this issue provide two alternate syntax possibilities. My current
feeling is that the ALTER TABLE ALTER COLUMN syntax is preferable.

Lastly, note that this patch is identical in its changes to sqlgrammar.jj as is the patch
attached to DERBY-119. The only difference in the two patches is in the test code. This patch
contains tests of changing a column's default value. The DERBY-119 patch contains tests of
changing a column's NULL constraint.



> Provide ALTER TABLE functionality to change a column's default value
> --------------------------------------------------------------------
>
>                 Key: DERBY-1491
>                 URL: http://issues.apache.org/jira/browse/DERBY-1491
>             Project: Derby
>          Issue Type: New Feature
>          Components: Documentation, SQL
>    Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.0.0, 10.1.2.1, 10.1.3.0, 10.1.3.1
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>         Attachments: alterColumnDefault1.diff, modifyDefault_1.diff
>
>
> Provide a way to alter the default value for an existing column in an existing table.
The syntax should probably some variant of the ALTER TABLE statement.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message