Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.sync_relay_log_info;
2 Warnings:
3 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 10000
7 select @@global.sync_relay_log_info;
8 @@global.sync_relay_log_info
9 10000
10 Warnings:
11 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
12 select @@session.sync_relay_log_info;
13 ERROR HY000: Variable 'sync_relay_log_info' is a GLOBAL variable
14 show global variables like 'sync_relay_log_info';
15 Variable_name Value
16 sync_relay_log_info 10000
17 show session variables like 'sync_relay_log_info';
18 Variable_name Value
19 sync_relay_log_info 10000
20 select * from performance_schema.global_variables where variable_name='sync_relay_log_info';
21 VARIABLE_NAME VARIABLE_VALUE
22 sync_relay_log_info 10000
23 select * from performance_schema.session_variables where variable_name='sync_relay_log_info';
24 VARIABLE_NAME VARIABLE_VALUE
25 sync_relay_log_info 10000
26 set global sync_relay_log_info=1;
27 Warnings:
28 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
29 select @@global.sync_relay_log_info;
30 @@global.sync_relay_log_info
31 1
32 Warnings:
33 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
34 set session sync_relay_log_info=1;
35 ERROR HY000: Variable 'sync_relay_log_info' is a GLOBAL variable and should be set with SET GLOBAL
36 set global sync_relay_log_info=1.1;
37 ERROR 42000: Incorrect argument type to variable 'sync_relay_log_info'
38 set global sync_relay_log_info=1e1;
39 ERROR 42000: Incorrect argument type to variable 'sync_relay_log_info'
40 set global sync_relay_log_info="foo";
41 ERROR 42000: Incorrect argument type to variable 'sync_relay_log_info'
42 set global sync_relay_log_info=0;
43 Warnings:
44 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
45 select @@global.sync_relay_log_info;
46 @@global.sync_relay_log_info
47 0
48 Warnings:
49 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
50 set global sync_relay_log_info=cast(-1 as unsigned int);
51 Warnings:
52 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
53 Warning 1292 Truncated incorrect sync_relay_log_info value: '18446744073709551615'
54 select @@global.sync_relay_log_info;
55 @@global.sync_relay_log_info
56 4294967295
57 Warnings:
58 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
59 SET @@global.sync_relay_log_info = @start_global_value;
60 Warnings:
61 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
62 SELECT @@global.sync_relay_log_info;
63 @@global.sync_relay_log_info
64 10000
65 Warnings:
66 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.