From 6820bf9ca9c5992a7e9d382aa8aaabff6751fd46 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Tue, 19 Jul 2016 11:18:58 +0200 Subject: do not quote numbers in the DEFAULT clause in SHOW CREATE --- mysql-test/suite/archive/archive.result | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/suite/archive') diff --git a/mysql-test/suite/archive/archive.result b/mysql-test/suite/archive/archive.result index d0ab319c4fa..603621abf2a 100644 --- a/mysql-test/suite/archive/archive.result +++ b/mysql-test/suite/archive/archive.result @@ -11136,8 +11136,8 @@ SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `auto` int(11) DEFAULT NULL, - `fld1` int(6) unsigned zerofill NOT NULL DEFAULT '000000', - `companynr` tinyint(2) unsigned zerofill NOT NULL DEFAULT '00', + `fld1` int(6) unsigned zerofill NOT NULL DEFAULT 000000, + `companynr` tinyint(2) unsigned zerofill NOT NULL DEFAULT 00, `fld3` char(30) NOT NULL DEFAULT '', `fld4` char(35) NOT NULL DEFAULT '', `fld5` char(35) NOT NULL DEFAULT '' -- cgit v1.2.1