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

  1. Bug #1201660
  2. Comment #2

Comment 2 for bug 1201660

Revision history for this message
monty solomon (monty+launchpad) wrote :

The tool adds NO_AUTO_VALUE_ON_ZERO to the existing sql mode

# DSNParser:1612 29063 DBI::db=HASH(0x2a9d4f0) SELECT @@SQL_MODE
# DSNParser:1643 29063 DBI::db=HASH(0x2a9d4f0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/
# DSNParser:1612 29063 DBI::db=HASH(0x2aa2450) SELECT @@SQL_MODE
# DSNParser:1643 29063 DBI::db=HASH(0x2aa2450) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/
# DSNParser:1612 29063 DBI::db=HASH(0x2aaa2a0) SELECT @@SQL_MODE
# DSNParser:1643 29063 DBI::db=HASH(0x2aaa2a0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/