polardbxengine/mysql-test/suite/engines/funcs/r/tc_column_length_zero.result

50 lines
1.1 KiB
Plaintext

DROP TABLE IF EXISTS t6;
CREATE TABLE t6(c1 CHAR(0) NULL);
SHOW TABLES;
Tables_in_test
t6
SHOW CREATE TABLE t6;
Table Create Table
t6 CREATE TABLE `t6` (
`c1` char(0) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t6;
SHOW TABLES;
Tables_in_test
CREATE TABLE t6(c1 VARCHAR(0) NULL);
SHOW TABLES;
Tables_in_test
t6
SHOW CREATE TABLE t6;
Table Create Table
t6 CREATE TABLE `t6` (
`c1` varchar(0) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t6;
SHOW TABLES;
Tables_in_test
CREATE TABLE t6(c1 CHAR(0) NOT NULL);
SHOW TABLES;
Tables_in_test
t6
SHOW CREATE TABLE t6;
Table Create Table
t6 CREATE TABLE `t6` (
`c1` char(0) NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t6;
SHOW TABLES;
Tables_in_test
CREATE TABLE t6(c1 VARCHAR(0) NOT NULL);
SHOW TABLES;
Tables_in_test
t6
SHOW CREATE TABLE t6;
Table Create Table
t6 CREATE TABLE `t6` (
`c1` varchar(0) NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t6;
SHOW TABLES;
Tables_in_test