diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-07-19 11:18:58 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-08-27 16:59:11 +0200 |
| commit | 6820bf9ca9c5992a7e9d382aa8aaabff6751fd46 (patch) | |
| tree | e2fa1ce063ac1606712dd270c713246cdba37302 /mysql-test/r/subselect_no_mat.result | |
| parent | c5c9128af6f82d5ee13eedc040c5c7e8a902681b (diff) | |
| download | mariadb-git-6820bf9ca9c5992a7e9d382aa8aaabff6751fd46.tar.gz | |
do not quote numbers in the DEFAULT clause in SHOW CREATE
Diffstat (limited to 'mysql-test/r/subselect_no_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_no_mat.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/subselect_no_mat.result b/mysql-test/r/subselect_no_mat.result index a7170a9dc45..1eb33fc80e7 100644 --- a/mysql-test/r/subselect_no_mat.result +++ b/mysql-test/r/subselect_no_mat.result @@ -1239,24 +1239,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; |