Debian Codegraph @

mysql-test/suite/sys_vars/t/rpl_semi_sync_master_wait_point_basic.test

raw
1 source include/not_embedded.inc;
2 select @@global.rpl_semi_sync_master_wait_point;
3 SET @start_global_value = @@global.rpl_semi_sync_master_wait_point;
4
5 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
6 select @@session.rpl_semi_sync_master_wait_point;
7 show global variables like 'rpl_semi_sync_master_wait_point';
8 show session variables like 'rpl_semi_sync_master_wait_point';
9 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_point';
10 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_point';
11
12 #
13 # show that it's writable
14 #
15 set global rpl_semi_sync_master_wait_point=AFTER_SYNC;
16 --error ER_GLOBAL_VARIABLE
17 set session rpl_semi_sync_master_wait_point=AFTER_COMMIT;
18 select @@global.rpl_semi_sync_master_wait_point;
19 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 select @@session.rpl_semi_sync_master_wait_point;
21 show global variables like 'rpl_semi_sync_master_wait_point';
22 show session variables like 'rpl_semi_sync_master_wait_point';
23 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_point';
24 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_point';
25
26 #
27 # incorrect types
28 #
29 --error ER_WRONG_TYPE_FOR_VAR
30 set global rpl_semi_sync_master_wait_point=1.1;
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global rpl_semi_sync_master_wait_point=1e1;
33
34
35 #
36 # Cleanup
37 #
38 SET @@global.rpl_semi_sync_master_wait_point = @start_global_value;
39 select @@global.rpl_semi_sync_master_wait_point;