EVOLUTION-MANAGER

Edit File: tbl_opt_union.test

# # Check whether UNION 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, child1, child2; --enable_warnings --disable_query_log eval CREATE TABLE child1 (a $int_col) ENGINE=MyISAM; eval CREATE TABLE child2 (a $int_col) ENGINE=MyISAM; --enable_query_log --let $table_options = UNION(child1) --let $create_definition = a $int_col --source create_table.inc --source mask_engine.inc SHOW CREATE TABLE t1; --let $alter_definition = UNION = (child1,child2) --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, child1, child2; --source cleanup_engine.inc