database/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-07 00:04:31 +03:00
Code Activity
Files
MDEV-36810
mariadb/mysql-test/suite/engines/funcs/r/tc_column_default_decimal.result
Alexander Barkov 36eba98817 MDEV-19123 Change default charset from latin1 to utf8mb4 
Changing the default server character set from latin1 to utf8mb4.
2024-07-11 10:21:07 +04:00

195 lines
4.8 KiB
Plaintext
Raw Permalink Blame History

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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_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_uca1400_ai_ci
DROP TABLE t13;
SHOW TABLES;
Tables_in_test
View Git Blame Copy Permalink