Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-357

LP #1182856: Zero values causes "Invalid --set-vars value: var=0"

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Przemek last update 18-07-2013 15:37:35

      When trying to assign 0 to any variable using --set-vars option, getting "Invalid --set-vars value" message, even before the tool tries to connect to MySQL and apply the value.

      How to reproduce:

      pt-online-schema-change D=test,t=table --alter "engine=innodb" --set-vars="SQL_LOG_BIN=0" --dry-run
      Invalid --set-vars value: SQL_LOG_BIN=0

      The same using SQL_LOG_BIN=OFF or using any other value then 0 works.

      I've tested on versions 2.2.1 and 2.2.2.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: