← Back to branch summary

~percona-toolkit-dev/percona-toolkit/pt-table-sync-binlog-format-only-if-not-statement

« back to all changes in this revision

Viewing changes to t/pt-query-advisor/samples/cla-006-01.txt

  • Committer: Daniel Nichter
  • Date: 2012-06-01 15:13:11 UTC
  • mfrom: (171.3.3 json)
  • Revision ID: daniel@percona.com-20120601151311-ro2aopjdb9tnj1wv
Merge advisor-json-output and clean up pt-query-advisor docs.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/pt-query-advisor/samples/cla-006-01.txt
1
1
 
2
2
# Query ID 0xAED2E885BDADA166 at byte 0
3
3
# WARN CLA.001 SELECT without WHERE.
4
 
# WARN CLA.006 GROUP BY or ORDER BY different tables will force a temp table and filesort.
 
4
# WARN CLA.006 GROUP BY or ORDER BY on different tables.
5
5
select id from tbl1 join tbl2 using (a) group by tbl1.id, tbl2.id
6
6
 
7
7
# Profile