[rt-devel] 3.0.10 Group Members "crash"

[Scott A. McIntyre]

--On Sunday, April 04, 2004 12:05 -0400 Jesse Vincent 
<jesse at bestpractical.com> wrote:

> Can you send us the output of
>
> EXPLAIN SELECT DISTINCT main.* FROM Users main, Principals
> Principals_1, CachedGroupMembers CachedGroupMembers_2  WHERE
>  ((CachedGroupMembers_2.GroupId = '4')) AND ((Principals_1.Disabled =
> '0'))       AND ((Principals_1.PrincipalType = 'User')) AND
> ((Principals_1.id =             CachedGroupMembers_2.MemberId)) AND
> ((main.id = Principals_1.id)or(main.id       != '1')or(main.id != '10'))
> ORDER BY main.Name ASC


Yeppers:

mysql> EXPLAIN SELECT DISTINCT main.* FROM Users main, Principals
    -> Principals_1, CachedGroupMembers CachedGroupMembers_2  WHERE 

    -> ((CachedGroupMembers_2.GroupId = '4')) AND ((Principals_1.Disabled = 
'0'))
    -> AND ((Principals_1.PrincipalType = 'User')) AND ((Principals_1.id = 
CachedGroupMembers_2.MemberId)) AND ((main.id = Principals_1.id)or(main.id 

    -> != '1')or(main.id != '10')) ORDER BY main.Name ASC;
+----------------------+--------+--------------------+------------+--------
-+-------------------------------+-------+---------------------------------
--------------------------+
| table                | type   | possible_keys      | key        | key_len 
| ref                           | rows  | Extra 
|
+----------------------+--------+--------------------+------------+--------
-+-------------------------------+-------+---------------------------------
--------------------------+
| CachedGroupMembers_2 | ref    | DisGrouMem,GrouMem | DisGrouMem |       5 
| const                         |   260 | Using where; Using index; Using 
temporary; Using filesort |
| Principals_1         | eq_ref | PRIMARY            | PRIMARY    |       4 
| CachedGroupMembers_2.MemberId |     1 | Using where 
|
| main                 | ALL    | PRIMARY,Users3     | NULL       |    NULL 
| NULL                          | 99274 | Using where 
|
+----------------------+--------+--------------------+------------+--------
-+-------------------------------+-------+---------------------------------
--------------------------+
3 rows in set (0.01 sec)