Yes, it is definitely a good idea to add the test case to GrantRevokeDDLTest. But I am not sure if we want the test to keep failing on people's machines as well as machines which run the tests periodically.
We can do one of the following 3 things 1)I can enter the test once I find the resolution for it 2)you can go ahead and add the test but comment it out for now. 3)One other possibility is to add the test and catch the incorrect exception for now so the test does not fail and once we have the fix, the test should not runinto exception anymore. thanks, Mamta On Wed, Jul 1, 2009 at 11:41 AM, Lily Wei<[email protected]> wrote: > Hi Mamta: > Not a problem. I have created JIRA 4295 for this case. > I am also trying to add the simple test case to GrantRevokeDDLTest. How do > you run GrantRevokeDDLTest? Is it a good idea to add it in. This is diff I > have so far: > > Thank you so much for helping me look at this too, > Lily > > ________________________________ > From: Mamta Satoor <[email protected]> > To: [email protected] > Sent: Wednesday, July 1, 2009 11:35:15 AM > Subject: Re: Question on inconsistent behavior for grant execute on > procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE > > Hi Lily, > > While you enter a jira, I will try to see if I can figure what is > going on this change in behavior. > > thanks, > Mamta > > On Wed, Jul 1, 2009 at 6:29 AM, Lily Wei<[email protected]> wrote: >> Thank you, Knut. I will file a JIRA issue. >> >> Thanks, >> Lily >> >> ________________________________ >> From: Knut Anders Hatlen <[email protected]> >> To: [email protected] >> Sent: Wednesday, July 1, 2009 1:35:23 AM >> Subject: Re: Question on inconsistent behavior for grant execute on >> procedure SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE >> >> Lily Wei <[email protected]> writes: >> >>> Hi: >>> I need your help on SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE. >>> >>> I am seeing inconsistent behavior for grant execute on procedure >>> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS TABLE between 10.3 and 10.5. >>> >> >> [...] >> >>> ERROR 42507: User 'BACKUP' can not perform the operation in schema >>> 'REFRESH'. >>> <<<====Operation result with ERROR 38000 >>> >>> Is there a way for me to avoid ERROR 38000 on 10.5? >> >> Hi Lily, >> >> It looks like only the owner of the schema (the user who created it) in >> which the table lives is allowed to call >> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE now. I think this is an >> unintended side-effect of DERBY-1062. Please file a JIRA issue. >> >> -- >> Knut Anders >> >> > >
