Debian Codegraph @

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

raw
1 # We cannot use embedded server here as access right checking will not work
2 --source include/not_embedded.inc
3 #
4 # only global
5 #
6 select @@global.max_binlog_total_size;
7 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
8 select @@session.max_binlog_total_size;
9 show global variables like 'max_binlog_total_size';
10 show session variables like 'max_binlog_total_size';
11 --disable_warnings
12 select * from information_schema.global_variables where variable_name='max_binlog_total_size';
13 select * from information_schema.session_variables where variable_name='max_binlog_total_size';
14 --enable_warnings
15
16 #
17 # show that it is not read-only
18 #
19 set global max_binlog_total_size=1;
20 select @@global.max_binlog_total_size, @@global.binlog_space_limit;
21 set global max_binlog_total_size=1;
22 select @@global.max_binlog_total_size;
23 set global binlog_space_limit=2;
24 select @@global.max_binlog_total_size, @@global.binlog_space_limit;
25
26 --error ER_GLOBAL_VARIABLE
27 set session max_binlog_total_size=1;
28
29 set global max_binlog_total_size=default;
30
31 #
32 # Check permissions
33 #
34 CREATE USER user1@localhost;
35 connect (con2,localhost,user1,,);
36 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
37 set global max_binlog_total_size=1;
38 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
39 set global binlog_space_limit=1;
40 disconnect con2;
41 connection default;
42 DROP USER user1@localhost;