MySQL patches by Codership

  1. Bug #1160854
  2. Comment #3

Comment 3 for bug 1160854

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

With PXC 5.6.19, getting error while setting binlog_format variable.

mysql> set binlog_format=STATEMENT;
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
mysql> set binlog_format='STATEMENT';
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
mysql> set global binlog_format='STATEMENT';
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
mysql> SET SESSION binlog_format=STATEMENT;
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
mysql>