diff options
Diffstat (limited to 'mysql-test/t')
| -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 5bb7e420e1c..54166c3b0dc 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -323,6 +323,13 @@ select * from t2; drop table t1, t2; +create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default '10',rel double default '3.14'); +insert into t1 values ('','',0,0.0); +describe t1; +create table t2 select default(str) as str, default(strnull) as strnull, default(intg) as intg, default(rel) as rel from t1; +describe t2; +drop table t1, t2; + # # Bug #1209 # |