Debian Codegraph @

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

raw
1
2 #
3 # exists as a global only
4 #
5 # 2010-01-21 OBN - Added
6 #
7 source include/have_semisync_plugin.inc;
8 # The following is to prevent a mis-match on windows that has the name of of the lib ending with 'dll'
9 --replace_regex /\.dll/.so/
10 eval INSTALL PLUGIN rpl_semi_sync_replica SONAME '$SEMISYNC_REPLICA_PLUGIN';
11 select @@global.rpl_semi_sync_replica_trace_level;
12 SET @start_global_value = @@global.rpl_semi_sync_replica_trace_level;
13
14 select @@global.rpl_semi_sync_replica_trace_level in (1,16,32,64);
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 select @@session.rpl_semi_sync_replica_trace_level;
17 show global variables like 'rpl_semi_sync_replica_trace_level';
18 show session variables like 'rpl_semi_sync_replica_trace_level';
19 --disable_warnings
20 select * from performance_schema.global_variables where variable_name='rpl_semi_sync_replica_trace_level';
21 select * from performance_schema.session_variables where variable_name='rpl_semi_sync_replica_trace_level';
22 --enable_warnings
23
24 #
25 # show that it's writable
26 #
27 set global rpl_semi_sync_replica_trace_level=16;
28 --error ER_GLOBAL_VARIABLE
29 set session rpl_semi_sync_replica_trace_level=99;
30 select @@global.rpl_semi_sync_replica_trace_level;
31 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 select @@session.rpl_semi_sync_replica_trace_level;
33 show global variables like 'rpl_semi_sync_replica_trace_level';
34 show session variables like 'rpl_semi_sync_replica_trace_level';
35 --disable_warnings
36 select * from performance_schema.global_variables where variable_name='rpl_semi_sync_replica_trace_level';
37 select * from performance_schema.session_variables where variable_name='rpl_semi_sync_replica_trace_level';
38 --enable_warnings
39
40 --echo NOTE: Value can also be set to values that are combinations of values
41 set global rpl_semi_sync_replica_trace_level=42;
42 select @@global.rpl_semi_sync_replica_trace_level;
43 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
44 select @@session.rpl_semi_sync_replica_trace_level;
45 show global variables like 'rpl_semi_sync_replica_trace_level';
46 show session variables like 'rpl_semi_sync_replica_trace_level';
47 --disable_warnings
48 select * from performance_schema.global_variables where variable_name='rpl_semi_sync_replica_trace_level';
49 select * from performance_schema.session_variables where variable_name='rpl_semi_sync_replica_trace_level';
50 --enable_warnings
51
52 #
53 # incorrect types
54 #
55 --error ER_WRONG_TYPE_FOR_VAR
56 set global rpl_semi_sync_replica_trace_level=1.1;
57 --error ER_WRONG_TYPE_FOR_VAR
58 set global rpl_semi_sync_replica_trace_level=1e1;
59 --error ER_WRONG_TYPE_FOR_VAR
60 set global rpl_semi_sync_replica_trace_level="some text";
61
62 #
63 # Cleanup
64 #
65 SET @@global.rpl_semi_sync_replica_trace_level = @start_global_value;
66 select @@global.rpl_semi_sync_replica_trace_level;
67 UNINSTALL PLUGIN rpl_semi_sync_replica;
68