information_schema.statistics.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
statistics |
||||||||
cardinality |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | |||
collation |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(1) NULL:
| unsupported | unsupported | |||
column_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(21) NULL:
| unsupported | unsupported | |||
comment |
VARCHAR NOT NULL:
8
VARCHAR NULL:
5.7
| NULL:
| VARCHAR(16) NULL:
| unsupported | unsupported | unsupported | ||
direction |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
expression |
LONGTEXT NULL:
8
| unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
ignored |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
implicit |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
index_comment |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
index_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | |||
index_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | |||
index_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(16) NULL:
| unsupported | unsupported | unsupported | ||
is_visible |
VARCHAR NOT NULL:
8
| unsupported | VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
non_unique |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| VARCHAR(1) NULL:
| unsupported | unsupported | |||
nullable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
packed |
BINARY NULL:
5.7-8
| NULL:
| VARCHAR(10) NULL:
| unsupported | unsupported | unsupported | ||
seq_in_index |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(2) NULL:
| unsupported | unsupported | |||
storing |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
sub_part |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(3) NULL:
| unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| unsupported | unsupported | |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | |||