diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2019-02-13 18:01:45 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-02-14 17:30:22 +0100 |
| commit | c0745e3730a28a1c22d7e6b250b93377efed90f2 (patch) | |
| tree | 82b6f748827d0ebbf3a3935cd08ed3f86a6f8133 /mysql-test/main/create_select_tmp.test | |
| parent | 1d8b5524f4a985c67a81742dbbbb8bbc8549d7ee (diff) | |
| download | mariadb-git-c0745e3730a28a1c22d7e6b250b93377efed90f2.tar.gz | |
bugfix: CREATE...SELECT lost COMMENT and VERSIONING
Diffstat (limited to 'mysql-test/main/create_select_tmp.test')
| -rw-r--r-- | mysql-test/main/create_select_tmp.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/main/create_select_tmp.test b/mysql-test/main/create_select_tmp.test index ef3315aed97..3ed885ea382 100644 --- a/mysql-test/main/create_select_tmp.test +++ b/mysql-test/main/create_select_tmp.test @@ -37,3 +37,17 @@ select * from t2; drop table t1; # End of 4.1 tests + +set sql_mode='ignore_bad_table_options'; +create table t1 ( + f1 int invisible, + f2 int comment 'a comment', + f3 int foo="bar", + f4 int check(f4 < 10), + f5 int without system versioning +) with system versioning as select 1 as f1,2 as f2,3 as f3,4 as f4,5 as f5; +show create table t1; +drop table t1; +set sql_mode=default; + +# End of 10.4 tests |