1
SET @start_global_value = @@global.sync_master_info;
2
SELECT @start_global_value;
5
select @@global.sync_master_info;
6
@@global.sync_master_info
8
select @@session.sync_master_info;
9
ERROR HY000: Variable 'sync_master_info' is a GLOBAL variable
10
show global variables like 'sync_master_info';
13
show session variables like 'sync_master_info';
16
select * from information_schema.global_variables where variable_name='sync_master_info';
17
VARIABLE_NAME VARIABLE_VALUE
19
select * from information_schema.session_variables where variable_name='sync_master_info';
20
VARIABLE_NAME VARIABLE_VALUE
22
set global sync_master_info=1;
23
select @@global.sync_master_info;
24
@@global.sync_master_info
26
set session sync_master_info=1;
27
ERROR HY000: Variable 'sync_master_info' is a GLOBAL variable and should be set with SET GLOBAL
28
set global sync_master_info=1.1;
29
ERROR 42000: Incorrect argument type to variable 'sync_master_info'
30
set global sync_master_info=1e1;
31
ERROR 42000: Incorrect argument type to variable 'sync_master_info'
32
set global sync_master_info="foo";
33
ERROR 42000: Incorrect argument type to variable 'sync_master_info'
34
set global sync_master_info=0;
35
select @@global.sync_master_info;
36
@@global.sync_master_info
38
set global sync_master_info=cast(-1 as unsigned int);
40
Warning 1292 Truncated incorrect sync_master_info value: '18446744073709551615'
41
select @@global.sync_master_info;
42
@@global.sync_master_info
44
SET @@global.sync_master_info = @start_global_value;
45
SELECT @@global.sync_master_info;
46
@@global.sync_master_info