Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_ai.test

raw
1 #
2 # Check whether AUTO_INCREMENT 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;
14 --enable_warnings
15
16 --let $create_definition = a $int_col
17 --let $table_options = AUTO_INCREMENT=10
18 --source create_table.inc
19 --source mask_engine.inc
20 SHOW CREATE TABLE t1;
21
22 --let $alter_definition = AUTO_INCREMENT=100
23 --source alter_table.inc
24 if ($mysql_errname)
25 {
26 --let $functionality = ALTER TABLE
27 --source unexpected_result.inc
28 }
29 --source mask_engine.inc
30 SHOW CREATE TABLE t1;
31
32 DROP TABLE t1;
33
34 --source cleanup_engine.inc
35