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