[rt-devel] Slow Queries part3, Groups

[Jesse Vincent]

> I talk not about perfomance issues. I talk about query itself. It's 
> wrong and only one particular feature save RT from logic breakage of 
> results from this select. This feature is that that each row in 
> Principals table have ObjectId == id.
> Groups.id (in our select main.id) referenced not by Principals.id, but 
> by Principals.ObjectId.


Principals.ObjectId is defined to always be Principals.Id. ALWAYS. The
fact that there's an ObjectId is actually a slight historical accident.
Really, we should be moving to always use .id instead of .ObjectId


-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.