Edit File: tc_column_default_decimal.result
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
Back to File Manager