[rt-devel] Re: [BUG][major] It's now imposible search by two requestors.

[Ruslan U. Zakirov]

Jesse Vincent wrote:

>
>On Thu, Sep 18, 2003 at 06:32:17PM +0400, Ruslan U. Zakirov wrote:
>  
>
>>First attachment is current SELECT(3.0.4 but also checked with delta 
>>#211 with same result)
>>Second is right select that must be generated in case.
>>    
>>
>
>Can you please verify that this is also the case with stock RT 3.0.5?
>
Done. Same result. mySQL(4.0.last) can't finish this query in small time.
____ QUERY____
SELECT count(DISTINCT main.id) FROM Tickets main, Groups Groups_1, 
Principals Principals_2, CachedGroupMembers CachedGroupMembers_3, Users 
Users_4, Groups Groups_5, Principals Principals_6, CachedGroupMembers 
CachedGroupMembers_7, Users Users_8  WHERE ((main.EffectiveId = 
main.id)) AND ((main.Type = 'ticket')) AND ( (  ( (Users_4.EmailAddress 
LIKE '%test%')AND(Groups_1.Domain = 'RT::Ticket-Role')AND(Groups_1.Type 
= 'Requestor')AND(Principals_2.PrincipalType = 'Group') ) OR ( 
(Users_8.EmailAddress LIKE '%cubic%')AND(Groups_5.Domain = 
'RT::Ticket-Role')AND(Groups_5.Type = 
'Requestor')AND(Principals_6.PrincipalType = 'Group') )  ) AND ( 
(main.Status = 'resolved') ) )  AND Groups_1.Instance = main.id  AND 
Groups_1.id = Principals_2.ObjectId  AND Principals_2.id = 
CachedGroupMembers_3.GroupId
AND CachedGroupMembers_3.MemberId = Users_4.id  AND Groups_5.Instance = 
main.id  AND Groups_5.id = Principals_6.ObjectId  AND Principals_6.id = 
CachedGroupMembers_7.GroupId  AND CachedGroupMembers_7.MemberId = Users_8.id
_____/QUERY____
Sorry, but I track all your changes and there was only one delta 
according to issue and no more. I just don't have time to finish with 
repositories, when I do this I'll be send reports for current unstable 
versions.

>
>Also, in the future, please do NOT send messages To: both rt-devel and
>rt-bugs.  If you're going to do  that, please either send to rt-bugs
>first and get a ticket number to include in the rt-devel posting OR bcc
>rt-bugs.   When you send mail to both, it ends up with every single
>reply creating a new ticket.
>
Understood. Sorry for that. I've got into passion. Last time I've got 
many complaints from our users about RT and in some cases I know that 
they are right, but can't do anything with it. E.g. they don't want that 
someone could create ticket through WebUI without all custom fields 
filled in... and other... and other... they always complaint... I get 
tired... :)

I hate users they are capricious :) Like me for you... :)