# # Check whether KEY_BLOCK_SIZE option # is supported in CREATE and ALTER TABLE # # Note: the test does not check whether the option # has any real effect on the table, only # that it's accepted # --source have_engine.inc --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings --let $table_options = KEY_BLOCK_SIZE=8 --source create_table.inc --source mask_engine.inc SHOW CREATE TABLE t1; --let $alter_definition = KEY_BLOCK_SIZE=1 --source alter_table.inc if ($mysql_errname) { --let $my_last_stmt = $alter_statement --let $functionality = ALTER TABLE --source unexpected_result.inc } --source mask_engine.inc SHOW CREATE TABLE t1; DROP TABLE t1; --source cleanup_engine.inc