1
SET @start_global_value = @@global.rpl_recovery_rank;
2
SELECT @start_global_value;
5
'#--------------------FN_DYNVARS_142_01-------------------------#'
6
SET @@global.rpl_recovery_rank = 500000;
8
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
9
SET @@global.rpl_recovery_rank = DEFAULT;
11
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
12
SELECT @@global.rpl_recovery_rank;
13
@@global.rpl_recovery_rank
15
'#--------------------FN_DYNVARS_142_02-------------------------#'
16
SET @@global.rpl_recovery_rank = 0;
18
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
19
SELECT @@global.rpl_recovery_rank;
20
@@global.rpl_recovery_rank
22
SET @@global.rpl_recovery_rank = 1024;
24
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
25
SELECT @@global.rpl_recovery_rank;
26
@@global.rpl_recovery_rank
28
SET @@global.rpl_recovery_rank = 123456789;
30
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
31
SELECT @@global.rpl_recovery_rank;
32
@@global.rpl_recovery_rank
34
SET @@global.rpl_recovery_rank = 2147483648*2;
36
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
37
Warning 1292 Truncated incorrect rpl_recovery_rank value: '4294967296'
38
SELECT @@global.rpl_recovery_rank;
39
@@global.rpl_recovery_rank
41
SET @@global.rpl_recovery_rank = 2147483648*1024;
43
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
44
Warning 1292 Truncated incorrect rpl_recovery_rank value: '2199023255552'
45
SELECT @@global.rpl_recovery_rank;
46
@@global.rpl_recovery_rank
48
SELECT @@global.rpl_recovery_rank;
49
@@global.rpl_recovery_rank
51
SET @@global.rpl_recovery_rank = 2147483648*2147483648;
53
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
54
Warning 1292 Truncated incorrect rpl_recovery_rank value: '4611686018427387904'
55
SELECT @@global.rpl_recovery_rank;
56
@@global.rpl_recovery_rank
58
'#--------------------FN_DYNVARS_142_03-------------------------#'
59
SET @@rpl_recovery_rank = 2;
60
ERROR HY000: Variable 'rpl_recovery_rank' is a GLOBAL variable and should be set with SET GLOBAL
61
SET @@session.rpl_recovery_rank = 3;
62
ERROR HY000: Variable 'rpl_recovery_rank' is a GLOBAL variable and should be set with SET GLOBAL
63
SET @@local.rpl_recovery_rank = 4;
64
ERROR HY000: Variable 'rpl_recovery_rank' is a GLOBAL variable and should be set with SET GLOBAL
65
'#------------------FN_DYNVARS_142_04-----------------------#'
66
SET @@global.rpl_recovery_rank = -1;
68
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
69
Warning 1292 Truncated incorrect rpl_recovery_rank value: '-1'
70
SELECT @@global.rpl_recovery_rank;
71
@@global.rpl_recovery_rank
73
SET @@global.rpl_recovery_rank = -2147483648;
75
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
76
Warning 1292 Truncated incorrect rpl_recovery_rank value: '-2147483648'
77
SELECT @@global.rpl_recovery_rank;
78
@@global.rpl_recovery_rank
80
SET @@global.rpl_recovery_rank = -2147483649;
82
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
83
Warning 1292 Truncated incorrect rpl_recovery_rank value: '-2147483649'
84
SELECT @@global.rpl_recovery_rank;
85
@@global.rpl_recovery_rank
87
SET @@global.rpl_recovery_rank = 65530.34;
88
ERROR 42000: Incorrect argument type to variable 'rpl_recovery_rank'
89
SET @@global.rpl_recovery_rank = 2147483649.56;
90
ERROR 42000: Incorrect argument type to variable 'rpl_recovery_rank'
91
SET @@global.rpl_recovery_rank = 1G;
92
ERROR 42000: Incorrect argument type to variable 'rpl_recovery_rank'
93
'#------------------FN_DYNVARS_142_05-----------------------#'
94
SET @@global.rpl_recovery_rank = 3000;
96
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
97
SELECT @@global.rpl_recovery_rank = VARIABLE_VALUE
98
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
99
WHERE VARIABLE_NAME='rpl_recovery_rank';
100
@@global.rpl_recovery_rank = VARIABLE_VALUE
102
'#------------------FN_DYNVARS_142_06-----------------------#'
103
SELECT count(VARIABLE_VALUE)
104
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
105
WHERE VARIABLE_NAME='rpl_recovery_rank';
106
count(VARIABLE_VALUE)
108
'#------------------FN_DYNVARS_142_07-----------------------#'
109
SET @@global.rpl_recovery_rank = TRUE;
111
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
112
SELECT @@global.rpl_recovery_rank;
113
@@global.rpl_recovery_rank
115
SET @@global.rpl_recovery_rank = FALSE;
117
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
118
SELECT @@global.rpl_recovery_rank;
119
@@global.rpl_recovery_rank
121
'#---------------------FN_DYNVARS_001_08----------------------#'
122
SET @@global.rpl_recovery_rank = 512;
124
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
125
SELECT @@rpl_recovery_rank = @@global.rpl_recovery_rank;
126
@@rpl_recovery_rank = @@global.rpl_recovery_rank
128
'#---------------------FN_DYNVARS_001_09----------------------#'
129
SET rpl_recovery_rank = 2048;
130
ERROR HY000: Variable 'rpl_recovery_rank' is a GLOBAL variable and should be set with SET GLOBAL
131
SELECT rpl_recovery_rank;
132
ERROR 42S22: Unknown column 'rpl_recovery_rank' in 'field list'
133
SELECT @@rpl_recovery_rank;
136
SET global rpl_recovery_rank = 64;
138
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
139
SET @@global.rpl_recovery_rank = @start_global_value;
141
Warning 1287 '@@rpl_recovery_rank' is deprecated and will be removed in a future release.
142
SELECT @@global.rpl_recovery_rank;
143
@@global.rpl_recovery_rank