-- source include/have_innodb.inc -- source include/have_example_key_management_plugin.inc # embedded does not support restart -- source include/not_embedded.inc --disable_query_log let $innodb_compression_algorithm_orig=`SELECT @@innodb_compression_algorithm`; let $innodb_file_format_orig = `SELECT @@innodb_file_format`; let $innodb_file_per_table_orig = `SELECT @@innodb_file_per_table`; --enable_query_log SET GLOBAL innodb_file_format = `Barracuda`; SET GLOBAL innodb_file_per_table = ON; # zlib set global innodb_compression_algorithm = 1; --replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ --error 1005 create table innodb_normal(c1 bigint not null, b char(200)) engine=innodb page_compressed=1; --replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ --error 1005 create table innodb_compact(c1 bigint not null, b char(200)) engine=innodb row_format=compact page_compressed=1; --replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ --error 1005 create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic page_compressed=1; # reset system --disable_query_log EVAL SET GLOBAL innodb_compression_algorithm = $innodb_compression_algorithm_orig; EVAL SET GLOBAL innodb_file_per_table = $innodb_file_per_table_orig; EVAL SET GLOBAL innodb_file_format = $innodb_file_format_orig; --enable_query_log