diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 23:27:24 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 23:27:24 +0200 |
| commit | 5f293dd694f9b1b4a0bdf73bb6ae80cda70f21d4 (patch) | |
| tree | 24dde5c436f3c2687619de02e4ab5f4f957ff789 /mysql-test/t/plugin.test | |
| parent | 7d3288129f6e5b52c7377ff68295f51606c7f002 (diff) | |
| download | mariadb-git-5f293dd694f9b1b4a0bdf73bb6ae80cda70f21d4.tar.gz | |
MDEV-4022 table attributes with sysvar as a default value
Diffstat (limited to 'mysql-test/t/plugin.test')
| -rw-r--r-- | mysql-test/t/plugin.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/plugin.test b/mysql-test/t/plugin.test index 71ca860e269..602b2e3c5c9 100644 --- a/mysql-test/t/plugin.test +++ b/mysql-test/t/plugin.test @@ -144,6 +144,7 @@ CREATE TABLE t1 (a int) ENGINE=example ULL=1e2; CREATE TABLE t1 (a int) ENGINE=example ULL=0x1234; SHOW CREATE TABLE t1; +SET example_varopt_default=33; # does not affect varopt of t1 select create_options from information_schema.tables where table_schema='test' and table_name='t1'; @@ -152,6 +153,16 @@ SHOW CREATE TABLE t1; DROP TABLE t1; +create table t1 (a int) engine=example; # varopt is 10 +show create table t1; +drop table t1; + +create table t1 (a int) engine=example varopt=15; +show create table t1; +alter table t1 varopt=default; +show create table t1; +drop table t1; + SET @@SQL_MODE=@OLD_SQL_MODE; # |