pt-query-advisor doesn't warn about FOR UPDATE
Bug #932992 reported by
Baron Schwartz
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
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 |
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #1 |
| Changed in percona-toolkit: | |
| status: | Confirmed → Won't Fix |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
pt-query-advisor was removed in 2.2. Use pt-query-advisor 2.1 or the online tool: https:/
This issue has been moved to https:/