[rt-users] Bug (Showstopper?) in 3.0.11rc2?

Ruslan U. Zakirov cubic at acronis.ru
Sun May 23 20:41:30 EDT 2004


Jesse Vincent wrote:
> On Fri, May 21, 2004 at 02:50:07PM +0200, Dirk Pape wrote:
> 
>>>I catched the sql query out of the log (reformatted and attached!), which
>>>if  executed manually does not reveil the expected users either.
>>
>>On the first view, I find the SQL-Statement to be buggy. It should at least 
>>be
>>
>>     OR (((main.Domain = 'RT::Queue-Role' AND main.Instance = 9)
>>            OR (main.Domain = 'RT::Ticket-Role' AND main.Instance = 8317))
>>        AND main.Type = ACL_1.PrincipalType) )
>>
>>instead of
>>
>>     OR (((main.Domain = 'RT::Queue-Role' AND main.Instance = 9)
>>            OR (main.Domain = 'RT::Ticket-Role' AND main.Instance = 8317))
>>        AND main.Type = ACL_1.PrincipalType
>>        AND main.id = ACL_1.PrincipalId) )
>>
>>to match a Queue-defined AdminCC group to the globally defined AdminCC 
>>rights, which is the sitiation missed in my case.
> 
> 
> That is 100% correct. My testing confirmed this. I've just built new
> tests into RT to make sure this doesn't happen again and altered the
> query to behave apropriately. Regression tests are running now.
After playing around this I end up with attached patch.

> 
> 
> 
>>I do not know yet if the generated SQL statement is due to one of my 
>>extensions or due to vanilla rt 3.0.11 code, but I think the latter is the 
>>case, so this should be a real bug.
>>
>>Ruslan, can you verify If you have granted "OwnTicket" right to AdminCC on 
>>queue or on global level, in the case where you found, that it turned out 
>>to be alright for you?
>>
>>Dirk.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: global_rigths_delegation.patch
Type: application/aegis-patch
Size: 1360 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040524/1dfb7196/attachment.bin>


More information about the rt-users mailing list