SUB.001, LIT.001 and LIT.002 are sensitive to program state
Bug #929046 reported by
Baron Schwartz
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
Medium
|
Brian Fraser |
Bug Description
This query:
select * from t where id in (select id from t where col = 2010-20-12)
Only triggers these rules:
COL.001 LIT.002
It should also trigger SUB.001.
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-929046-pt-qa-sub.001-lit.001-lit.002-fix
On hold
for merging
into
lp:percona-toolkit/2.1
- Daniel Nichter: Pending requested
- Brian Fraser: Pending requested
-
Diff: 143 lines (+43/-18)3 files modifiedbin/pt-query-advisor (+9/-9)
lib/QueryAdvisorRules.pm (+17/-8)
t/lib/QueryAdvisorRules.t (+17/-1)
tags: | added: query-rule |
summary: |
- pt-query-advisor only finds 2 out of 3 problems + SUB.001, LIT.001 and LIT.002 are sensitive to program state |
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
status: | Confirmed → In Progress |
milestone: | none → 2.1.8 |
Changed in percona-toolkit: | |
milestone: | 2.1.8 → none |
To post a comment you must log in.
I had to try several combinations to get all rules to trigger. This works:
select * from t where col > 2010-12-02 and id in (select id from t)
But this doesn't:
select * from t where id in (select id from t) and col > 2010-12-02