diff options
| author | unknown <sergefp@mysql.com> | 2005-11-09 09:34:46 +0300 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-11-09 09:34:46 +0300 |
| commit | f76ff56512e1e10856816d6e5031f2b44df0990f (patch) | |
| tree | bcaf6d73461d1b6ce169106a660305b68eed4470 /mysql-test/t/create.test | |
| parent | 224e85536e04abe5bfb329e019fe519fbc57b434 (diff) | |
| download | mariadb-git-f76ff56512e1e10856816d6e5031f2b44df0990f.tar.gz | |
BUG#14480: post-fix: use the default field value from CREATE list too.
Diffstat (limited to 'mysql-test/t/create.test')
| -rw-r--r-- | mysql-test/t/create.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index 3bdc970027b..c9d16916f8a 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -594,6 +594,13 @@ create table t2 ( primary key (a1) ) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ; +# Test the default value +drop table t2; + +create table t2 ( a int default 3, b int default 3) + select a1,a2 from t1; +show create table t2; + drop table t1, t2; # End of 4.1 tests |