Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_password.test

raw
1 #
2 # Check whether PASSWORD 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 # This option is not supported by any known engines,
10 # that's why the result file does not contain it;
11 # but it's syntactically acceptable.
12 #
13
14
15 --source have_engine.inc
16
17 --disable_warnings
18 DROP TABLE IF EXISTS t1;
19 --enable_warnings
20
21 --let $table_options = PASSWORD='password'
22 --source create_table.inc
23 --source mask_engine.inc
24 SHOW CREATE TABLE t1;
25
26 --let $alter_definition = PASSWORD='new_password'
27 --source alter_table.inc
28 if ($mysql_errname)
29 {
30 --let $my_last_stmt = $alter_statement
31 --let $functionality = ALTER TABLE
32 --source unexpected_result.inc
33 }
34 --source mask_engine.inc
35 SHOW CREATE TABLE t1;
36
37 DROP TABLE t1;
38
39 --source cleanup_engine.inc
40