Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.slave_transaction_retries;
2 SELECT @start_global_value;
3 @start_global_value
4 10
5 '#--------------------FN_DYNVARS_149_01-------------------------#'
6 SET @@global.slave_transaction_retries = 50;
7 SET @@global.slave_transaction_retries = DEFAULT;
8 SELECT @@global.slave_transaction_retries;
9 @@global.slave_transaction_retries
10 10
11 '#--------------------FN_DYNVARS_149_02-------------------------#'
12 SET @@global.slave_transaction_retries = DEFAULT;
13 SELECT @@global.slave_transaction_retries = 10;
14 @@global.slave_transaction_retries = 10
15 1
16 '#--------------------FN_DYNVARS_149_03-------------------------#'
17 SET @@global.slave_transaction_retries = 0;
18 SELECT @@global.slave_transaction_retries;
19 @@global.slave_transaction_retries
20 0
21 SET @@global.slave_transaction_retries = 1;
22 SELECT @@global.slave_transaction_retries;
23 @@global.slave_transaction_retries
24 1
25 SET @@global.slave_transaction_retries = 15;
26 SELECT @@global.slave_transaction_retries;
27 @@global.slave_transaction_retries
28 15
29 SET @@global.slave_transaction_retries = 1024;
30 SELECT @@global.slave_transaction_retries;
31 @@global.slave_transaction_retries
32 1024
33 SET @@global.slave_transaction_retries = 2147483648;
34 SELECT @@global.slave_transaction_retries;
35 @@global.slave_transaction_retries
36 2147483648
37 SET @@global.slave_transaction_retries = 2147483648*2-1;
38 SELECT @@global.slave_transaction_retries;
39 @@global.slave_transaction_retries
40 4294967295
41 SET @@global.slave_transaction_retries = 2147483649*2;
42 Warnings:
43 Warning 1292 Truncated incorrect slave_transaction_retries value: '4294967298'
44 SELECT @@global.slave_transaction_retries;
45 @@global.slave_transaction_retries
46 4294967295
47 SET @@global.slave_transaction_retries = 4294967295;
48 SELECT @@global.slave_transaction_retries;
49 @@global.slave_transaction_retries
50 4294967295
51 '#--------------------FN_DYNVARS_149_04-------------------------#'
52 SET @@slave_transaction_retries = 2;
53 ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
54 SET @@session.slave_transaction_retries = 3;
55 ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
56 SET @@local.slave_transaction_retries = 4;
57 ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
58 '#------------------FN_DYNVARS_149_05-----------------------#'
59 SET @@global.slave_transaction_retries = -1;
60 Warnings:
61 Warning 1292 Truncated incorrect slave_transaction_retries value: '-1'
62 SELECT @@global.slave_transaction_retries;
63 @@global.slave_transaction_retries
64 0
65 SET @@global.slave_transaction_retries = 2147483649*2147483649;
66 Warnings:
67 Warning 1292 Truncated incorrect slave_transaction_retries value: '4611686022722355201'
68 SELECT @@global.slave_transaction_retries;
69 @@global.slave_transaction_retries
70 4294967295
71 SET @@global.slave_transaction_retries = 65530.34;
72 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
73 SET @@global.slave_transaction_retries = '100';
74 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
75 SET @@global.slave_transaction_retries = 7483649.56;
76 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
77 SET @@global.slave_transaction_retries = ON;
78 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
79 SET @@global.slave_transaction_retries = OFF;
80 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
81 '#------------------FN_DYNVARS_149_06-----------------------#'
82 SET @@global.slave_transaction_retries = 3000;
83 SELECT @@global.slave_transaction_retries = VARIABLE_VALUE
84 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
85 WHERE VARIABLE_NAME='slave_transaction_retries';
86 @@global.slave_transaction_retries = VARIABLE_VALUE
87 1
88 '#------------------FN_DYNVARS_149_07-----------------------#'
89 SELECT count(VARIABLE_VALUE)
90 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
91 WHERE VARIABLE_NAME='slave_transaction_retries';
92 count(VARIABLE_VALUE)
93 1
94 '#------------------FN_DYNVARS_149_08-----------------------#'
95 SET @@global.slave_transaction_retries = TRUE;
96 SELECT @@global.slave_transaction_retries;
97 @@global.slave_transaction_retries
98 1
99 SET @@global.slave_transaction_retries = FALSE;
100 SELECT @@global.slave_transaction_retries;
101 @@global.slave_transaction_retries
102 0
103 '#---------------------FN_DYNVARS_149_09----------------------#'
104 SET @@global.slave_transaction_retries = 60*60;
105 SELECT @@slave_transaction_retries = @@global.slave_transaction_retries;
106 @@slave_transaction_retries = @@global.slave_transaction_retries
107 1
108 '#---------------------FN_DYNVARS_149_10----------------------#'
109 SET slave_transaction_retries = 2048;
110 ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
111 SELECT slave_transaction_retries;
112 ERROR 42S22: Unknown column 'slave_transaction_retries' in 'SELECT'
113 SELECT @@slave_transaction_retries;
114 @@slave_transaction_retries
115 3600
116 SET global slave_transaction_retries = 99;
117 SET @@global.slave_transaction_retries = @start_global_value;
118 SELECT @@global.slave_transaction_retries;
119 @@global.slave_transaction_retries
120 10