Bug #78132 MySQL Utilities breaks when sql_mode="ANSI_QUOTES"
Submitted: 18 Aug 2015 19:28 Modified: 12 Feb 2016 2:49
Reporter: Jim Parks Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Utilities Severity:S1 (Critical)
Version:1.5.2 OS:Any
Assigned to: CPU Architecture:Any

[18 Aug 2015 19:28] Jim Parks 
Description:
MySQL Utilities fail to run when sql_mode includes "ANSI_QUOTES"

How to repeat:
Set sql_mode="ANSI_QUOTES"
Run something like this:

mysqlrpladmin --master=xyz:pass@10.0.0.1:3306 --slaves=xyz:pass@10.0.0.2:3306 --new-master=xyz:pass@10.0.0.2:3306 --rpl-user=xyz:pass --demote-master switchover --force -v
WARNING: Using a password on the command line interface can be insecure.
# Checking privileges.
..etc. etc.
#   Slave connected to master ... Ok
#   GTID_MODE=ON ... Ok
#   Replication user exists ... Ok
# Checking slaves configuration to master.
# When the master_info_repository variable is set to FILE, the --rpl-user option may be used only if the user specified matches what is shown in the SLAVE STATUS output unless the --force option is used.
ERROR: Query failed. 1054 (42S22): Unknown column 'xyz' in 'where clause' 

Suggested fix:
Set sql_mode before running queries
[12 Feb 2016 2:49] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL Utilities 1.6.3 release, and here's the changelog entry:

MySQL Utilities failed to execute when the sql_mode option included
"ANSI_QUOTES".

Thank you for the bug report.