Hello,
--Am 18. November 2007 22:17:42 +0300 schrieb Ruslan Zakirov
<[EMAIL PROTECTED]>:
Script creates schema and data. The following query must use range
search for the second table instead of 'ref'.
so this is from our site:
"
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 897
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> explain SELECT STRAIGHT_JOIN g.id FROM acl a, grp g WHERE
-> g.type = a.type
-> AND (
-> ( g.domain = 'RT::Ticket-Role' AND g.instance = 10 )
-> OR ( g.domain = 'RT::Queue-Role' AND g.instance = 3 )
-> OR ( g.domain = 'RT::System-Role' AND g.instance = 1 )
-> );
+----+-------------+-------+-------+---------------+------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref
| rows | Extra |
+----+-------------+-------+-------+---------------+------+---------+------+------+-------------+
| 1 | SIMPLE | a | ALL | NULL | NULL | NULL | NULL
| 2 | |
| 1 | SIMPLE | g | range | grp1,grp2 | grp2 | 40 | NULL
| 6 | Using where |
+----+-------------+-------+-------+---------------+------+---------+------+------+-------------+
2 rows in set (0.00 sec)
mysql>
"
As far as I understood this meens that "Server version:
5.0.32-Debian_7etch1-log Debian etch distribution" is ok, isn't it?
Regards, Dirk.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
