Hi Satheesh,
I've attached some code to DERBY-464 that may be useful as the basis of
a grant/revoke test. It comes from the Sun HADB test suite. If you
decide to use it, let me know if you need any of the classes it depends
on.
-- Michelle
Satheesh Bandaram 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.
- Import a suitable test in open source world with compatible
license. Any ideas here?
- Write one from scratch. Might take reasonable amount of time.
Thanks for any suggestions,
Satheesh
|
- Re: Looking for good test suite to test Grant & Revo... Michelle Caisse
-
