Debian Codegraph @

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

raw
1 # exists as a session only
2
3 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
4 select @@global.skip_replication;
5
6 # Check the variable has a valid numeric value (assumed to be less then 10000)
7 select @@session.skip_replication between 1 and 10000;
8
9 --echo should be empty
10 show global variables like 'skip_replication';
11 show session variables like 'skip_replication';
12
13 # Global I_S variable is empty
14 --echo should be empty
15 select * from information_schema.global_variables where variable_name='skip_replication';
16
17 # Check that I_S value is same as variable
18 select @@session.skip_replication = variable_value from information_schema.session_variables where variable_name='skip_replication';
19
20 #
21 # show that it's writable
22 #
23 set session skip_replication=0;
24 select @@session.skip_replication;
25 set session skip_replication=1;
26 select @@session.skip_replication;
27 select * from information_schema.global_variables where variable_name='skip_replication';
28 select variable_value from information_schema.session_variables where variable_name='skip_replication';
29 --error ER_LOCAL_VARIABLE
30 set global skip_replication=1;