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