--- ../storage/innobase/mysql-test/storage_engine/tbl_opt_row_format.result~ 2017-05-24 00:40:12.854181048 +0300 +++ ../storage/innobase/mysql-test/storage_engine/tbl_opt_row_format.reject 2017-05-24 00:49:06.578191030 +0300 @@ -7,19 +7,39 @@ `b` char(8) DEFAULT NULL ) ENGINE= DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC ALTER TABLE t1 ROW_FORMAT=FIXED; +ERROR HY000: Table storage engine '' does not support the create option 'ROW_TYPE' +# ERROR: Statement ended with errno 1478, errname ER_ILLEGAL_HA_CREATE_OPTION (expected to succeed) +# ------------ UNEXPECTED RESULT ------------ +# [ ALTER TABLE t1 ROW_FORMAT=FIXED ] +# The statement|command finished with ER_ILLEGAL_HA_CREATE_OPTION. +# ALTER TABLE or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. +# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. +# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. +# Also, this problem may cause a chain effect (more errors of different kinds in the test). +# ------------------------------------------- SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED +) ENGINE= DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC ALTER TABLE t1 ROW_FORMAT=PAGE; +ERROR HY000: Table storage engine '' does not support the create option 'ROW_TYPE' +# ERROR: Statement ended with errno 1478, errname ER_ILLEGAL_HA_CREATE_OPTION (expected to succeed) +# ------------ UNEXPECTED RESULT ------------ +# [ ALTER TABLE t1 ROW_FORMAT=PAGE ] +# The statement|command finished with ER_ILLEGAL_HA_CREATE_OPTION. +# ALTER TABLE or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. +# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. +# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. +# Also, this problem may cause a chain effect (more errors of different kinds in the test). +# ------------------------------------------- SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 ROW_FORMAT=PAGE +) ENGINE= DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC ALTER TABLE t1 ROW_FORMAT=COMPACT; SHOW CREATE TABLE t1; Table Create Table