Debian Codegraph @

mysql-test/suite/innodb/r/readonly.result

raw
1 #
2 # Bug#19904800 - MISSING DBUG_RETURN IN HA_INNOBASE::UPDATE_ROW
3 #
4 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB;
5 CREATE TABLE t2(b int PRIMARY KEY) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES(1);
7 INSERT INTO t2 VALUES(2);
8 SET GLOBAL innodb_fast_shutdown = 0;
9 # restart: --innodb-read-only
10 UPDATE t1,t2 SET t1.a = 2, t2.b = 2 WHERE t1.a = 1;
11 ERROR HY000: Table 't1' is read only
12 # restart
13 DROP TABLE t1;
14 DROP TABLE t2;
15 #
16 # Bug#20578834 - INNODB READ ONLY MODE AND NON EXISTENT TMP DIR CRASHES SERVER
17 #
18 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB;
19 INSERT INTO t1 VALUES(1);
20 # Patch for bug#31377118 rejects startup if tmpdir does not exist.
21 Occurrences of 'No such file or directory' in the input file: 1
22 # restart
23 SELECT * FROM t1;
24 a
25 1
26 DROP TABLE t1;
27 #
28 # Bug#21966795 "FK DEFINITIONS MISSING FROM SHOW CREATE TABLE IN
29 # 'INNODB_READ_ONLY' MODE"
30 #
31 CREATE TABLE parent(pk INT PRIMARY KEY);
32 CREATE TABLE child(fk INT, CONSTRAINT c FOREIGN KEY (fk) REFERENCES parent (pk));
33 SHOW CREATE TABLE child;
34 Table Create Table
35 child CREATE TABLE `child` (
36 `fk` int DEFAULT NULL,
37 KEY `c` (`fk`),
38 CONSTRAINT `c` FOREIGN KEY (`fk`) REFERENCES `parent` (`pk`)
39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
40 SET GLOBAL innodb_fast_shutdown = 0;
41 # restart: --innodb-read-only
42 # SHOW CREATE TABLE should still show foreign keys.
43 SHOW CREATE TABLE child;
44 Table Create Table
45 child CREATE TABLE `child` (
46 `fk` int DEFAULT NULL,
47 KEY `c` (`fk`),
48 CONSTRAINT `c` FOREIGN KEY (`fk`) REFERENCES `parent` (`pk`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
50 # Clean-up.
51 # restart
52 DROP TABLES child, parent;