1
SET @start_global_value = @@global.slave_transaction_retries;
2
SELECT @start_global_value;
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
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
16
'#--------------------FN_DYNVARS_149_03-------------------------#'
17
SET @@global.slave_transaction_retries = 0;
18
SELECT @@global.slave_transaction_retries;
19
@@global.slave_transaction_retries
21
SET @@global.slave_transaction_retries = 1;
22
SELECT @@global.slave_transaction_retries;
23
@@global.slave_transaction_retries
25
SET @@global.slave_transaction_retries = 15;
26
SELECT @@global.slave_transaction_retries;
27
@@global.slave_transaction_retries
29
SET @@global.slave_transaction_retries = 1024;
30
SELECT @@global.slave_transaction_retries;
31
@@global.slave_transaction_retries
33
SET @@global.slave_transaction_retries = 2147483648;
34
SELECT @@global.slave_transaction_retries;
35
@@global.slave_transaction_retries
37
SET @@global.slave_transaction_retries = 2147483648*2-1;
38
SELECT @@global.slave_transaction_retries;
39
@@global.slave_transaction_retries
41
SET @@global.slave_transaction_retries = 2147483649*2;
43
Warning 1292 Truncated incorrect slave_transaction_retries value: '4294967298'
44
SELECT @@global.slave_transaction_retries;
45
@@global.slave_transaction_retries
47
SET @@global.slave_transaction_retries = 4294967295;
48
SELECT @@global.slave_transaction_retries;
49
@@global.slave_transaction_retries
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
SELECT @@global.slave_transaction_retries;
61
@@global.slave_transaction_retries
63
SET @@global.slave_transaction_retries = 2147483649*2147483649;
65
Warning 1292 Truncated incorrect slave_transaction_retries value: '4611686022722355201'
66
SELECT @@global.slave_transaction_retries;
67
@@global.slave_transaction_retries
69
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
70
SET @@global.slave_transaction_retries = 65530.34.;
71
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
72
SET @@global.slave_transaction_retries = '100';
73
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
74
SET @@global.slave_transaction_retries = 7483649.56;
75
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
76
SET @@global.slave_transaction_retries = ON;
77
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
78
SET @@global.slave_transaction_retries = OFF;
79
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
80
'#------------------FN_DYNVARS_149_06-----------------------#'
81
SET @@global.slave_transaction_retries = 3000;
82
SELECT @@global.slave_transaction_retries = VARIABLE_VALUE
83
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
84
WHERE VARIABLE_NAME='slave_transaction_retries';
85
@@global.slave_transaction_retries = VARIABLE_VALUE
87
'#------------------FN_DYNVARS_149_07-----------------------#'
88
SELECT count(VARIABLE_VALUE)
89
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
90
WHERE VARIABLE_NAME='slave_transaction_retries';
93
'#------------------FN_DYNVARS_149_08-----------------------#'
94
SET @@global.slave_transaction_retries = TRUE;
95
SELECT @@global.slave_transaction_retries;
96
@@global.slave_transaction_retries
98
SET @@global.slave_transaction_retries = FALSE;
99
SELECT @@global.slave_transaction_retries;
100
@@global.slave_transaction_retries
102
'#---------------------FN_DYNVARS_149_09----------------------#'
103
SET @@global.slave_transaction_retries = 60*60;
104
SELECT @@slave_transaction_retries = @@global.slave_transaction_retries;
105
@@slave_transaction_retries = @@global.slave_transaction_retries
107
'#---------------------FN_DYNVARS_149_10----------------------#'
108
SET slave_transaction_retries = 2048;
109
ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
110
SELECT slave_transaction_retries;
111
ERROR 42S22: Unknown column 'slave_transaction_retries' in 'field list'
112
SELECT @@slave_transaction_retries;
113
@@slave_transaction_retries
115
SET global slave_transaction_retries = 99;
116
SET @@global.slave_transaction_retries = @start_global_value;
117
SELECT @@global.slave_transaction_retries;
118
@@global.slave_transaction_retries