1# 2# wsrep_on 3# 4# save the initial values 5SET @wsrep_on_global_saved = @@global.wsrep_on; 6SET @wsrep_on_session_saved = @@session.wsrep_on; 7# default 8SELECT @@global.wsrep_on; 9@@global.wsrep_on 100 11SELECT @@session.wsrep_on; 12@@session.wsrep_on 130 14 15# scope and valid values 16SET @@global.wsrep_on=OFF; 17SELECT @@global.wsrep_on; 18@@global.wsrep_on 190 20SET @@global.wsrep_on=ON; 21SELECT @@global.wsrep_on; 22@@global.wsrep_on 231 24SET @@session.wsrep_on=OFF; 25SELECT @@session.wsrep_on; 26@@session.wsrep_on 270 28SET @@session.wsrep_on=ON; 29SELECT @@session.wsrep_on; 30@@session.wsrep_on 311 32SET @@session.wsrep_on=default; 33SELECT @@session.wsrep_on; 34@@session.wsrep_on 351 36 37# invalid values 38SET @@global.wsrep_on=NULL; 39ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'NULL' 40SET @@global.wsrep_on='junk'; 41ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'junk' 42SET @@session.wsrep_on=NULL; 43ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'NULL' 44SET @@session.wsrep_on='junk'; 45ERROR 42000: Variable 'wsrep_on' can't be set to the value of 'junk' 46 47# restore the initial values 48SET @@global.wsrep_on = @wsrep_on_global_saved; 49SET @@session.wsrep_on = @wsrep_on_session_saved; 50# End of test 51