mysqltest vector_index.hnsw_index_refresh_rebuild_basic_without_pk fails with error 1210 when creating second vector index on table without primary key

[chyujing]

Description

During the execution of the vector_index.hnsw_index_refresh_rebuild_basic_without_pk test case, an error occurs when attempting to create a second HNSW vector index on a table that lacks a primary key and already has an existing vector index. The operation ALTER TABLE ... PARTITION BY HASH fails with error code 1210.

Steps to Reproduce

1. Execute the test case vector_index.hnsw_index_refresh_rebuild_basic_without_pk.
2. The test involves a table without a primary key that already has a vector index idx1(c2).
3. Attempt to create a second vector index idx2(c3) on the same table.
4. The operation fails with error 1210.

Environment

• Operating System: Windows
• Test Framework: mysqltest
• Related Test Case: vector_index.hnsw_index_refresh_rebuild_basic_without_pk
• Error Code: 1210