diff options
Diffstat (limited to 'mysql-test/suite/storage_engine/tbl_opt_union.test')
-rw-r--r-- | mysql-test/suite/storage_engine/tbl_opt_union.test | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/tbl_opt_union.test b/mysql-test/suite/storage_engine/tbl_opt_union.test new file mode 100644 index 00000000000..fa134ab8344 --- /dev/null +++ b/mysql-test/suite/storage_engine/tbl_opt_union.test @@ -0,0 +1,41 @@ +# +# 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 + |