--echo # --echo # Bug#19904800 - MISSING DBUG_RETURN IN HA_INNOBASE::UPDATE_ROW --echo # CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB; CREATE TABLE t2(b int PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES(1); INSERT INTO t2 VALUES(2); --source include/restart_innodb_read_only.inc --error ER_OPEN_AS_READONLY UPDATE t1,t2 SET t1.a = 2, t2.b = 2 WHERE t1.a = 1; # Restart in normal mode to drop tables let $restart_parameters = restart; --source include/restart_mysqld.inc DROP TABLE t1; DROP TABLE t2; --echo # --echo # Bug#20578834 - INNODB READ ONLY MODE AND NON EXISTENT TMP DIR CRASHES SERVER --echo # --disable_query_log call mtr.add_suppression("Skip updating information_schema metadata in InnoDB read-only mode."); call mtr.add_suppression("Skipped updating resource group metadata in InnoDB read only mode."); --enable_query_log CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES(1); --echo # Patch for bug#31377118 rejects startup if tmpdir does not exist. # Get hold of data directory, assign a separate log file, stop server. --let $MYSQLD_LOG= $MYSQLTEST_VARDIR/log/tmpdir_err.log --let $MYSQLD_DATADIR= `SELECT @@datadir` --source include/shutdown_mysqld.inc # Start with an invalid tmpdir and search the error log for the error message. --error 1,42,134,138,139,-1073741571,-1073741819,-1073740940 --exec $MYSQLD --no-defaults --secure-file-priv="" --basedir=$BASEDIR --lc-messages-dir=$MYSQL_SHAREDIR --log-error=$MYSQLD_LOG --datadir=$MYSQLD_DATADIR --tmpdir=no/such/directory > $MYSQLD_LOG 2>&1 --let $grep_file= $MYSQLD_LOG --let $grep_pattern= No such file or directory --let $grep_output= print_count --source include/grep_pattern.inc # Start in normal mode to drop tables let $restart_parameters = restart; --source include/start_mysqld.inc SELECT * FROM t1; DROP TABLE t1; --echo # --echo # Bug#21966795 "FK DEFINITIONS MISSING FROM SHOW CREATE TABLE IN --echo # 'INNODB_READ_ONLY' MODE" --echo # CREATE TABLE parent(pk INT PRIMARY KEY); CREATE TABLE child(fk INT, CONSTRAINT c FOREIGN KEY (fk) REFERENCES parent (pk)); SHOW CREATE TABLE child; --source include/restart_innodb_read_only.inc --echo # SHOW CREATE TABLE should still show foreign keys. SHOW CREATE TABLE child; --echo # Clean-up. let $restart_parameters = restart; --source include/restart_mysqld.inc DROP TABLES child, parent;