Debian Codegraph @

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

raw
1 #
2 # only GLOBAL
3 #
4 SELECT @@GLOBAL.binlog_gtid_simple_recovery;
5 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
6 SELECT @@SESSION.binlog_gtid_simple_recovery;
7 SHOW GLOBAL VARIABLES LIKE 'binlog_gtid_simple_recovery';
8 SHOW SESSION VARIABLES LIKE 'binlog_gtid_simple_recovery';
9
10 --disable_warnings
11 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_gtid_simple_recovery';
12 SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME='binlog_gtid_simple_recovery';
13 --enable_warnings
14
15 #
16 # show that it's read-only
17 #
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 SET GLOBAL binlog_gtid_simple_recovery=1;
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 SET SESSION binlog_gtid_simple_recovery=1;
22