Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_avg_row_length.test

raw
1 #
2 # Check whether AVG_ROW_LENGTH 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 $table_options = AVG_ROW_LENGTH=300
17 --source create_table.inc
18
19 --source mask_engine.inc
20 SHOW CREATE TABLE t1;
21
22 --let $alter_definition = AVG_ROW_LENGTH=30000000
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