diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
commit | 06eaf7232e9a920468c0f8d74dcf2fe8b555501c (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/storage_engine/tbl_standard_opts.test | |
parent | Initial commit. (diff) | |
download | mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.tar.xz mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/storage_engine/tbl_standard_opts.test')
-rw-r--r-- | mysql-test/suite/storage_engine/tbl_standard_opts.test | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/tbl_standard_opts.test b/mysql-test/suite/storage_engine/tbl_standard_opts.test new file mode 100644 index 00000000..7e723788 --- /dev/null +++ b/mysql-test/suite/storage_engine/tbl_standard_opts.test @@ -0,0 +1,60 @@ +# +# Standard options in CREATE and ALTER TABLE +# +# Note: the test does not check whether the options +# have any real effect on the table, only +# that they are accepted +# + +--source have_engine.inc + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +# Create table with standard options + +let $table_options = + DEFAULT CHARACTER SET = utf8 + COLLATE = utf8_general_ci + COMMENT = 'standard table options' +; +--source create_table.inc +--source mask_engine.inc +SHOW CREATE TABLE t1; + + +# Alter comment + +--let $alter_definition = COMMENT = 'table altered' +--source alter_table.inc +if ($mysql_errname) +{ + --let $my_last_stmt = $alter_statement + --let $functionality = ALTER TABLE + --source unexpected_result.inc +} +--source mask_engine.inc +SHOW CREATE TABLE t1; + +# Alter ENGINE value + +--let $alter_definition = ENGINE=MEMORY +--source alter_table.inc +SHOW CREATE TABLE t1; +--let $alter_definition = ENGINE=$storage_engine +--source alter_table.inc +--source mask_engine.inc +SHOW CREATE TABLE t1; + +# Alter character set and collation + +--let $alter_definition = CHARACTER SET = latin1 COLLATE = latin1_swedish_ci +--source alter_table.inc +--source mask_engine.inc +SHOW CREATE TABLE t1; + +DROP TABLE t1; + +--source cleanup_engine.inc + |