Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 # Can only be set from the command line.
4 # show the global and session values;
5
6 --echo Valid values are 'ON' and 'OFF'
7 select @@global.innodb_read_only;
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.innodb_read_only;
10 show global variables like 'innodb_read_only';
11 show session variables like 'innodb_read_only';
12 --disable_warnings
13 select * from information_schema.global_variables where variable_name='innodb_read_only';
14 select * from information_schema.session_variables where variable_name='innodb_read_only';
15 --enable_warnings
16
17 # Show that it's read-only
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 set global innodb_read_only=1;
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 set session innodb_read_only=1;
22