diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_column_default_decimal.result')
| -rw-r--r-- | mysql-test/suite/engines/funcs/r/tc_column_default_decimal.result | 194 |
1 files changed, 194 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_column_default_decimal.result b/mysql-test/suite/engines/funcs/r/tc_column_default_decimal.result new file mode 100644 index 00000000000..8a70602c0cc --- /dev/null +++ b/mysql-test/suite/engines/funcs/r/tc_column_default_decimal.result @@ -0,0 +1,194 @@ +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 |