Debian Codegraph @

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

raw
1 select @@global.rpl_semi_sync_master_wait_point;
2 @@global.rpl_semi_sync_master_wait_point
3 AFTER_COMMIT
4 SET @start_global_value = @@global.rpl_semi_sync_master_wait_point;
5 select @@session.rpl_semi_sync_master_wait_point;
6 ERROR HY000: Variable 'rpl_semi_sync_master_wait_point' is a GLOBAL variable
7 show global variables like 'rpl_semi_sync_master_wait_point';
8 Variable_name Value
9 rpl_semi_sync_master_wait_point AFTER_COMMIT
10 show session variables like 'rpl_semi_sync_master_wait_point';
11 Variable_name Value
12 rpl_semi_sync_master_wait_point AFTER_COMMIT
13 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_point';
14 VARIABLE_NAME VARIABLE_VALUE
15 RPL_SEMI_SYNC_MASTER_WAIT_POINT AFTER_COMMIT
16 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_point';
17 VARIABLE_NAME VARIABLE_VALUE
18 RPL_SEMI_SYNC_MASTER_WAIT_POINT AFTER_COMMIT
19 set global rpl_semi_sync_master_wait_point=AFTER_SYNC;
20 set session rpl_semi_sync_master_wait_point=AFTER_COMMIT;
21 ERROR HY000: Variable 'rpl_semi_sync_master_wait_point' is a GLOBAL variable and should be set with SET GLOBAL
22 select @@global.rpl_semi_sync_master_wait_point;
23 @@global.rpl_semi_sync_master_wait_point
24 AFTER_SYNC
25 select @@session.rpl_semi_sync_master_wait_point;
26 ERROR HY000: Variable 'rpl_semi_sync_master_wait_point' is a GLOBAL variable
27 show global variables like 'rpl_semi_sync_master_wait_point';
28 Variable_name Value
29 rpl_semi_sync_master_wait_point AFTER_SYNC
30 show session variables like 'rpl_semi_sync_master_wait_point';
31 Variable_name Value
32 rpl_semi_sync_master_wait_point AFTER_SYNC
33 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_point';
34 VARIABLE_NAME VARIABLE_VALUE
35 RPL_SEMI_SYNC_MASTER_WAIT_POINT AFTER_SYNC
36 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_point';
37 VARIABLE_NAME VARIABLE_VALUE
38 RPL_SEMI_SYNC_MASTER_WAIT_POINT AFTER_SYNC
39 set global rpl_semi_sync_master_wait_point=1.1;
40 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_wait_point'
41 set global rpl_semi_sync_master_wait_point=1e1;
42 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_wait_point'
43 SET @@global.rpl_semi_sync_master_wait_point = @start_global_value;
44 select @@global.rpl_semi_sync_master_wait_point;
45 @@global.rpl_semi_sync_master_wait_point
46 AFTER_COMMIT