Debian Codegraph @

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

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