information_schema.partitions.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
partitions |
||||||||
avg_row_length |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
check_time |
DATETIME NULL:
5.7-8
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
checksum |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
create_time |
TIMESTAMP NOT NULL:
8
DATETIME NULL:
5.7
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
data_free |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
data_length |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_length |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
max_data_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
nodegroup |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(12) NULL:
| unsupported | unsupported | unsupported | ||
partition_comment |
TEXT NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(80) NULL:
| unsupported | unsupported | unsupported | ||
partition_description |
LONGTEXT NULL:
5.7-8
| NULL:
| LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
partition_expression |
LONGTEXT NULL:
5.7-8
| NULL:
| LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
partition_method |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(18) NULL:
| unsupported | unsupported | unsupported | ||
partition_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
partition_ordinal_position |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
subpartition_expression |
LONGTEXT NULL:
5.7-8
| NULL:
| LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
subpartition_method |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(12) NULL:
| unsupported | unsupported | unsupported | ||
subpartition_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
subpartition_ordinal_position |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_rows |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
tablespace_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
update_time |
DATETIME NULL:
5.7-8
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||