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] Updated: (DERBY-1489) Provide ALTER TABLE DROP COLUMN functionality
Date Tue, 26 Sep 2006 14:19:53 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1489?page=all ]

Bryan Pendleton updated DERBY-1489:
-----------------------------------

    Attachment: drop_column_v6_grant_not_implemented.diff

Attached is drop_column_v6_grant_not_implemented.diff, a patch proposal
which I believe is ready for review and possibly for commit (depending on
what turns up during review).

This patch causes ALTER TABLE DROP COLUMN to throw a NOT
IMPLEMENTED error if sqlAuthorization is true. Because of this, all of
the DROP COLUMN tests are shifted to a new test script, rather than being
placed in altertable.sql, which runs with sqlAuthorization. If we adopt this
patch proposal, I'll file a new JIRA to track the issue of getting DROP COLUMN
to work under sqlAuthorization, and I'll update the test scripts to indicate that
the separate test script is temporary, and should be consolidated once that
problem is fixed.

Except for this change in the testing mechanics and the new NOT IMPLEMENTED
check in the grammar, this patch proposal is the same as the previous few
attached patches. derbyall passes with this patch proposal.

Please have a look and tell me what you think.

> 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: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.1.5, 10.1.2.1, 10.1.3.0, 10.1.3.1
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>         Attachments: drop_column_v5_grant_tests.diff, drop_column_v6_grant_not_implemented.diff,
dropColumn_2.diff, dropColumn_v3_view_drop.diff, dropColumn_v4_grant_tests.diff
>
>
> Provide a way to drop a column from an existing table. Possible syntax would be:
>   ALTER TABLE tablename DROP COLUMN columnname CASCADE / RESTRICT;
> 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

        

Mime
View raw message