diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/read_only_recovery.result')
-rw-r--r-- | mysql-test/suite/innodb/r/read_only_recovery.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/read_only_recovery.result b/mysql-test/suite/innodb/r/read_only_recovery.result index e639e8abacc..e83bf66432e 100644 --- a/mysql-test/suite/innodb/r/read_only_recovery.result +++ b/mysql-test/suite/innodb/r/read_only_recovery.result @@ -14,6 +14,7 @@ SET GLOBAL innodb_flush_log_at_trx_commit=1; BEGIN; INSERT INTO t VALUES(0); ROLLBACK; +# restart: --innodb-force-recovery=3 disconnect con1; SELECT * FROM t; a @@ -23,6 +24,7 @@ SELECT * FROM t; a 1 UPDATE t SET a=3 WHERE a=1; +# restart: --innodb-read-only # Starting with MariaDB 10.2, innodb_read_only implies READ UNCOMMITTED. # In earlier versions, this would return the last committed version # (empty table)! @@ -33,6 +35,7 @@ SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT * FROM t; a 3 +# restart SELECT * FROM t; a 3 |