1# 2# wsrep_forced_binlog_format 3# 4# save the initial value 5SET @wsrep_forced_binlog_format_global_saved = @@global.wsrep_forced_binlog_format; 6# default 7SELECT @@global.wsrep_forced_binlog_format; 8@@global.wsrep_forced_binlog_format 9NONE 10 11# scope 12SELECT @@session.wsrep_forced_binlog_format; 13ERROR HY000: Variable 'wsrep_forced_binlog_format' is a GLOBAL variable 14SET @@global.wsrep_forced_binlog_format=STATEMENT; 15SELECT @@global.wsrep_forced_binlog_format; 16@@global.wsrep_forced_binlog_format 17STATEMENT 18 19# valid values 20SET @@global.wsrep_forced_binlog_format=STATEMENT; 21SELECT @@global.wsrep_forced_binlog_format; 22@@global.wsrep_forced_binlog_format 23STATEMENT 24SET @@global.wsrep_forced_binlog_format=ROW; 25SELECT @@global.wsrep_forced_binlog_format; 26@@global.wsrep_forced_binlog_format 27ROW 28SET @@global.wsrep_forced_binlog_format=MIXED; 29SELECT @@global.wsrep_forced_binlog_format; 30@@global.wsrep_forced_binlog_format 31MIXED 32SET @@global.wsrep_forced_binlog_format=NONE; 33SELECT @@global.wsrep_forced_binlog_format; 34@@global.wsrep_forced_binlog_format 35NONE 36SET @@global.wsrep_forced_binlog_format=default; 37SELECT @@global.wsrep_forced_binlog_format; 38@@global.wsrep_forced_binlog_format 39NONE 40 41# invalid values 42SET @@global.wsrep_forced_binlog_format=NULL; 43ERROR 42000: Variable 'wsrep_forced_binlog_format' can't be set to the value of 'NULL' 44SET @@global.wsrep_forced_binlog_format='junk'; 45ERROR 42000: Variable 'wsrep_forced_binlog_format' can't be set to the value of 'junk' 46SET @@global.wsrep_forced_binlog_format=ON; 47ERROR 42000: Variable 'wsrep_forced_binlog_format' can't be set to the value of 'ON' 48 49# restore the initial value 50SET @@global.wsrep_forced_binlog_format = @wsrep_forced_binlog_format_global_saved; 51# End of test 52