[jira] Updated: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value
[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ] Bryan Pendleton updated DERBY-1491: --- Attachment: alterDefaultTests.diff Proposed patch "alterDefaultTests.diff" is attached. This patch proposal supercedes the previous attachments. Note that this patch only includes new tests; the current product already supports the functionality to change a column's default value. The code to support this was a side effect of the DERBY-119 changes, which wired up the already-existing parser routines to the new ALTER TABLE t ALTER COLUMN c statement. > 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.1.3.1, 10.1.3.0, 10.1.2.1, 10.1.1.0, 10.0.2.1, > 10.0.2.0, 10.2.1.0 >Reporter: Bryan Pendleton > Assigned To: Bryan Pendleton > Attachments: alterColumnDefault1.diff, alterDefaultTests.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
[jira] Updated: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value
[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ] Bryan Pendleton updated DERBY-1491: --- Derby Info: (was: [Patch Available]) Cleared patch available; I need to revise the patch to incorporate the suggestions from reviewers. > 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
[jira] Updated: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value
[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ] Bryan Pendleton updated DERBY-1491: --- Derby Info: [Patch Available] > 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
[jira] Updated: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value
[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ] Bryan Pendleton updated DERBY-1491: --- Attachment: alterColumnDefault1.diff Attached is alterColumnDefault1.diff. This diff merges the db2AlterColumn() and columnAlterClause() parsing routines in sqlgrammar.jj. Although this is a more complicated diff to the parser than the first patch, I think it is preferable because this way all the column alterations come through ALTER TABLE ALTER COLUMN, rather than trying to have both ALTER COLUMN and MODIFY COLUMN. > 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
[jira] Updated: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value
[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ] Bryan Pendleton updated DERBY-1491: --- Attachment: modifyDefault_1.diff Attached is modifyDefault_1.diff, a patch proposal to support the statement ALTER TABLE tablename MODIFY COLUMN columnname DEFAULT defaultvalue; The keyword COLUMN is optional. There aren't very many tests in this patch yet; I intend to write more tests. > 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 > Type: New Feature > Components: Documentation, SQL > 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 > Assignee: Bryan Pendleton > Attachments: 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