The "show index" command does not display the inverted index.

[killme2008]

What type of bug is this?

Incorrect result

What subsystems are affected?

Query Engine

Minimal reproduce step

Starting from v0.10, we can create a table with an inverted index constraint, as shown below:

CREATE TABLE IF NOT EXISTS system_metrics (
    host STRING,
    idc STRING,
    cpu_util DOUBLE,
    memory_util DOUBLE,
    disk_util DOUBLE,
    `load` DOUBLE,
    ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY(host, idc),
    INVERTED INDEX(idc),
    TIME INDEX(ts)
);

However, the command show index from system_metrics does not display the inverted index type:

mysql> show indexes from system_metrics;
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+----------------------------+---------+---------------+---------+------------+
| Table          | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type                 | Comment | Index_comment | Visible | Expression |
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+----------------------------+---------+---------------+---------+------------+
| system_metrics |          1 | PRIMARY    |            1 | host        | A         |        NULL |     NULL |   NULL | YES  | greptime-inverted-index-v1 |         |               | YES     |       NULL |
| system_metrics |          1 | PRIMARY    |            2 | idc         | A         |        NULL |     NULL |   NULL | YES  | greptime-inverted-index-v1 |         |               | YES     |       NULL |
| system_metrics |          1 | TIME INDEX |            1 | ts          | A         |        NULL |     NULL |   NULL | NO   | greptime-inverted-index-v1 |         |               | YES     |       NULL |
+----------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+----------------------------+---------+---------------+---------+------------+

It only shows the time index and primary key types.

What did you expect to see?

Output the idc as inverted index type too.

What did you see instead?

N/A

What operating system did you use?

All

What version of GreptimeDB did you use?

v0.10, v0.11

Relevant log output and stack trace

No response