← Back to branch summary

~percona-toolkit-dev/percona-toolkit/mysql-5.6-test-fixes

« back to all changes in this revision

Viewing changes to t/pt-visual-explain/samples/film_range_on_pk.sql

  • Committer: Daniel Nichter
  • Date: 2011-06-24 22:02:05 UTC
  • Revision ID: daniel@percona.com-20110624220205-e779cao9hcwyly1w
Add forked Maatkit tools in bin/ and their tests in t/.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/pt-visual-explain/samples/film_range_on_pk.sql
 
1
mysql> explain select * from sakila.film where film_id between 1 and 20;
 
2
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
 
3
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | Extra       |
 
4
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
 
5
|  1 | SIMPLE      | film  | range | PRIMARY       | PRIMARY | 2       | NULL |   20 | Using where | 
 
6
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
 
7
1 row in set (0.00 sec)
 
8
 
 
9
mysql> notee