On 3/24/06, Satheesh Bandaram <[EMAIL PROTECTED]> wrote:
As I am wrapping up Grant & Revoke functionality being tracked under DERBY-464 (except for views, triggers and constraints part), I am looking for good way to test new functionality. While I have added two new tests, grantRevokeDDL.sql and grantRevoke.java, I am looking to expand test coverage to try some real schemas and usages. Some ideas are:
- Try converting existings tests to new SQL authorization mode. nist suite seems like a good candidate. It already enables authentication and has authorization statements under comments. I will have to change nist suite to grant required object privileges and adjust test suite to work-around extra restrictions current implementation has. I have already tried running nist under SQL authorization and initial run caused about 40 test failures out of 126 tests. After changing tests a little, I have brought down failures to about 20 tests. I will need to further change tests to add grant statements to get the test to pass.
Just note, any changes to the nist suite need to be recorded. See/in <trunk>/java/testing/org/apache/derbyTesting/functionTests/tests/nist/readme.
Thanks for any suggestions,
- Import a suitable test in open source world with compatible license. Any ideas here?
- Write one from scratch. Might take reasonable amount of time.
Satheesh
