diff options
Diffstat (limited to 'mysql-test/r/subselect_no_opts.result')
| -rw-r--r-- | mysql-test/r/subselect_no_opts.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/subselect_no_opts.result b/mysql-test/r/subselect_no_opts.result index 1e9749c2eb5..f65b505eeca 100644 --- a/mysql-test/r/subselect_no_opts.result +++ b/mysql-test/r/subselect_no_opts.result @@ -1235,24 +1235,24 @@ CREATE TABLE t1 SELECT * FROM (SELECT 1 as a,(SELECT 1)) a; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` int(1) NOT NULL DEFAULT '0', - `(SELECT 1)` int(1) NOT NULL DEFAULT '0' + `a` int(1) NOT NULL DEFAULT 0, + `(SELECT 1)` int(1) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; CREATE TABLE t1 SELECT * FROM (SELECT 1 as a,(SELECT a)) a; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` int(1) NOT NULL DEFAULT '0', - `(SELECT a)` int(1) NOT NULL DEFAULT '0' + `a` int(1) NOT NULL DEFAULT 0, + `(SELECT a)` int(1) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; CREATE TABLE t1 SELECT * FROM (SELECT 1 as a,(SELECT a+0)) a; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` int(1) NOT NULL DEFAULT '0', - `(SELECT a+0)` int(3) NOT NULL DEFAULT '0' + `a` int(1) NOT NULL DEFAULT 0, + `(SELECT a+0)` int(3) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; CREATE TABLE t1 SELECT (SELECT 1 as a UNION SELECT 1+1 limit 1,1) as a; |