[Feature Request]: Support unique index and secondary index

[domingozhang]

Is there an existing issue for the same feature request?

• [X] I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

CREATE [UNIQUE] INDEX index_name ON tbl_name (key_part,...) COMMENT 'string'

DROP INDEX index_name

The UNIQUE index needs to removing duplicates.
key_part can be multi columns.

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

[bbbearxyz]

now unique index is completed, please test it.

[bbbearxyz]

this issue now only about unique index, secondary I will implement it in the #3609

[heni02]

The test finds that the function is only partially implemented, and back to bbbearxyz

[bbbearxyz]

will support later

[bbbearxyz]

will fix later

[bbbearxyz]

will fix later

[daviszhen]

@iamlinjunhong setups a subtask for connecting the index with delete,select,insert,udpate and create/drop index; @qingxinhome setups a subtask for totally maintains the sematics and implementation of the index

[qingxinhome]

The secondary index will be developed

[fengttt]

2nd key tracked by https://github.com/matrixorigin/matrixone/issues/3609