pt-query-advisor gives false, inconsistent warnings.
Command: pt-query-advisor /tmp/sample4pt-
Tools version: 2.1.9-1
MySQL version: 5.5.12
# Query ID NOTE WARN CRIT Item
# ================== ==== ==== ==== =======
# 0xD6277F8BD92F2849 1 1 0 select this_.booking_id as booking?_?_?_, ... from consultant this_ left outer join consultant consultant?_ on this_.default_
RES.002 is incorrectly reported for the last one out of three queries in attached sample file. Actually none of these queries has LIMIT clause, although word "limit" is a part of some column names.
Furthermore, testing with six subset files containing:
- single query per file
- two queries per file (1+2, 1+3, 2+3)
- NO warnings from single query files
- RES.002 from 1+2 file
- CLA.001 from 1+3 and 2+3 files
CLA.001 warnings are correct as the third query does not have WHERE clause.
|Changed in percona-toolkit:|
|status:||New → Triaged|