diff options
| author | vva@eagle.mysql.r18.ru <> | 2003-12-09 13:34:57 -0400 |
|---|---|---|
| committer | vva@eagle.mysql.r18.ru <> | 2003-12-09 13:34:57 -0400 |
| commit | 17330df85fb02ababb61dad1d29a3a51c17fdd29 (patch) | |
| tree | fe11c6fb8677734a353d4270de5e1bacc7875fb6 /mysql-test/t/create.test | |
| parent | 9aa12e25f1eb05f2bc18bf29e098a79297aeef8a (diff) | |
| parent | 9c7b1cf8ead8e00a8549445e377b4c6ab815fa8b (diff) | |
| download | mariadb-git-17330df85fb02ababb61dad1d29a3a51c17fdd29.tar.gz | |
Merge
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 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 # |