# # Basic CREATE TABLE statements # --source have_engine.inc --disable_warnings DROP TABLE IF EXISTS t1,t2; --enable_warnings # Simple create table with minimal table options # which are defined in have_engine.inc # (default empty) plus ENGINE= --let $create_definition = a $int_col --source create_table.inc if ($mysql_errname) { --let $functionality = CREATE TABLE --source unexpected_result.inc } if (!$mysql_errname) { --source mask_engine.inc SHOW CREATE TABLE t1; # IF NOT EXISTS --let $if_not_exists = 1 --let $create_definition = a $int_col --source create_table.inc } # CREATE .. LIKE CREATE TABLE t2 LIKE t1; if ($mysql_errname) { --let $functionality = CREATE TABLE .. LIKE --source unexpected_result.inc } if (!$mysql_errname) { --source mask_engine.inc SHOW CREATE TABLE t2; eval CREATE TEMPORARY TABLE t2 LIKE t1; if ($mysql_errname) { --let $functionality = Temporary tables --source unexpected_result.inc } if (!$mysql_errname) { --source mask_engine.inc SHOW CREATE TABLE t2; DROP TEMPORARY TABLE t2; } DROP TABLE t2; } DROP TABLE IF EXISTS t1; # CREATE .. AS SELECT --let $as_select = SELECT 1 UNION SELECT 2 --source create_table.inc if ($mysql_errname) { --let $functionality = CREATE TABLE .. AS SELECT --source unexpected_result.inc } if (!$mysql_errname) { --source mask_engine.inc SHOW CREATE TABLE t1; --sorted_result SELECT * FROM t1; DROP TABLE t1; } # Use the engine as default --source mask_engine.inc eval SET storage_engine = $storage_engine; --let $tbl_opts = $default_tbl_opts --let $create_definition = a $int_col --source create_table.inc if ($mysql_errname) { --let $functionality = CREATE TABLE or using the engine as default --source unexpected_result.inc } if (!$mysql_errname) { --source mask_engine.inc SHOW CREATE TABLE t1; } # Just to add FLUSH LOGS into the mix while we are in the most common test FLUSH LOGS; DROP TABLE IF EXISTS t1; --source cleanup_engine.inc