information_schema.optimizer_trace.*

show items implemented by
relation column mysqlmariadbtidbpostgrescockroachdbmssql
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