Debian Codegraph @

mysql-test/suite/innodb/t/innodb_read_only.test

raw
1
2 # Don't test this under valgrind, memory leaks will occur due restart
3 --source include/not_valgrind.inc
4
5 CREATE DATABASE WL6445;
6
7 CREATE TABLE WL6445.t1(c1 INT, c2 INT, INDEX sec_idx(c2)) ENGINE=InnoDB;
8 INSERT INTO WL6445.t1 VALUES(0,0),(1,1),(2,2);
9
10 SHOW CREATE TABLE WL6445.t1;
11
12 --source include/restart_innodb_read_only.inc
13
14 ## DDL
15
16 SELECT COUNT(*) FROM WL6445.t1;
17
18 --error ER_CANT_LOCK
19 INSERT INTO WL6445.t1 VALUES(3,3);
20
21 --ERROR ER_OPEN_AS_READONLY
22 INSERT INTO WL6445.t1 SELECT * FROM WL6445.t1;
23
24 --error ER_CANT_LOCK
25 REPLACE INTO WL6445.t1 VALUES(1,1);
26
27 --error ER_CANT_LOCK
28 UPDATE WL6445.t1 SET c1 = c1 + 100;
29
30 --error ER_CANT_LOCK
31 DELETE FROM WL6445.t1;
32
33 # DDL
34 --error ER_DUP_FIELDNAME
35 ALTER TABLE WL6445.t1 ADD COLUMN c2 INT;
36
37 --error ER_READ_ONLY_MODE
38 ALTER TABLE WL6445.t1 ADD UNIQUE INDEX(c1);
39
40 --error ER_READ_ONLY_MODE
41 ALTER TABLE WL6445.t1 DROP INDEX sec_idx;
42
43 --replace_regex /wl6445/WL6445/i
44 --error ER_ENGINE_CANT_DROP_TABLE
45 DROP TABLE WL6445.t1;
46
47 --error ER_OPEN_AS_READONLY
48 TRUNCATE TABLE WL6445.t1;
49
50 --replace_regex /wl6444/WL6444/i
51 --error ER_BAD_DB_ERROR
52 RENAME TABLE WL6445.t1 TO WL6444.t2;
53
54 --replace_regex /wl6445/WL6445/i
55 --error ER_ENGINE_CANT_DROP_TABLE
56 DROP DATABASE WL6445;
57
58 SHOW CREATE TABLE WL6445.t1;
59
60 --source include/restart_mysqld.inc
61
62 DROP TABLE WL6445.t1;
63
64 DROP DATABASE WL6445;
65
66 --disable_query_log
67 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Tablespace .*, name '.*', file '.*' is missing");
68 --enable_query_log