Debian Codegraph @

mysql-test/suite/ndb_binlog/t/ndb_log_bin_variable.test

raw
1 -- source include/have_ndb.inc
2
3 --echo #
4 --echo # Bug#32860560 NDB_LOG_BIN: INCONSISTENT BEHAVIOUR WHEN SET DYNAMICALLY
5 --echo # - it's not possible to change --ndb-log-bin at runtime, make sure it's
6 --echo # there, can be queried and are readonly
7 #
8 # only global
9 #
10 select @@global.ndb_log_bin;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.ndb_log_bin;
13 show global variables like 'ndb_log_bin';
14 show session variables like 'ndb_log_bin';
15 select * from performance_schema.global_variables where variable_name='ndb_log_bin';
16 select * from performance_schema.session_variables where variable_name='ndb_log_bin';
17
18 #
19 # show that it's read-only
20 #
21 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
22 set global ndb_log_bin=0;
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 set session ndb_log_bin=0;