[ http://issues.apache.org/jira/browse/DERBY-1521?page=comments#action_12431750 ] Deepa Remesh commented on DERBY-1521: -------------------------------------
Current state of this issue - after upgrade, we test basic grant/revoke works and system tables are updated correctly. As mentioned earlier, it would be good to run the grant/revoke tests on the upgraded database. I tried running both the grant/revoke tests from the upgrade test but did not have much success. * In case of lang/grantRevokeDDL.sql, the script cannot be run directly as it has connect statements which refer to the database name directly. * In case of grantRevoke.java, I modified the upgrade test to use the same user (who is the database owner in grantRevoke test) to perform the upgrade. Also modified the "doIt" method in grantRevoke test to take in a connection. So the upgrade test can call this method and pass in a connection to the upgraded database. This works okay and the setup part of the test runs fine. But I am not able to get new connection as other users from the test. Any suggestions or other options to make these tests run from the upgrade test ? I think the same solution can also be used for DERBY-1522 test. I would appreciate any help about how to proceed with this. > 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.1.0 > Reporter: Mamta A. Satoor > Assigned To: Deepa Remesh > Fix For: 10.2.1.0 > > Attachments: d1521-patch1-v1.diff, d1521-patch1-v1.status, > d1521-patch2-draft.diff, d1521-patch2-v1.diff, d1521-patch2-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
