Percona Toolkit moved to https://jira.percona.com/projects/PT

pt-query-advisor doesn't catch UPDATE/SET bug

Bug #933009 reported by Baron Schwartz
6
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

This query is an error:

UPDATE tbl SET c1=4 AND c2=5 WHERE id = 1

This becomes equivalent to:

UPDATE tbl SET c1=IF(c2=5, 1, 0) WHERE id = 1

Daniel Nichter (daniel-nichter)
tags: added: query-rule
Changed in percona-toolkit:
status: New → Confirmed
Revision history for this message
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/6.

Changed in percona-toolkit:
status: Confirmed → Won't Fix
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-929

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.