[ 
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: 10.3.0.0
>            Reporter: Andrew McIntyre
>         Assigned To: Andrew McIntyre
>             Fix For: 10.3.0.0
>
>         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.

Reply via email to