~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-007-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:
1
1
 
2
2
# Query ID 0xBA2547D924C5140D at byte 0
3
 
# WARN CLA.007 ORDER BY different directions prevents index from being used.
 
3
# WARN CLA.007 ORDER BY clauses that sort the results in different directions prevents indexes from being used.
4
4
select c1, c2 from t where i=1 order by c1 desc, c2 asc
5
5
 
6
6
# Profile