[ 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
