pt-query-advisor doesn't warn about FOR UPDATE

Reported by Baron Schwartz on 2012-02-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

Bug Description

SELECT c FROM t where 1 = 1 FOR UPDATE

That should trigger a rule warning about the dangers of FOR UPDATE. The same for LOCK IN SHARE MODE.

summary: - pt-query-advisor doesnt' detect FOR UPDATE
+ pt-query-advisor doesn't warn about FOR UPDATE
Changed in percona-toolkit:
status: New → Confirmed
tags: added: query-rule
Daniel Nichter (daniel-nichter) wrote :

pt-query-advisor was removed in 2.2. Use pt-query-advisor 2.1 or the online tool: https://tools.percona.com/query-advisor.

This issue has been moved to https://github.com/percona/query-advisor/issues/5.

Changed in percona-toolkit:
status: Confirmed → 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