[ 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
