The columns table in information_schema is not compatible with MySQL

[killme2008]

What type of bug is this?

Incorrect result

What subsystems are affected?

Table Engine

Minimal reproduce step

Missing lots of columns:

mysql> DESC COLUMNS;
+----------------+--------+------+------+---------+---------------+
| Column         | Type   | Key  | Null | Default | Semantic Type |
+----------------+--------+------+------+---------+---------------+
| table_catalog  | String |      | NO   |         | FIELD         |
| table_schema   | String |      | NO   |         | FIELD         |
| table_name     | String |      | NO   |         | FIELD         |
| column_name    | String |      | NO   |         | FIELD         |
| data_type      | String |      | NO   |         | FIELD         |
| semantic_type  | String |      | NO   |         | FIELD         |
| column_default | String |      | YES  |         | FIELD         |
| is_nullable    | String |      | NO   |         | FIELD         |
| column_type    | String |      | NO   |         | FIELD         |
| column_comment | String |      | YES  |         | FIELD         |
+----------------+--------+------+------+---------+---------------+

But MySQL columns table has many other columns:

https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html

What did you expect to see?

As described above.

What did you see instead?

As described above.

What operating system did you use?

All os

What version of GreptimeDB did you use?

0.7.1

Relevant log output and stack trace

No response