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/r/create.result | |
| 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/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 0c3b7d5d5e7..a933027cdb1 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -697,4 +697,15 @@ a1 varchar(12) charset utf8 collate utf8_bin not null, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int, primary key (a1) ) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ; +drop table t2; +create table t2 ( a int default 3, b int default 3) +select a1,a2 from t1; +show create table t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `a` int(11) default '3', + `b` int(11) default '3', + `a1` int(11) default NULL, + `a2` int(11) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1, t2; |