1# 2# wsrep_certify_nonpk 3# 4# save the initial value 5SET @wsrep_certify_nonpk_global_saved = @@global.wsrep_certify_nonpk; 6# default 7SELECT @@global.wsrep_certify_nonpk; 8@@global.wsrep_certify_nonpk 91 10 11# scope 12SELECT @@session.wsrep_certify_nonpk; 13ERROR HY000: Variable 'wsrep_certify_nonPK' is a GLOBAL variable 14SET @@global.wsrep_certify_nonpk=OFF; 15SELECT @@global.wsrep_certify_nonpk; 16@@global.wsrep_certify_nonpk 170 18SET @@global.wsrep_certify_nonpk=ON; 19SELECT @@global.wsrep_certify_nonpk; 20@@global.wsrep_certify_nonpk 211 22 23# valid values 24SET @@global.wsrep_certify_nonpk='OFF'; 25SELECT @@global.wsrep_certify_nonpk; 26@@global.wsrep_certify_nonpk 270 28SET @@global.wsrep_certify_nonpk=ON; 29SELECT @@global.wsrep_certify_nonpk; 30@@global.wsrep_certify_nonpk 311 32SET @@global.wsrep_certify_nonpk=default; 33SELECT @@global.wsrep_certify_nonpk; 34@@global.wsrep_certify_nonpk 351 36 37# invalid values 38SET @@global.wsrep_certify_nonpk=NULL; 39ERROR 42000: Variable 'wsrep_certify_nonPK' can't be set to the value of 'NULL' 40SET @@global.wsrep_certify_nonpk='junk'; 41ERROR 42000: Variable 'wsrep_certify_nonPK' can't be set to the value of 'junk' 42 43# restore the initial value 44SET @@global.wsrep_certify_nonpk = @wsrep_certify_nonpk_global_saved; 45# End of test 46