Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_union.test

raw
1 #
2 # Check whether UNION option
3 # is supported in CREATE and ALTER TABLE
4 #
5 # Note: the test does not check whether the option
6 # has any real effect on the table, only
7 # that it's accepted
8 #
9
10 --source have_engine.inc
11
12 --disable_warnings
13 DROP TABLE IF EXISTS t1, child1, child2;
14 --enable_warnings
15
16 --disable_query_log
17 eval CREATE TABLE child1 (a $int_col) ENGINE=MyISAM;
18 eval CREATE TABLE child2 (a $int_col) ENGINE=MyISAM;
19 --enable_query_log
20
21 --let $table_options = UNION(child1)
22 --let $create_definition = a $int_col
23 --source create_table.inc
24 --source mask_engine.inc
25 SHOW CREATE TABLE t1;
26
27 --let $alter_definition = UNION = (child1,child2)
28 --source alter_table.inc
29 if ($mysql_errname)
30 {
31 --let $my_last_stmt = $alter_statement
32 --let $functionality = ALTER TABLE
33 --source unexpected_result.inc
34 }
35 --source mask_engine.inc
36 SHOW CREATE TABLE t1;
37
38 DROP TABLE t1, child1, child2;
39
40 --source cleanup_engine.inc
41