SUB.001, LIT.001 and LIT.002 are sensitive to program state

Reported by Baron Schwartz on 2012-02-08
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit
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.

Baron Schwartz (baron-xaprb) wrote :

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

tags: added: query-rule
Brian Fraser (fraserbn) on 2012-12-03
summary: - pt-query-advisor only finds 2 out of 3 problems
+ SUB.001, LIT.001 and LIT.002 are sensitive to program state
Brian Fraser (fraserbn) on 2012-12-03
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
Daniel Nichter (daniel-nichter) wrote :

We have decided to remove pt-query-advisor in 2.2. This issue has moved to https://github.com/percona/query-advisor/issues/22

Changed in percona-toolkit:
status: In Progress → Won't Fix
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers