Debian Codegraph @

mysql-test/suite/sql_sequence/read_only.test

raw
1 --source include/have_innodb.inc
2 --source include/not_embedded.inc
3
4 #
5 # Test innodb read only
6 #
7
8 create sequence s1 cache 2 engine=innodb;
9
10 --let $restart_parameters= --innodb-read-only
11 --source include/restart_mysqld.inc
12
13 connection default;
14 show global variables like 'innodb_read_only';
15 use test;
16 set session binlog_format= row;
17
18 --echo ###########################################
19 --echo read_only create error.
20 --echo ###########################################
21
22 show global variables like 'innodb_read_only';
23 use test;
24
25 --error ER_CANT_CREATE_TABLE
26 create sequence s2 cache 5 engine=innodb;
27
28 --echo ###########################################
29 --echo read_only query error.
30 --echo ###########################################
31 --error ER_OPEN_AS_READONLY
32 select next value for s1;
33 --error ER_OPEN_AS_READONLY
34 select next value for s1;
35 --error ER_OPEN_AS_READONLY
36 select next value for s1;
37
38 select * from s1;
39 --let $restart_parameters=
40 --source include/restart_mysqld.inc
41 select * from s1;
42 --disable_ps2_protocol
43 select next value for s1;
44 --enable_ps2_protocol
45 select * from s1;
46 drop sequence s1;