DROP TABLE IF EXISTS t12;
DROP TABLE IF EXISTS t13;
CREATE TABLE t12(c1 DECIMAL(5,0) NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 DECIMAL(5,4) NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 DEC(5,0) NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 DEC(5,4) NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 FIXED(5,0) NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 FIXED(5,4) NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 NUMERIC(5,0) NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 NUMERIC(5,4) NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 DECIMAL(5,0) NOT NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) NOT NULL DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 DECIMAL(5,4) NOT NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) NOT NULL DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 DEC(5,0) NOT NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) NOT NULL DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 DEC(5,4) NOT NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) NOT NULL DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 FIXED(5,0) NOT NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) NOT NULL DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 FIXED(5,4) NOT NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) NOT NULL DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
CREATE TABLE t12(c1 NUMERIC(5,0) NOT NULL DEFAULT 2);
SHOW TABLES;
Tables_in_test
t12
SHOW CREATE TABLE t12;
Table	Create Table
t12	CREATE TABLE `t12` (
  `c1` decimal(5,0) NOT NULL DEFAULT 2
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t12;
SHOW TABLES;
Tables_in_test
CREATE TABLE t13(c1 NUMERIC(5,4) NOT NULL DEFAULT 3.1234);
SHOW TABLES;
Tables_in_test
t13
SHOW CREATE TABLE t13;
Table	Create Table
t13	CREATE TABLE `t13` (
  `c1` decimal(5,4) NOT NULL DEFAULT 3.1234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t13;
SHOW TABLES;
Tables_in_test