1# 2# wsrep_replicate_myisam 3# 4# save the initial value 5SET @wsrep_replicate_myisam_global_saved = @@global.wsrep_replicate_myisam; 6# default 7SELECT @@global.wsrep_replicate_myisam; 8@@global.wsrep_replicate_myisam 90 10SELECT @@session.wsrep_replicate_myisam; 11ERROR HY000: Variable 'wsrep_replicate_myisam' is a GLOBAL variable 12 13# scope and valid values 14SET @@global.wsrep_replicate_myisam=OFF; 15SELECT @@global.wsrep_replicate_myisam; 16@@global.wsrep_replicate_myisam 170 18SET @@global.wsrep_replicate_myisam=ON; 19SELECT @@global.wsrep_replicate_myisam; 20@@global.wsrep_replicate_myisam 211 22 23# invalid values 24SET @@global.wsrep_replicate_myisam=NULL; 25ERROR 42000: Variable 'wsrep_replicate_myisam' can't be set to the value of 'NULL' 26SET @@global.wsrep_replicate_myisam='junk'; 27ERROR 42000: Variable 'wsrep_replicate_myisam' can't be set to the value of 'junk' 28 29# restore the initial value 30SET @@global.wsrep_replicate_myisam = @wsrep_replicate_myisam_global_saved; 31# End of test 32