Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #933009: pt-query-advisor doesn't catch UPDATE/SET bug

Description

**Reported in Launchpad by Baron Schwartz last update 13-03-2013 15:08:47

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

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 6:19 PM

**Comment from Launchpad by: Daniel Nichter on: 13-03-2013 15:08:40

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.

Won't Do

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 6:18 PM
Updated February 3, 2018 at 11:44 PM
Resolved January 24, 2018 at 6:18 PM