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 1210 occurs when attempting to create a second vector index (idx2(c3)) on a table without a primary key that already has a first vector index (idx1(c2)).

Steps to Reproduce

1. Execute the vector_index.hnsw_index_refresh_rebuild_basic_without_pk test case.
2. The test involves creating a table without a primary key.
3. Create a first HNSW vector index idx1 on column c2.
4. Attempt to create a second HNSW vector index idx2 on column c3.
5. The operation fails with error code 1210.

Additional Context

• The issue is related to partitioning operations (ALTER TABLE ... PARTITION BY HASH) on tables with HNSW vector indexes but without a primary key.
• The specific test file path mentioned is /obdata/data/AndroidTest/o... (path truncated in original input).