db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren" <m.v.lunte...@gmail.com>
Subject Re: Looking for good test suite to test Grant & Revoke functionality ...
Date Sat, 25 Mar 2006 15:05:19 GMT
On 3/24/06, Satheesh Bandaram <satheesh@sourcery.org> 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:
>
>    1. 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.


>    1. Import a suitable test in open source world with compatible
>    license. Any ideas here?
>    2. Write one from scratch. Might take reasonable amount of time.
>
> Thanks for any suggestions,
>
>
> Satheesh
>

Mime
View raw message