diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_buffer_pool_evict_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_buffer_pool_evict_basic.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_buffer_pool_evict_basic.result b/mysql-test/suite/sys_vars/r/innodb_buffer_pool_evict_basic.result index 1b8e7bf3a56..051bb0e321c 100644 --- a/mysql-test/suite/sys_vars/r/innodb_buffer_pool_evict_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_buffer_pool_evict_basic.result @@ -1,9 +1,15 @@ +SET @save_innodb_read_only_compressed=@@GLOBAL.innodb_read_only_compressed; SELECT @@global.innodb_buffer_pool_evict; @@global.innodb_buffer_pool_evict +SET GLOBAL innodb_read_only_compressed=ON; +CREATE TABLE t(a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED; +ERROR HY000: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE. +SET GLOBAL innodb_read_only_compressed=OFF; CREATE TABLE t(a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED; SET GLOBAL innodb_buffer_pool_evict = 'uncompressed'; SELECT @@global.innodb_buffer_pool_evict; @@global.innodb_buffer_pool_evict DROP TABLE t; +SET GLOBAL innodb_read_only_compressed=@save_innodb_read_only_compressed; |