[ http://issues.apache.org/jira/browse/DERBY-1521?page=all ]
Deepa Remesh updated DERBY-1521:
--------------------------------
Attachment: d1521-patch1-v1.diff
d1521-patch1-v1.status
Attaching a patch 'd1521-patch1-v1.diff' which modifies UpgradeTester to test
the grant/revoke feature. This is a preliminary patch which tests the default
upgrade behaviour: In upgrades from versions earlier than 10.2,
* grant/revoke feature is not available in soft upgrade
* grant/revoke feature is not available in full upgrade (by default). This
feature will be available after full upgrade only if
"derby.database.sqlAuthorization" is true.
The patch adds a method to UpgradeTester to test grant/revoke feature. This
method currently checks that grant/revoke feature is not supported by issuing a
grant command. I think we need to add more checks to this method.
With this patch, I ran the upgrade test with sane classes and jars. This patch
modifies only upgrade test. Please review/commit this patch if okay.
As I mentioned before, this is a preliminary patch. More changes planned in
subsequent patch(es):
* Test upgrade with derby.database.sqlAuthorization set
* Add more checks to see grant/revoke feature not supported.
- grant/revoke not available on existing databases if
derby.database.sqlAuthorization was not set to true during upgrade.
* Add basic tests to test grant/revoke feature works when upgraded with
derby.database.sqlAuthorization set to true
- grant/revoke works on the upgraded database
- owner of system schemas is changed from pseudo user 'DBA' to the
authorizationID of the user invoking upgrade
- check contents of new system tables related to grant/revoke
- check that all tables and views will be owned by the database owner after
upgrade.
- check if it is better to add few basic tests to UpgradeTester or cover the
testing by calling an existing grant/revoke test
Do we need to cover anything else in the testing?
> Upgrade test needs to be enhanced to test grant revoke
> ------------------------------------------------------
>
> Key: DERBY-1521
> URL: http://issues.apache.org/jira/browse/DERBY-1521
> Project: Derby
> Issue Type: Improvement
> Components: Test
> Affects Versions: 10.2.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Deepa Remesh
> Fix For: 10.2.0.0
>
> Attachments: d1521-patch1-v1.diff, d1521-patch1-v1.status
>
>
> Grant Revoke is one of the features targeted for 10.2 Release. The upgrade
> test should be modified to test this feature with various upgrade scenarios
> to make sure everything works fine.
--
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
