Skip to content

ALTER TABLE ... PARTITION BY HASH fails with error 1210 on table without primary key and with HNSW vector index #600

@chyujing

Description

@chyujing

Description

When executing ALTER TABLE ... PARTITION BY HASH on a table that has no primary key but has an HNSW vector index, the operation fails with error 1210.

Steps to Reproduce

  1. Navigate to the directory /obdata/data/AndroidTest/ob_opensource_test/tool/... on the test machine.
  2. Execute the test case vector_index.hnsw_index_without_pk.
  3. Observe the failure when the ALTER TABLE ... PARTITION BY HASH command is run.

Impact

Partitioning operations on tables with HNSW vector indexes but no primary key are blocked.

Environment

  • Test case: vector_index.hnsw_index_without_pk
  • Operating System: Windows

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions