github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/ddl/secondary_index_delete.result (about)

     1  drop table if exists t1;
     2  create table t1(id int PRIMARY KEY,name VARCHAR(255),age int);
     3  create index idx1 on t1(name);
     4  insert into t1 values(1,"Abby", 24);
     5  insert into t1 values(2,"Dora", 25);
     6  show index from t1;
     7  Table    Non_unique    Key_name    Seq_in_index    Column_name    Collation    Cardinality    Sub_part    Packed    Null    Index_type    Comment    Index_comment    Index_params    Visible    Expression
     8  t1    0    PRIMARY    1    id    A    0    NULL    NULL                        YES    NULL
     9  t1    1    idx1    1    name    A    0    NULL    NULL    YES                    YES    NULL
    10  drop table t1;
    11  select name, type, column_name from mo_catalog.mo_indexes mi where name="idx1";
    12  name    type    column_name
    13  drop table if exists t1;
    14  create table t1(id int PRIMARY KEY,name VARCHAR(255),age int);
    15  create index idx2 on t1(name,age);
    16  insert into t1 values(1,"Abby", 24);
    17  insert into t1 values(2,"Dora", 25);
    18  delete from t1 where id = 1;
    19  show index from t1;
    20  Table    Non_unique    Key_name    Seq_in_index    Column_name    Collation    Cardinality    Sub_part    Packed    Null    Index_type    Comment    Index_comment    Index_params    Visible    Expression
    21  t1    0    PRIMARY    1    id    A    0    NULL    NULL                        YES    NULL
    22  t1    1    idx2    1    name    A    0    NULL    NULL    YES                    YES    NULL
    23  t1    1    idx2    2    age    A    0    NULL    NULL    YES                    YES    NULL
    24  select name, type,column_name from mo_catalog.mo_indexes mi where name="idx2";
    25  name    type    column_name
    26  idx2    MULTIPLE    name
    27  idx2    MULTIPLE    age
    28  idx2    MULTIPLE    __mo_alias_id
    29  drop table if exists t1;
    30  create table t1(id int PRIMARY KEY,name VARCHAR(255),age int);
    31  create index idx3 on t1(name);
    32  insert into t1 values(1,"Abby", 24);
    33  insert into t1 values(2,"Dora", 25);
    34  show index from t1;
    35  Table    Non_unique    Key_name    Seq_in_index    Column_name    Collation    Cardinality    Sub_part    Packed    Null    Index_type    Comment    Index_comment    Index_params    Visible    Expression
    36  t1    0    PRIMARY    1    id    A    0    NULL    NULL                        YES    NULL
    37  t1    1    idx3    1    name    A    0    NULL    NULL    YES                    YES    NULL
    38  select name, type,column_name from mo_catalog.mo_indexes mi where name="idx3";
    39  name    type    column_name
    40  idx3    MULTIPLE    name
    41  idx3    MULTIPLE    __mo_alias_id
    42  show create table t1;
    43  Table    Create Table
    44  t1    CREATE TABLE `t1` (\n`id` INT NOT NULL,\n`name` VARCHAR(255) DEFAULT NULL,\n`age` INT DEFAULT NULL,\nPRIMARY KEY (`id`),\nKEY `idx3` (`name`)\n)
    45  DROP INDEX idx3 ON t1;
    46  show index from t1;
    47  Table    Non_unique    Key_name    Seq_in_index    Column_name    Collation    Cardinality    Sub_part    Packed    Null    Index_type    Comment    Index_comment    Index_params    Visible    Expression
    48  t1    0    PRIMARY    1    id    A    0    NULL    NULL                        YES    NULL
    49  select name, type,column_name from mo_catalog.mo_indexes mi where name="idx3";
    50  name    type    column_name
    51  show create table t1;
    52  Table    Create Table
    53  t1    CREATE TABLE `t1` (\n`id` INT NOT NULL,\n`name` VARCHAR(255) DEFAULT NULL,\n`age` INT DEFAULT NULL,\nPRIMARY KEY (`id`)\n)