Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 # bool readonly
3
4 #
5 # show values;
6 #
7 select @@global.innodb_use_atomic_writes;
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.innodb_use_atomic_writes;
10 show global variables like 'innodb_use_atomic_writes';
11 show session variables like 'innodb_use_atomic_writes';
12 select * from information_schema.global_variables where variable_name='innodb_use_atomic_writes';
13 select * from information_schema.session_variables where variable_name='innodb_use_atomic_writes';
14
15 #
16 # show that it's read-only
17 #
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 set global innodb_use_atomic_writes=1;
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 set session innodb_use_atomic_writes=1;
22