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;
42
SELECT @@global.slave_transaction_retries;
43
@@global.slave_transaction_retries
45
SET @@global.slave_transaction_retries = 4294967295;
46
SELECT @@global.slave_transaction_retries;
47
@@global.slave_transaction_retries
49
'#--------------------FN_DYNVARS_149_04-------------------------#'
50
SET @@slave_transaction_retries = 2;
51
ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
52
SET @@session.slave_transaction_retries = 3;
53
ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
54
SET @@local.slave_transaction_retries = 4;
55
ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
56
'#------------------FN_DYNVARS_149_05-----------------------#'
57
SET @@global.slave_transaction_retries = -1;
58
SELECT @@global.slave_transaction_retries;
59
@@global.slave_transaction_retries
61
SET @@global.slave_transaction_retries = 2147483649*2147483649;
62
SELECT @@global.slave_transaction_retries;
63
@@global.slave_transaction_retries
65
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
66
SET @@global.slave_transaction_retries = 65530.34.;
67
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
68
SET @@global.slave_transaction_retries = '100';
69
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
70
SET @@global.slave_transaction_retries = 7483649.56;
71
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
72
SET @@global.slave_transaction_retries = ON;
73
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
74
SET @@global.slave_transaction_retries = OFF;
75
ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries'
76
'#------------------FN_DYNVARS_149_06-----------------------#'
77
SET @@global.slave_transaction_retries = 3000;
78
SELECT @@global.slave_transaction_retries = VARIABLE_VALUE
79
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
80
WHERE VARIABLE_NAME='slave_transaction_retries';
81
@@global.slave_transaction_retries = VARIABLE_VALUE
83
'#------------------FN_DYNVARS_149_07-----------------------#'
84
SELECT count(VARIABLE_VALUE)
85
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
86
WHERE VARIABLE_NAME='slave_transaction_retries';
89
'#------------------FN_DYNVARS_149_08-----------------------#'
90
SET @@global.slave_transaction_retries = TRUE;
91
SELECT @@global.slave_transaction_retries;
92
@@global.slave_transaction_retries
94
SET @@global.slave_transaction_retries = FALSE;
95
SELECT @@global.slave_transaction_retries;
96
@@global.slave_transaction_retries
98
'#---------------------FN_DYNVARS_149_09----------------------#'
99
SET @@global.slave_transaction_retries = 60*60;
100
SELECT @@slave_transaction_retries = @@global.slave_transaction_retries;
101
@@slave_transaction_retries = @@global.slave_transaction_retries
103
'#---------------------FN_DYNVARS_149_10----------------------#'
104
SET slave_transaction_retries = 2048;
105
ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
106
SELECT slave_transaction_retries;
107
ERROR 42S22: Unknown column 'slave_transaction_retries' in 'field list'
108
SELECT @@slave_transaction_retries;
109
@@slave_transaction_retries
111
SET global slave_transaction_retries = 99;
112
SET @@global.slave_transaction_retries = @start_global_value;
113
SELECT @@global.slave_transaction_retries;
114
@@global.slave_transaction_retries