db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew McIntyre (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2410) Convert grantRevoke.java to JUnit
Date Fri, 09 Mar 2007 09:13:24 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Andrew McIntyre updated DERBY-2410:

    Attachment: derby-2410-pre3.diff

Attaching third draft for converting this test. Insert and update privileges now have proper
assert methods. DatabaseMetaData.getColumns() was failing if the schema / table names were
not uppercased, even though they were not quoted. I will follow up at a later date to see
if this is or is not expected behavior.

Current issues:

- assertTriggerPrivilege fails in some tests with complaints that the trigger already exists.
This is either a failure by assertTriggerPrivilege to drop a trigger once created, or a bug.
Probably the former.

- Attempted to have the rollback tests execute their grant statements explicitly on a connection
owned by the database owner. This led to lock timeouts, however, so I've reverted to the previous
method which simply executes the statements on the default connection via runSQLCommands()
for now.

remaining todo items:

- move testcases over from grantrevokeDDL / grantrevokeDDL2
- implement checks on privilege metadata in system catalogs
- test DatabaseMetaData methods getColumnPrivileges / getTablePrivileges
- variants of assertXXXPrivileges that takes an array of users to assert public privileges
- assertReferencesPrivilege implementation
- review grantrevoke tests this test replaces to verify all expected functionality is represented
- followup on DatabaseMetaData.getColumns() issue

> Convert grantRevoke.java to JUnit
> ---------------------------------
>                 Key: DERBY-2410
>                 URL: https://issues.apache.org/jira/browse/DERBY-2410
>             Project: Derby
>          Issue Type: Improvement
>          Components: Test
>    Affects Versions:
>            Reporter: Andrew McIntyre
>         Assigned To: Andrew McIntyre
>             Fix For:
>         Attachments: derby-2410-pre.diff, derby-2410-pre2.diff, derby-2410-pre3.diff
> Convert grantRevoke.java to JUnit. Also add test cases from grantRevokeDDL and grantRevokeDDL2
SQL tests to the new GrantRevokeTest

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message