polardbxengine/mysql-test/suite/engines/funcs/r/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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t13;
SHOW TABLES;
Tables_in_test