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
- 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)
Revision history for this message
| Baron Schwartz (baron-xaprb) wrote | #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 |
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #2 |
| Changed in percona-toolkit: | |
| status: | In Progress → Won't Fix |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
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