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-1489) Provide ALTER TABLE DROP COLUMN functionality
Date Thu, 21 Sep 2006 21:38:24 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1489?page=comments#action_12436655 ] 
Bryan Pendleton commented on DERBY-1489:

I copied this comment from a different email discussion, involving some
possible interactions between DERBY-655, DERBY-1854, and this bug:

> There are a number of code paths in the server that use the
> "bait/switch" method.  Off the top of my head: some alter table
> modify column paths, maybe drop column, bulk load to an empty table.
> Were these also broken for this problem?  Is the code to do the
> syscat update shared, and thus this fixes all of them?  Probably
> worth adding some test cases.

So, the current overall status of this issu is:
1) Need to write logic to drop GRANTed column permissions when dropping a column
2) Need to add test cases to see if the DERBY-655 regression affects DROP COLUMN

> Provide ALTER TABLE DROP COLUMN functionality
> ---------------------------------------------
>                 Key: DERBY-1489
>                 URL: http://issues.apache.org/jira/browse/DERBY-1489
>             Project: Derby
>          Issue Type: New Feature
>          Components: Documentation, SQL
>    Affects Versions:,,,,,,
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>         Attachments: drop_column_v5_grant_tests.diff, dropColumn_2.diff, dropColumn_v3_view_drop.diff,
> Provide a way to drop a column from an existing table. Possible syntax would be:
> Feature should properly handle columns which are used in constraints, views, triggers,
indexes, etc.

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


View raw message