Debian Codegraph @

mysql-test/suite/sys_vars/r/wsrep_drupal_282555_workaround_basic.result

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