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 Mon, 25 Sep 2006 22:38:53 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1489?page=comments#action_12437684 ] 
            
Bryan Pendleton commented on DERBY-1489:
----------------------------------------

Dan suggested perhaps throwing a NOT_IMPLEMENTED exception if the user
tries to issue ALTER TABLE DROP COLUMN in sqlAuthorization mode.

This seems pretty straightforward to do.

One issue, though, is with testing. Currently, the entire altertable.sql test runs
in sqlAuthorization mode. Therefore, it's hard to see how to provide some
tests of DROP COLUMN which run when sqlAuthorization mode is off, and
some other tests of DROP COLUMN which run when sqlAuthorization mode
is on.

Any suggestions as to how to provide reasonable tests in this situation? Should we:
 - put just a single DROP COLUMN test in altertable.sql, verifying that DROP COLUMN
   is rejected in sqlAuthorization mode
 - and then add a new test case, lang/altertableDropColumn.sql, to hold the
   tests that verify the proper operation of DROP COLUMN when sqlAuthorization
   is off?


> 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, 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