db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1521) Upgrade test needs to be enhanced to test grant revoke
Date Thu, 31 Aug 2006 00:08:23 GMT
    [ 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:
>            Reporter: Mamta A. Satoor
>         Assigned To: Deepa Remesh
>             Fix For:
>         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

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


View raw message