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 | 5 |
1 files changed, 5 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 2cde5818..78815e56 100644 --- a/mysql-test/suite/innodb/r/read_only_recovery.result +++ b/mysql-test/suite/innodb/r/read_only_recovery.result @@ -29,6 +29,9 @@ UPDATE t SET a=3 WHERE a=1; # Starting with MariaDB 10.2, innodb_read_only implies READ UNCOMMITTED. # In earlier versions, this would return the last committed version # (empty table)! +SHOW VARIABLES LIKE "innodb_read_only"; +Variable_name Value +innodb_read_only ON SELECT * FROM t; a 3 @@ -39,6 +42,8 @@ a SET GLOBAL innodb_max_purge_lag_wait=0; INSERT INTO mysql.innodb_index_stats SELECT * FROM mysql.innodb_index_stats LIMIT 0; +Test Temp tablespace truncate in read only mode +SET GLOBAL innodb_truncate_temporary_tablespace_now=1; # restart SELECT * FROM t; a |