[ 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
