information_schema.*.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
_pg_foreign_data_wrappers |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
fdwoptions |
unsupported | unsupported | unsupported | ARRAY NULL:
10-15
| unsupported | unsupported | ||
fdwowner |
unsupported | unsupported | unsupported | OID NULL:
10-15
| unsupported | unsupported | ||
foreign_data_wrapper_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_data_wrapper_language |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
10-15
| unsupported | unsupported | ||
foreign_data_wrapper_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
oid |
unsupported | unsupported | unsupported | OID NULL:
10-15
| unsupported | unsupported | ||
_pg_foreign_servers |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_data_wrapper_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_data_wrapper_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_type |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
10-15
| unsupported | unsupported | ||
foreign_server_version |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
10-15
| unsupported | unsupported | ||
oid |
unsupported | unsupported | unsupported | OID NULL:
10-15
| unsupported | unsupported | ||
srvoptions |
unsupported | unsupported | unsupported | ARRAY NULL:
10-15
| unsupported | unsupported | ||
_pg_foreign_table_columns |
||||||||
attfdwoptions |
unsupported | unsupported | unsupported | ARRAY NULL:
10-15
| unsupported | unsupported | ||
attname |
unsupported | unsupported | unsupported | NAME NULL:
10-15
| unsupported | unsupported | ||
nspname |
unsupported | unsupported | unsupported | NAME NULL:
10-15
| unsupported | unsupported | ||
relname |
unsupported | unsupported | unsupported | NAME NULL:
10-15
| unsupported | unsupported | ||
_pg_foreign_tables |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
ftoptions |
unsupported | unsupported | unsupported | ARRAY NULL:
10-15
| unsupported | unsupported | ||
_pg_user_mappings |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
oid |
unsupported | unsupported | unsupported | OID NULL:
10-15
| unsupported | unsupported | ||
srvowner |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
10-15
| unsupported | unsupported | ||
umoptions |
unsupported | unsupported | unsupported | ARRAY NULL:
10-15
| unsupported | unsupported | ||
umuser |
unsupported | unsupported | unsupported | OID NULL:
10-15
| unsupported | unsupported | ||
administrable_role_authorizations |
||||||||
grantee |
VARCHAR NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
grantee_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_default |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_mandatory |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_name |
VARCHAR NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
user |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
all_plugins |
||||||||
load_option |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_auth_version |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_author |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_description |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_library |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_library_version |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_license |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_maturity |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_name |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_status |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_type |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_type_version |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_version |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
analyze_status |
||||||||
job_info |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
partition_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
processed_rows |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
start_time |
unsupported | unsupported | DATETIME NULL:
| unsupported | unsupported | unsupported | ||
state |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
applicable_roles |
||||||||
grantee |
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
grantee_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantee_type |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_default |
VARCHAR NULL:
8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_mandatory |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_name |
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
user |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
attributes |
||||||||
attribute_default |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
attribute_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
attribute_udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
attribute_udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
attribute_udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_maximum_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_octet_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
datetime_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
interval_precision |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
is_derived_reference_attribute |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_nullable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
ordinal_position |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_sets |
||||||||
character_repertoire |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
character_set_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
default_collate_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
default_collate_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
default_collate_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
description |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(60) NULL:
| unsupported | unsupported | unsupported | ||
form_of_use |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
maxlen |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(3) NULL:
| unsupported | unsupported | unsupported | ||
check_constraint_routine_usage |
||||||||
constraint_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
constraint_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
constraint_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
check_constraints |
||||||||
check_clause |
LONGTEXT NOT NULL:
8
| LONGTEXT NOT NULL:
10.2-10.7
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NVARCHAR(4000) NULL:
| |||
constraint_catalog |
VARCHAR NOT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_name |
VARCHAR NOT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
constraint_schema |
VARCHAR NOT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
level |
unsupported | VARCHAR NOT NULL:
10.5-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
client_statistics |
||||||||
access_denied |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
binlog_bytes_written |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
busy_time |
unsupported | DOUBLE NOT NULL:
DOUBLE NULL:
| unsupported | unsupported | unsupported | unsupported | ||
bytes_received |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
bytes_sent |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
client |
unsupported | VARCHAR(64) NOT NULL:
VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
commit_transactions |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
concurrent_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
connected_time |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
cpu_time |
unsupported | DOUBLE NOT NULL:
DOUBLE NULL:
| unsupported | unsupported | unsupported | unsupported | ||
denied_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
empty_queries |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
lost_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_statement_time_exceeded |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
other_commands |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rollback_transactions |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_deleted |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_inserted |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_read |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_sent |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_updated |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
select_commands |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total_ssl_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
update_commands |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
cluster_config |
||||||||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
key |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
value |
unsupported | unsupported | VARCHAR(128) NULL:
| unsupported | unsupported | unsupported | ||
cluster_deadlocks |
||||||||
current_sql_digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
current_sql_digest_text |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
deadlock_id |
unsupported | unsupported | BIGINT(21) NOT NULL:
| unsupported | unsupported | unsupported | ||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
key |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
key_info |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
occur_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
retryable |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
trx_holding_lock |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
try_lock_trx_id |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
cluster_info |
||||||||
git_hash |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
start_time |
unsupported | unsupported | VARCHAR(32) NULL:
| unsupported | unsupported | unsupported | ||
status_address |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
uptime |
unsupported | unsupported | VARCHAR(32) NULL:
| unsupported | unsupported | unsupported | ||
version |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cluster_load |
||||||||
device_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
device_type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
name |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
value |
unsupported | unsupported | VARCHAR(128) NULL:
| unsupported | unsupported | unsupported | ||
cluster_log |
||||||||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
level |
unsupported | unsupported | VARCHAR(8) NULL:
| unsupported | unsupported | unsupported | ||
message |
unsupported | unsupported | VAR_STRING(1024) NULL:
| unsupported | unsupported | unsupported | ||
time |
unsupported | unsupported | VARCHAR(32) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cluster_systeminfo |
||||||||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
name |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
system_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
system_type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
value |
unsupported | unsupported | VARCHAR(128) NULL:
| unsupported | unsupported | unsupported | ||
cluster_tidb_trx |
||||||||
all_sql_digests |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
current_sql_digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
current_sql_digest_text |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
db |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
id |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
mem_buffer_bytes |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
mem_buffer_keys |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
session_id |
unsupported | unsupported | BIGINT(21) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
start_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
state |
unsupported | unsupported | ENUM('IDLE','RUNNING','LOCKWAITING','COMMITTING','ROLLINGBACK') NULL:
ENUM('NORMAL','LOCKWAITING','COMMITTING','ROLLINGBACK') NULL:
| unsupported | unsupported | unsupported | ||
user |
unsupported | unsupported | VARCHAR(16) NULL:
| unsupported | unsupported | unsupported | ||
waiting_start_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
collation_character_set_applicability |
||||||||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
character_set_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
collation_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
collations |
||||||||
character_set_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NULL:
| unsupported | unsupported | unsupported | ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
collation_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(11) NULL:
| unsupported | unsupported | unsupported | ||
is_compiled |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
is_default |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
pad_attribute |
ENUM NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
sortlen |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(3) NULL:
| unsupported | unsupported | unsupported | ||
column_column_usage |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
dependent_column |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
column_domain_usage |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
domain_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
domain_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
domain_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
column_options |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
column_privileges |
||||||||
column_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
grantee |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
is_grantable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(3) NULL:
| |||
privilege_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(10) NULL:
| |||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
column_statistics |
||||||||
column_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
histogram |
JSON NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
schema_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
column_udt_usage |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
columns |
||||||||
character_maximum_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| INT NULL:
| |||
character_octet_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| INT NULL:
| |||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
character_set_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(32) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
collation_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(32) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
column_comment |
TEXT NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(1024) NULL:
| unsupported | unsupported | |||
column_default |
LONGTEXT NULL:
5.7-8
| NULL:
| TEXT NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| NVARCHAR(4000) NULL:
| |||
column_key |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
column_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
column_type |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| TEXT NULL:
| unsupported | unsupported | unsupported | ||
crdb_sql_type |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
data_type |
VARCHAR NOT NULL:
5.7
LONGTEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| NVARCHAR(128) NULL:
| |||
datetime_precision |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| SMALLINT NULL:
| |||
domain_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
domain_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
domain_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
extra |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(30) NULL:
| unsupported | unsupported | unsupported | ||
generation_expression |
LONGTEXT NOT NULL:
5.7-8
| NULL:
| TEXT NOT NULL:
| CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | |||
identity_cycle |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
identity_generation |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
identity_increment |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
identity_maximum |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
identity_minimum |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
identity_start |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
interval_precision |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
is_generated |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | |||
is_hidden |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
is_identity |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_nullable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(3) NULL:
| |||
is_self_referencing |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_updatable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
numeric_precision |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| TINYINT NULL:
| |||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| SMALLINT NULL:
| |||
numeric_scale |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| INT NULL:
| |||
ordinal_position |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(64) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| INT NULL:
| |||
privileges |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(80) NULL:
| unsupported | unsupported | unsupported | ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
srs_id |
INT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
columns_extensions |
||||||||
column_name |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
secondary_engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
constraint_column_usage |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_table_usage |
||||||||
constraint_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
constraint_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
constraint_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
data_lock_waits |
||||||||
current_holding_trx_id |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
key |
unsupported | unsupported | TEXT NOT NULL:
VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
key_info |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
sql_digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
sql_digest_text |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
trx_id |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
data_type_privileges |
||||||||
dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
ddl_jobs |
||||||||
db_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
end_time |
unsupported | unsupported | DATETIME NULL:
| unsupported | unsupported | unsupported | ||
job_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
job_type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
query |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
row_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
schema_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
schema_state |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
start_time |
unsupported | unsupported | DATETIME NULL:
| unsupported | unsupported | unsupported | ||
state |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
deadlocks |
||||||||
current_sql_digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
current_sql_digest_text |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
deadlock_id |
unsupported | unsupported | BIGINT(21) NOT NULL:
| unsupported | unsupported | unsupported | ||
key |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
key_info |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
occur_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
retryable |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
trx_holding_lock |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
try_lock_trx_id |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
disks |
||||||||
available |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
disk |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
path |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
used |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
domain_constraints |
||||||||
constraint_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
constraint_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
constraint_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
domain_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
domain_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
domain_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
initially_deferred |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | VARCHAR(2) NULL:
| ||
is_deferrable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | VARCHAR(2) NULL:
| ||
domain_udt_usage |
||||||||
domain_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
domain_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
domain_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
domains |
||||||||
character_maximum_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | INT NULL:
| ||
character_octet_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | INT NULL:
| ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(6) NULL:
| ||
character_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(3) NULL:
| ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(6) NULL:
| ||
collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(3) NULL:
| ||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | SYSNAME NULL:
| ||
datetime_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | SMALLINT NULL:
| ||
domain_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
domain_default |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | NVARCHAR(4000) NULL:
| ||
domain_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
domain_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
interval_precision |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | TINYINT NULL:
| ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | SMALLINT NULL:
| ||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | TINYINT NULL:
| ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
element_types |
||||||||
array_type_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
character_maximum_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_octet_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collection_type_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
datetime_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
domain_default |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
object_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
enabled_roles |
||||||||
is_default |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_mandatory |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_name |
VARCHAR NULL:
8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
engines |
||||||||
comment |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(80) NULL:
| unsupported | unsupported | unsupported | ||
engine |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
savepoints |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
support |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(8) NULL:
| unsupported | unsupported | unsupported | ||
transactions |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
xa |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | unsupported | ||
events |
||||||||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
created |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
database_collation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
definer |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
ends |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_body |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_comment |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_definition |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
execute_at |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
interval_field |
ENUM NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
interval_value |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
last_altered |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
last_executed |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
on_completion |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
originator |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_mode |
SET NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
starts |
DATETIME NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
status |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
time_zone |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
feedback |
||||||||
variable_name |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
files |
||||||||
autoextend_size |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
avg_row_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
check_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
checksum |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
create_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
creation_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_free |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
deleted_rows |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
engine |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
extent_size |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
extra |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_id |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_name |
TEXT NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_type |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
free_extents |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fulltext_keys |
BINARY NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
initial_size |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
last_access_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
last_update_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
logfile_group_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
logfile_group_number |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
max_data_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
maximum_size |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
recover_time |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
status |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_catalog |
CHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
BINARY NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_rows |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_schema |
BINARY NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
tablespace_name |
VARCHAR NOT NULL:
8
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
total_extents |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
transaction_counter |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
update_count |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
update_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
version |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
foreign_data_wrapper_options |
||||||||
foreign_data_wrapper_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_data_wrapper_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_data_wrappers |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_data_wrapper_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_data_wrapper_language |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_data_wrapper_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
library_name |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_server_options |
||||||||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_servers |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_data_wrapper_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_data_wrapper_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_server_version |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_table_options |
||||||||
foreign_table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
foreign_tables |
||||||||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
geometry_columns |
||||||||
coord_dimension |
unsupported | TINYINT(2) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
f_geometry_column |
unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
f_table_catalog |
unsupported | VARCHAR(512) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
f_table_name |
unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
f_table_schema |
unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
g_geometry_column |
unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
g_table_catalog |
unsupported | VARCHAR(512) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
g_table_name |
unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
g_table_schema |
unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
geometry_type |
unsupported | INT(7) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_ppr |
unsupported | TINYINT(2) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
srid |
unsupported | SMALLINT(5) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
storage_type |
unsupported | TINYINT(2) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
global_status |
||||||||
variable_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
variable_value |
VARCHAR NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
global_variables |
||||||||
variable_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
variable_value |
VARCHAR NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_statistics |
||||||||
index_name |
unsupported | VARCHAR(192) NOT NULL:
VARCHAR(192) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_read |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
unsupported | VARCHAR(192) NOT NULL:
VARCHAR(192) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_schema |
unsupported | VARCHAR(192) NOT NULL:
VARCHAR(192) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
information_schema_catalog_name |
||||||||
catalog_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
innodb_buffer_page |
||||||||
access_time |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
block_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compressed_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fix_count |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
flush_type |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
free_page_clock |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
io_fix |
VARCHAR NULL:
5.7-8
| ENUM NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_hashed |
VARCHAR NULL:
5.7-8
| INT NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_old |
VARCHAR NULL:
5.7-8
| INT NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_stale |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
newest_modification |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_records |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
oldest_modification |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_number |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_state |
VARCHAR NULL:
5.7-8
| ENUM NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
page_type |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pool_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_buffer_page_lru |
||||||||
access_time |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compressed |
VARCHAR NULL:
5.7-8
| INT NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
compressed_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fix_count |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
flush_type |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
free_page_clock |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
io_fix |
VARCHAR NULL:
5.7-8
| ENUM NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_hashed |
VARCHAR NULL:
5.7-8
| INT NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_old |
VARCHAR NULL:
5.7-8
| INT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lru_position |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
newest_modification |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_records |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
oldest_modification |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_number |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_type |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pool_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_buffer_pool_stats |
||||||||
database_pages |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
free_buffers |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
hit_rate |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lru_io_current |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lru_io_total |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
modified_database_pages |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
not_young_make_per_thousand_gets |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_pages_created |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_pages_get |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_pages_read |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_pages_read_ahead |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_pages_written |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_read_ahead_evicted |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
old_database_pages |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_create_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_made_not_young_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_made_young |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_made_young_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_not_made_young |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_read_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_written_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pending_decompress |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pending_flush_list |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pending_flush_lru |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pending_reads |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pool_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pool_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
read_ahead_evicted_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
read_ahead_rate |
DOUBLE NOT NULL:
5.7-8
| DOUBLE NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_current |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_total |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
young_make_per_thousand_gets |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_cached_indexes |
||||||||
index_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
n_cached_pages |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space_id |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_cmp |
||||||||
compress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_ops_ok |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_cmp_per_index |
||||||||
compress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_ops_ok |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
database_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_cmp_per_index_reset |
||||||||
compress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_ops_ok |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
database_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_cmp_reset |
||||||||
compress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_ops_ok |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_ops |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
uncompress_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_cmpmem |
||||||||
buffer_pool_instance |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_free |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_used |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
relocation_ops |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
relocation_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_cmpmem_reset |
||||||||
buffer_pool_instance |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_free |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pages_used |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
relocation_ops |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
relocation_time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_columns |
||||||||
default_value |
TEXT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
has_default |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
len |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
mtype |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
pos |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
prtype |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_datafiles |
||||||||
path |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
VARBINARY NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_fields |
||||||||
index_id |
VARBINARY NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
pos |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_foreign |
||||||||
for_name |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
id |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
n_cols |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
ref_name |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
type |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_foreign_cols |
||||||||
for_col_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
id |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
pos |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
ref_col_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_ft_being_deleted |
||||||||
doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_ft_config |
||||||||
key |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
value |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_ft_default_stopword |
||||||||
value |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_ft_deleted |
||||||||
doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_ft_index_cache |
||||||||
doc_count |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
first_doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
last_doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
position |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
word |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_ft_index_table |
||||||||
doc_count |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
first_doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
last_doc_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
position |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
word |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_indexes |
||||||||
index_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
merge_threshold |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
n_fields |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
page_no |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
type |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_lock_waits |
||||||||
blocking_lock_id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
blocking_trx_id |
VARCHAR NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
requested_lock_id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
requesting_trx_id |
VARCHAR NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_locks |
||||||||
lock_data |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_index |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_mode |
VARCHAR NOT NULL:
5.7
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_page |
BIGINT NULL:
5.7
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_rec |
BIGINT NULL:
5.7
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_space |
BIGINT NULL:
5.7
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_table |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_trx_id |
VARCHAR NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_type |
VARCHAR NOT NULL:
5.7
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_metrics |
||||||||
avg_count |
DOUBLE NULL:
5.7-8
| DOUBLE NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
avg_count_reset |
DOUBLE NULL:
5.7-8
| DOUBLE NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
comment |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
count |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
count_reset |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
enabled |
unsupported | INT NOT NULL:
10.5-10.7
| unsupported | unsupported | unsupported | unsupported | ||
max_count |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
max_count_reset |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
min_count |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
min_count_reset |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
status |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
subsystem |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
time_disabled |
DATETIME NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
time_elapsed |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
time_enabled |
DATETIME NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
time_reset |
DATETIME NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
type |
VARCHAR NOT NULL:
5.7-8
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_mutexes |
||||||||
create_file |
unsupported | VARCHAR NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
create_line |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
name |
unsupported | VARCHAR NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
os_waits |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
innodb_session_temp_tablespaces |
||||||||
id |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
path |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
purpose |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
size |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
state |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_columns |
||||||||
len |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
mtype |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pos |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
prtype |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_datafiles |
||||||||
path |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_fields |
||||||||
index_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pos |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_foreign |
||||||||
for_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
n_cols |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
ref_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
type |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_foreign_cols |
||||||||
for_col_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pos |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
ref_col_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_indexes |
||||||||
index_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
merge_threshold |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
n_fields |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_no |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
type |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_semaphore_waits |
||||||||
created_file |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
created_line |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
file |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
holder_file |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
holder_line |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
holder_thread_id |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
last_reader_file |
unsupported | VARCHAR NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
last_reader_line |
unsupported | INT NOT NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
last_writer_file |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
last_writer_line |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
line |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
lock_word |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
object_name |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
os_wait_count |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
readers |
unsupported | INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
reservation_mode |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
thread_id |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
wait_object |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
wait_time |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
wait_type |
unsupported | VARCHAR NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
waiters_flag |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
writer_thread |
unsupported | BIGINT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_tables |
||||||||
file_format |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
flag |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
n_cols |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
5.7
| ENUM NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NULL:
5.7
| ENUM NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
zip_page_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_tablespaces |
||||||||
allocated_size |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_format |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
file_size |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
filename |
unsupported | VARCHAR NOT NULL:
10.6-10.7
| unsupported | unsupported | unsupported | unsupported | ||
flag |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fs_block_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
zip_page_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_tablestats |
||||||||
autoinc |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
clust_index_size |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
modified_counter |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
num_rows |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
other_index_size |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
ref_count |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
stats_initialized |
VARCHAR NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_sys_virtual |
||||||||
base_pos |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pos |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_tables |
||||||||
flag |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
instant_cols |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
n_cols |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
zip_page_size |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_tablespaces |
||||||||
allocated_size |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
autoextend_size |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
encryption |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
file_size |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
flag |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
fs_block_size |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
server_version |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space_version |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
state |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
zip_page_size |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_tablespaces_brief |
||||||||
flag |
VARBINARY NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
path |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
VARBINARY NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_tablespaces_encryption |
||||||||
current_key_id |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
current_key_version |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
encryption_scheme |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
key_rotation_max_page_number |
unsupported | BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
key_rotation_page_number |
unsupported | BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
keyserver_requests |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
min_key_version |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
unsupported | VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
rotating_or_flushing |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
unsupported | INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_tablespaces_scrubbing |
||||||||
compressed |
unsupported | INT NOT NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
current_scrub_active_threads |
unsupported | INT NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
current_scrub_max_page_number |
unsupported | BIGINT NOT NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
current_scrub_page_number |
unsupported | BIGINT NOT NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
current_scrub_started |
unsupported | DATETIME NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
last_scrub_completed |
unsupported | DATETIME NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
name |
unsupported | VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
on_ssd |
unsupported | INT NOT NULL:
10.4
| unsupported | unsupported | unsupported | unsupported | ||
space |
unsupported | BIGINT NOT NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
innodb_tablestats |
||||||||
autoinc |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
clust_index_size |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
modified_counter |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
num_rows |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
other_index_size |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
ref_count |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
stats_initialized |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_temp_table_info |
||||||||
is_compressed |
VARCHAR NULL:
5.7
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
n_cols |
INT NOT NULL:
5.7-8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NULL:
5.7-8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
per_table_tablespace |
VARCHAR NULL:
5.7
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7-8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7-8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
innodb_trx |
||||||||
trx_adaptive_hash_latched |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
trx_adaptive_hash_timeout |
BIGINT NOT NULL:
5.7-8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
trx_autocommit_non_locking |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_concurrency_tickets |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_foreign_key_checks |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_is_read_only |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_isolation_level |
VARCHAR NOT NULL:
5.7-8
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_last_foreign_key_error |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_lock_memory_bytes |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_lock_structs |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_mysql_thread_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_operation_state |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_query |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_requested_lock_id |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_rows_locked |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_rows_modified |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_schedule_weight |
BIGINT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
trx_started |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_state |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_tables_in_use |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_tables_locked |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_unique_checks |
INT NOT NULL:
5.7-8
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_wait_started |
DATETIME NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
trx_weight |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
innodb_virtual |
||||||||
base_pos |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
pos |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
inspection_result |
||||||||
details |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
item |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
reference |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
rule |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
severity |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
status_address |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
value |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
inspection_rules |
||||||||
comment |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
inspection_summary |
||||||||
avg_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
comment |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
instance |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
label |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
max_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
metrics_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
min_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
quantile |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
rule |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
key_caches |
||||||||
block_size |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
dirty_blocks |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
full_size |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
key_cache_name |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
read_requests |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
reads |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
segment_number |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
segments |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
unused_blocks |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
used_blocks |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
write_requests |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
writes |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
key_column_usage |
||||||||
column_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
ordinal_position |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(10) NOT NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| INT NULL:
| |||
position_in_unique_constraint |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(10) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
referenced_column_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
referenced_table_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
referenced_table_schema |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
keywords |
||||||||
reserved |
INT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
word |
VARCHAR NULL:
8
| VARCHAR NULL:
10.2-10.5
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
locales |
||||||||
decimal_point |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
description |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
error_message_language |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
id |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_day_name_length |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_month_name_length |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
name |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thousand_sep |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
metadata_lock_info |
||||||||
lock_duration |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
lock_mode |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
lock_type |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_schema |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thread_id |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
metrics_summary |
||||||||
avg_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
comment |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
max_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
metrics_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
min_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
quantile |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
sum_value |
unsupported | unsupported | DOUBLE(22,6) NULL:
| unsupported | unsupported | unsupported | ||
metrics_tables |
||||||||
comment |
unsupported | unsupported | VARCHAR(256) NULL:
| unsupported | unsupported | unsupported | ||
labels |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
promql |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
quantile |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
mroonga_stats |
||||||||
rows_read |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_written |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
version |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
optimizer_trace |
||||||||
insufficient_privileges |
TINYINT NOT NULL:
5.7-8
| TINYINT NOT NULL:
10.4-10.7
| unsupported | unsupported | unsupported | unsupported | ||
missing_bytes_beyond_max_mem_size |
INT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
nsufficent_privileges |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
query |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
trace |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
parameters |
||||||||
as_locator |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
character_maximum_length |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
character_octet_length |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
character_set_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
data_type |
VARCHAR NOT NULL:
5.7
LONGTEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
datetime_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
dtd_identifier |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
is_result |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
numeric_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| TINYINT NULL:
| ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
numeric_scale |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| TINYINT NULL:
| ||
ordinal_position |
BIGINT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
parameter_default |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
parameter_mode |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
parameter_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
user_defined_type_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
user_defined_type_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
user_defined_type_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
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 | ||
placement_policies |
||||||||
catalog_name |
unsupported | unsupported | VARCHAR(512) NOT NULL:
| unsupported | unsupported | unsupported | ||
constraints |
unsupported | unsupported | VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
follower_constraints |
unsupported | unsupported | VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
followers |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
leader_constraints |
unsupported | unsupported | VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
learner_constraints |
unsupported | unsupported | VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
learners |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
policy_id |
unsupported | unsupported | BIGINT(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
policy_name |
unsupported | unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
primary_region |
unsupported | unsupported | VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
regions |
unsupported | unsupported | VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
schedule |
unsupported | unsupported | VARCHAR(20) NULL:
| unsupported | unsupported | unsupported | ||
placement_rules |
||||||||
catalog_name |
unsupported | unsupported | VARCHAR(512) NOT NULL:
| unsupported | unsupported | unsupported | ||
constraints |
unsupported | unsupported | VARCHAR(5) NOT NULL:
| unsupported | unsupported | unsupported | ||
follower_constraints |
unsupported | unsupported | VARCHAR(5) NOT NULL:
| unsupported | unsupported | unsupported | ||
followers |
unsupported | unsupported | BIGINT(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
leader_constraints |
unsupported | unsupported | VARCHAR(5) NOT NULL:
| unsupported | unsupported | unsupported | ||
learner_constraints |
unsupported | unsupported | VARCHAR(5) NOT NULL:
| unsupported | unsupported | unsupported | ||
learners |
unsupported | unsupported | BIGINT(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
partition_name |
unsupported | unsupported | VARCHAR(5) NULL:
| unsupported | unsupported | unsupported | ||
policy_id |
unsupported | unsupported | BIGINT(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
policy_name |
unsupported | unsupported | VARCHAR(5) NULL:
| unsupported | unsupported | unsupported | ||
primary_region |
unsupported | unsupported | VARCHAR(5) NOT NULL:
| unsupported | unsupported | unsupported | ||
regions |
unsupported | unsupported | VARCHAR(5) NOT NULL:
| unsupported | unsupported | unsupported | ||
schedule |
unsupported | unsupported | VARCHAR(20) NOT NULL:
| unsupported | unsupported | unsupported | ||
schema_name |
unsupported | unsupported | VARCHAR(5) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(5) NULL:
| unsupported | unsupported | unsupported | ||
plugins |
||||||||
load_option |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_auth_version |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_author |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_description |
LONGTEXT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_library |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_library_version |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_license |
VARCHAR NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_maturity |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_status |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_type_version |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
plugin_version |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
processlist |
||||||||
command |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(16) NOT NULL:
| unsupported | unsupported | unsupported | ||
db |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
examined_rows |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
host |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
info |
LONGTEXT NULL:
5.7-8
| NULL:
| BINARY(512) NULL:
| unsupported | unsupported | unsupported | ||
info_binary |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_memory_used |
unsupported | BIGINT NOT NULL:
10.3-10.7
| unsupported | unsupported | unsupported | unsupported | ||
max_stage |
unsupported | TINYINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
mem |
unsupported | unsupported | BIGINT(21) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
memory_used |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
progress |
unsupported | DECIMAL NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
query_id |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
stage |
unsupported | TINYINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
state |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(7) NULL:
| unsupported | unsupported | unsupported | ||
tid |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| INT(7) NOT NULL:
| unsupported | unsupported | unsupported | ||
time_ms |
unsupported | DECIMAL NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
txnstart |
unsupported | unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
user |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(16) NOT NULL:
| unsupported | unsupported | unsupported | ||
profiling |
||||||||
block_ops_in |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
block_ops_out |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
context_involuntary |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
context_voluntary |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
cpu_system |
DECIMAL NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
cpu_user |
DECIMAL NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
duration |
DECIMAL NOT NULL:
5.7-8
| DECIMAL NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
messages_received |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
messages_sent |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
page_faults_major |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
page_faults_minor |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
query_id |
INT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
seq |
INT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
source_file |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
source_function |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
source_line |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
state |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
swaps |
INT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
query_cache_info |
||||||||
autocommit |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
character_set_client |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
character_set_result |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
client_long_flag |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
client_protocol_41 |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
default_week_format |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
div_precision_increment |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
group_concat_max_length |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
hits |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
in_trans |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
lc_time_names |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
limit |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_sort_length |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
more_results_exists |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
packet_number |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
protocol_type |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
result_blocks_count |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
result_blocks_size |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
result_blocks_size_used |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_mode |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
statement_schema |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
statement_text |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
timezone |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
query_response_time |
||||||||
count |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
time |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
referential_constraints |
||||||||
constraint_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
constraint_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
delete_rule |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(11) NULL:
| |||
match_option |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(7) NULL:
| |||
referenced_table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
unique_constraint_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
unique_constraint_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
unique_constraint_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
update_rule |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(11) NULL:
| |||
resource_groups |
||||||||
resource_group_enabled |
TINYINT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
resource_group_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
resource_group_type |
ENUM NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
thread_priority |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
vcpu_ids |
BLOB NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_column_grants |
||||||||
column_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantee |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantee_host |
CHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
VARCHAR NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
privilege_type |
SET NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_schema |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
role_routine_grants |
||||||||
grantee |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantee_host |
CHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
VARCHAR NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
privilege_type |
SET NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
routine_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
role_table_grants |
||||||||
grantee |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
grantee_host |
CHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
VARCHAR NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
grantor_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
privilege_type |
SET NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
table_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
table_schema |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
with_hierarchy |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
role_udt_grants |
||||||||
grantee |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
is_grantable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
privilege_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
role_usage_grants |
||||||||
grantee |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
is_grantable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
object_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
privilege_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
roles |
||||||||
role_name |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
routine_column_usage |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_columns |
||||||||
character_maximum_length |
unsupported | unsupported | unsupported | unsupported | unsupported | INT NULL:
| ||
character_octet_length |
unsupported | unsupported | unsupported | unsupported | unsupported | INT NULL:
| ||
character_set_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | VARCHAR(6) NULL:
| ||
character_set_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
character_set_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | VARCHAR(3) NULL:
| ||
collation_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | VARCHAR(6) NULL:
| ||
collation_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
collation_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | VARCHAR(3) NULL:
| ||
column_default |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(4000) NULL:
| ||
column_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
data_type |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
datetime_precision |
unsupported | unsupported | unsupported | unsupported | unsupported | SMALLINT NULL:
| ||
domain_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
domain_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
domain_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
is_nullable |
unsupported | unsupported | unsupported | unsupported | unsupported | VARCHAR(3) NULL:
| ||
numeric_precision |
unsupported | unsupported | unsupported | unsupported | unsupported | TINYINT NULL:
| ||
numeric_precision_radix |
unsupported | unsupported | unsupported | unsupported | unsupported | SMALLINT NULL:
| ||
numeric_scale |
unsupported | unsupported | unsupported | unsupported | unsupported | TINYINT NULL:
| ||
ordinal_position |
unsupported | unsupported | unsupported | unsupported | unsupported | INT NULL:
| ||
table_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
table_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
table_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
routine_privileges |
||||||||
grantee |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
is_grantable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
privilege_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_routine_usage |
||||||||
routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_sequence_usage |
||||||||
routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
schema_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
sequence_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
14-15
| unsupported | unsupported | ||
sequence_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
sequence_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_table_usage |
||||||||
routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routines |
||||||||
as_locator |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
character_maximum_length |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
character_octet_length |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
character_set_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
created |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | TIME_STAMP:
TIME_STAMP NULL:
| NULL:
| DATETIME NULL:
| ||
data_type |
VARCHAR NOT NULL:
5.7
LONGTEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| NULL:
| NVARCHAR(128) NULL:
| ||
database_collation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
datetime_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
definer |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
dtd_identifier |
LONGTEXT NULL:
5.7-8
| LONGTEXT NULL:
10.2-10.7
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
external_language |
VARCHAR NOT NULL:
8
VARCHAR NULL:
5.7
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
external_name |
BINARY NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
is_deterministic |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
is_implicitly_invocable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
is_null_call |
unsupported | unsupported | unsupported | YES_OR_NO NULL:
CHARACTER_DATA:
| NULL:
| NVARCHAR(10) NULL:
| ||
is_udt_dependent |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
is_user_defined_cast |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
last_altered |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | TIME_STAMP:
TIME_STAMP NULL:
| NULL:
| DATETIME NULL:
| ||
max_dynamic_result_sets |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| BIGINT NULL:
| ||
module_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
module_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
module_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
new_savepoint_level |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
numeric_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
numeric_scale |
INT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
parameter_style |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
result_cast_as_locator |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
result_cast_char_max_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_char_octet_length |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_char_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_char_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_char_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_datetime_precision |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_from_data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
result_cast_interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
result_cast_maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_type_udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_type_udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_type_udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
routine_body |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
routine_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_comment |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
routine_definition |
LONGTEXT NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(4000) NULL:
| ||
routine_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| NULL:
| NVARCHAR(20) NULL:
| ||
schema_level_routine |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
security_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
sql_data_access |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
sql_mode |
SET NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_path |
BINARY NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
to_sql_specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
to_sql_specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
to_sql_specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
type_udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| NULL:
| NVARCHAR(128) NULL:
| ||
type_udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| NULL:
| NVARCHAR(128) NULL:
| ||
type_udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
schema_privileges |
||||||||
grantee |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
is_grantable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
privilege_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | |||
schemata |
||||||||
catalog_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
default_character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(6) NULL:
| ||
default_character_set_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
default_character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(3) NULL:
| ||
default_collation_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NULL:
| unsupported | unsupported | unsupported | ||
default_encryption |
ENUM NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
schema_comment |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
schema_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
schema_owner |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
sql_path |
BINARY NULL:
5.7-8
| NULL:
| VARCHAR(512) NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
table_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
table_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
schemata_extensions |
||||||||
catalog_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
options |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
schema_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
sequences |
||||||||
cache |
unsupported | unsupported | TINYINT(4) NOT NULL:
| unsupported | unsupported | unsupported | ||
cache_value |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
comment |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cycle |
unsupported | unsupported | TINYINT(4) NOT NULL:
| unsupported | unsupported | unsupported | ||
cycle_option |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
increment |
unsupported | unsupported | BIGINT(21) NOT NULL:
| CARDINAL_NUMBER:
CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
max_value |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
maximum_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
min_value |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
minimum_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
sequence_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
sequence_name |
unsupported | unsupported | VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
sequence_schema |
unsupported | unsupported | VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
start |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
start_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
table_catalog |
unsupported | unsupported | VARCHAR(512) NOT NULL:
| unsupported | unsupported | unsupported | ||
session_status |
||||||||
variable_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
variable_value |
VARCHAR NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
session_variables |
||||||||
cardinality |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
collation |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
column_name |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
direction |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
implicit |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
index_name |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
index_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
non_unique |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
seq_in_index |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
storing |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
table_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
table_name |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
table_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
variable_name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
variable_value |
VARCHAR NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| VARCHAR(1024) NULL:
| unsupported | unsupported | unsupported | ||
slow_query |
||||||||
backoff_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
backoff_types |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
commit_backoff_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
commit_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
compile_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
conn_id |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_addr |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_avg |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_max |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_p90 |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_addr |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_avg |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_max |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_p90 |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
db |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
disk_max |
unsupported | unsupported | BIGINT(20) NULL:
| unsupported | unsupported | unsupported | ||
get_commit_ts_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
host |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
index_names |
unsupported | unsupported | VARCHAR(100) NULL:
| unsupported | unsupported | unsupported | ||
is_internal |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
local_latch_wait_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
lockkeys_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
mem_max |
unsupported | unsupported | BIGINT(20) NULL:
| unsupported | unsupported | unsupported | ||
optimize_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
parse_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
plan |
unsupported | unsupported | LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
plan_digest |
unsupported | unsupported | VARCHAR(128) NULL:
| unsupported | unsupported | unsupported | ||
plan_from_cache |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
preproc_subqueries |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
preproc_subqueries_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
prev_stmt |
unsupported | unsupported | LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
prewrite_region |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
prewrite_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
process_keys |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
process_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
query |
unsupported | unsupported | LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
query_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
request_count |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
resolve_lock_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
rewrite_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
stats |
unsupported | unsupported | VARCHAR(512) NULL:
| unsupported | unsupported | unsupported | ||
succ |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
total_keys |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
txn_retry |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
txn_start_ts |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
user |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
wait_prewrite_binlog_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
wait_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
wait_ts |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
write_keys |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
write_size |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
spatial_ref_sys |
||||||||
auth_name |
unsupported | VARCHAR(512) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
auth_srid |
unsupported | SMALLINT(5) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
srid |
unsupported | SMALLINT(5) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
srtext |
unsupported | VARCHAR(2048) NOT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
spider_alloc_mem |
||||||||
alloc_mem_count |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
current_alloc_mem |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
file_name |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
free_mem_count |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
func_name |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
id |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
line_no |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total_alloc_mem |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
spider_wrapper_protocols |
||||||||
wrapper_description |
unsupported | LONGTEXT NULL:
| unsupported | unsupported | unsupported | unsupported | ||
wrapper_maturity |
unsupported | VARCHAR(12) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
wrapper_name |
unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
wrapper_version |
unsupported | VARCHAR(20) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_features |
||||||||
comments |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
feature_id |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
feature_name |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
is_supported |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_verified_by |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
sub_feature_id |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
sub_feature_name |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
sql_functions |
||||||||
function |
unsupported | VARCHAR NULL:
10.2-10.5
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_implementation_info |
||||||||
character_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
comments |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
implementation_info_id |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
implementation_info_name |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
integer_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
sql_languages |
||||||||
sql_language_binding_style |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_comformance |
unsupported | unsupported | unsupported | CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_conformance |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_implementation |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_integrity |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_programming_language |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_source |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_language_year |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_packages |
||||||||
comments |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
feature_id |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
feature_name |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
is_supported |
unsupported | unsupported | unsupported | YES_OR_NO NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
is_verified_by |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
sql_parts |
||||||||
comments |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
feature_id |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
feature_name |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
is_supported |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_verified_by |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
sql_sizing |
||||||||
comments |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
sizing_id |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
sizing_name |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
supported_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
sql_sizing_profiles |
||||||||
comments |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
profile_id |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
required_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER NULL:
CARDINAL_NUMBER:
| unsupported | unsupported | ||
sizing_id |
unsupported | unsupported | unsupported | CARDINAL_NUMBER NULL:
CARDINAL_NUMBER:
| unsupported | unsupported | ||
sizing_name |
unsupported | unsupported | unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
st_geometry_columns |
||||||||
column_name |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
geometry_type_name |
LONGTEXT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
srs_id |
INT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
srs_name |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
st_spatial_reference_systems |
||||||||
definition |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
description |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
organization |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
organization_coordsys_id |
INT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
srs_id |
INT NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
srs_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
st_units_of_measure |
||||||||
conversion_factor |
DOUBLE NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
description |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
unit_name |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
unit_type |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
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 | |||
system_variables |
||||||||
command_line_argument |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
default_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
enum_value_list |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
global_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
global_value_origin |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
global_value_path |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
numeric_block_size |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
numeric_max_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
numeric_min_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
read_only |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
session_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_comment |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_name |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_scope |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_type |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_constraints |
||||||||
constraint_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
constraint_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(11) NULL:
| |||
enforced |
VARCHAR NOT NULL:
8
| unsupported | unsupported | YES_OR_NO NULL:
| unsupported | unsupported | ||
initially_deferred |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(2) NULL:
| |||
is_deferrable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(2) NULL:
| |||
nulls_distinct |
unsupported | unsupported | unsupported | YES_OR_NO NULL:
| unsupported | unsupported | ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_constraints_extensions |
||||||||
constraint_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
constraint_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
constraint_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
secondary_engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_privileges |
||||||||
grantee |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
grantee_type |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
grantor_type |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(3) NULL:
| |||
privilege_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(10) NULL:
| |||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
with_hierarchy |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
table_statistics |
||||||||
rows_changed |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_changed_x_indexes |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_read |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
unsupported | VARCHAR(192) NOT NULL:
VARCHAR(192) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_schema |
unsupported | VARCHAR(192) NOT NULL:
VARCHAR(192) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
table_storage_stats |
||||||||
empty_region_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
peer_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_keys |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_size |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
tables |
||||||||
auto_increment |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
avg_row_length |
BIGINT NULL:
5.7-8
| 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 | ||
commit_action |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
create_options |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(255) NULL:
| unsupported | unsupported | unsupported | ||
create_time |
TIMESTAMP NOT NULL:
8
DATETIME NULL:
5.7
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
data_free |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
data_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
engine |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
index_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
is_insertable_into |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_typed |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
max_data_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
max_index_length |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
reference_generation |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
row_format |
ENUM NULL:
5.7-8
| NULL:
| VARCHAR(10) NULL:
| unsupported | unsupported | unsupported | ||
self_referencing_column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_collation |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(32) NOT NULL:
| unsupported | unsupported | unsupported | ||
table_comment |
VARCHAR NOT NULL:
5.7
TEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(2048) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
table_rows |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| CHARACTER_DATA NULL:
CHARACTER_DATA:
| VARCHAR(10) NULL:
| |||
temporary |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tidb_row_id_sharding_info |
unsupported | unsupported | VARCHAR(255) NULL:
| unsupported | unsupported | unsupported | ||
tidb_table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
update_time |
DATETIME NULL:
5.7-8
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
user_defined_type_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
version |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | |||
tables_extensions |
||||||||
engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
secondary_engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
tablespaces |
||||||||
autoextend_size |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
engine |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
extent_size |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
logfile_group_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
maximum_size |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
nodegroup_id |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tablespace_comment |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tablespace_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tablespace_type |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tablespaces_extensions |
||||||||
engine_attribute |
JSON NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
tablespace_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
thread_pool_groups |
||||||||
active_threads |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
connections |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
group_id |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
has_listener |
unsupported | TINYINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
is_stalled |
unsupported | TINYINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
queue_length |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
standby_threads |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
threads |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thread_pool_queues |
||||||||
connection_id |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
group_id |
unsupported | INT NOT NULL:
10.5-10.7
| unsupported | unsupported | unsupported | unsupported | ||
position |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
priority |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
queueing_time_microseconds |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thread_pool_stats |
||||||||
dequeues_by_listener |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
dequeues_by_worker |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
group_id |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
polls_by_listener |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
polls_by_worker |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
stalls |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thread_creations |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thread_creations_due_to_stall |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
throttles |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
wakes |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
wakes_due_to_stall |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
thread_pool_waits |
||||||||
count |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
reason |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tidb_hot_regions |
||||||||
db_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
flow_bytes |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
max_hot_degree |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
tidb_hot_regions_history |
||||||||
db_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
flow_bytes |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
hot_degree |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
is_leader |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
is_learner |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
key_rate |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
peer_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
query_rate |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
region_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
store_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
type |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
update_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
tidb_indexes |
||||||||
column_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
expression |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
index_comment |
unsupported | unsupported | VARCHAR(2048) NULL:
| unsupported | unsupported | unsupported | ||
index_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
key_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
non_unique |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
seq_in_index |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
sub_part |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
tidb_servers_info |
||||||||
binlog_status |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
ddl_id |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
git_hash |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
ip |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
lease |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
port |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
status_port |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
version |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
tidb_trx |
||||||||
all_sql_digests |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
current_sql_digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
current_sql_digest_text |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
db |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
id |
unsupported | unsupported | BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
mem_buffer_bytes |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
mem_buffer_keys |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
session_id |
unsupported | unsupported | BIGINT(21) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
start_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
state |
unsupported | unsupported | ENUM('IDLE','RUNNING','LOCKWAITING','COMMITTING','ROLLINGBACK') NULL:
ENUM('NORMAL','LOCKWAITING','COMMITTING','ROLLINGBACK') NULL:
| unsupported | unsupported | unsupported | ||
user |
unsupported | unsupported | VARCHAR(16) NULL:
| unsupported | unsupported | unsupported | ||
waiting_start_time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
tiflash_replica |
||||||||
available |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
location_labels |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
progress |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
replica_count |
unsupported | unsupported | BIGINT(64) NULL:
| unsupported | unsupported | unsupported | ||
table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
tikv_region_peers |
||||||||
down_seconds |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
is_leader |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
is_learner |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
peer_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
status |
unsupported | unsupported | VARCHAR(10) NULL:
| unsupported | unsupported | unsupported | ||
store_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
tikv_region_status |
||||||||
approximate_keys |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
approximate_size |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
db_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
end_key |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
epoch_conf_ver |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
epoch_version |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
index_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
is_index |
unsupported | unsupported | TINYINT(1) NOT NULL:
| unsupported | unsupported | unsupported | ||
read_bytes |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
replicationstatus_state |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
replicationstatus_stateid |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
start_key |
unsupported | unsupported | TEXT NULL:
| unsupported | unsupported | unsupported | ||
table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
written_bytes |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
tikv_store_status |
||||||||
address |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
available |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
capacity |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
label |
unsupported | unsupported | JSON NULL:
| unsupported | unsupported | unsupported | ||
last_heartbeat_ts |
unsupported | unsupported | DATETIME NULL:
| unsupported | unsupported | unsupported | ||
leader_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
leader_score |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
leader_size |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
leader_weight |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
region_count |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_score |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
region_size |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
region_weight |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
start_ts |
unsupported | unsupported | DATETIME NULL:
| unsupported | unsupported | unsupported | ||
store_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
store_state |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
store_state_name |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
uptime |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
version |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
transforms |
||||||||
group_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
transform_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
triggered_update_columns |
||||||||
event_object_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_column |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_table |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
triggers |
||||||||
action_condition |
BINARY NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
action_order |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| unsupported | CARDINAL_NUMBER NULL:
CARDINAL_NUMBER:
| unsupported | unsupported | ||
action_orientation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
action_reference_new_row |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
action_reference_new_table |
BINARY NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| unsupported | unsupported | ||
action_reference_old_row |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
action_reference_old_table |
BINARY NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| unsupported | unsupported | ||
action_statement |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
action_timing |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
condition_reference_new_row |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_reference_new_table |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_reference_old_row |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_reference_old_table |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_timing |
unsupported | unsupported | unsupported | CHARACTER_DATA:
| unsupported | unsupported | ||
created |
TIMESTAMP NOT NULL:
8
DATETIME NULL:
5.7
| NULL:
| unsupported | TIME_STAMP:
TIME_STAMP NULL:
| unsupported | unsupported | ||
database_collation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
definer |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_manipulation |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
event_object_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_table |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
sql_mode |
SET NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
trigger_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
type_privileges |
||||||||
grantee |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
privilege_type |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
type_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
type_name |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
type_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
udt_privileges |
||||||||
grantee |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
is_grantable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
privilege_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
usage_privileges |
||||||||
grantee |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
is_grantable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
object_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
privilege_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
user_attributes |
||||||||
attribute |
LONGTEXT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
host |
CHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
user |
CHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
user_defined_types |
||||||||
character_maximum_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_octet_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
datetime_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
is_final |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_instantiable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
ordering_category |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
ordering_form |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
ordering_routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
ordering_routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
ordering_routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
ref_dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
reference_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
source_dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_category |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
user_defined_type_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_mapping_options |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
option_value |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
user_mappings |
||||||||
authorization_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
foreign_server_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_privileges |
||||||||
grantee |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(81) NULL:
| unsupported | unsupported | |||
is_grantable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | |||
privelege_type |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
privilege_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | |||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| unsupported | unsupported | |||
user_statistics |
||||||||
access_denied |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
binlog_bytes_written |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
busy_time |
unsupported | DOUBLE NOT NULL:
DOUBLE NULL:
| unsupported | unsupported | unsupported | unsupported | ||
bytes_received |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
bytes_sent |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
commit_transactions |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
concurrent_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
connected_time |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
cpu_time |
unsupported | DOUBLE NOT NULL:
DOUBLE NULL:
| unsupported | unsupported | unsupported | unsupported | ||
denied_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
empty_queries |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
lost_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_statement_time_exceeded |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
other_commands |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rollback_transactions |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_deleted |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_inserted |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_read |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_sent |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
rows_updated |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
select_commands |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
total_ssl_connections |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
update_commands |
unsupported | INT(21) NOT NULL:
INT(21) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
user |
unsupported | VARCHAR(48) NOT NULL:
VARCHAR(48) NULL:
| unsupported | unsupported | unsupported | unsupported | ||
user_variables |
||||||||
character_set_name |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_name |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_type |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
variable_value |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
view_column_usage |
||||||||
column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
table_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
table_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
table_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
view_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
view_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
view_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
view_routine_usage |
||||||||
specific_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
view_table_usage |
||||||||
table_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
table_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
table_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
view_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
view_name |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
view_schema |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
views |
||||||||
algorithm |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NOT NULL:
| unsupported | unsupported | unsupported | ||
check_option |
VARCHAR NOT NULL:
5.7
ENUM NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(8) NOT NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(7) NULL:
| |||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NOT NULL:
| unsupported | unsupported | unsupported | ||
definer |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(77) NOT NULL:
| unsupported | unsupported | unsupported | ||
is_insertable_into |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_trigger_deletable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
is_trigger_insertable_into |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
is_trigger_updatable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||
is_updatable |
VARCHAR NOT NULL:
5.7
ENUM NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NOT NULL:
| CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(2) NULL:
| |||
security_type |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(7) NOT NULL:
| unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
view definition |
unsupported | unsupported | unsupported | CHARACTER_DATA:
| unsupported | unsupported | ||
view_definition |
LONGTEXT NOT NULL:
5.7
LONGTEXT NULL:
8
| LONGTEXT NOT NULL:
NULL:
| LONGBLOB NOT NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| NVARCHAR(4000) NULL:
| |||