Skip to content

It is not appropriate to add names generated by anonymous vector indexes when creating tables. #56491

@zimulala

Description

@zimulala

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a int, b vector(3), vector index((VEC_COSINE_DISTANCE(b))) USING HNSW);
show create table t;

2. What did you expect to see? (Required)

tidb> show create table t;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                           |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL,
  `b` vector(3) DEFAULT NULL,
  VECTOR INDEX `expression_index`((VEC_COSINE_DISTANCE(`b`)))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

 VECTOR INDEX `vector_index`((VEC_COSINE_DISTANCE(`b`)))

4. What is your TiDB version? (Required)

master

Release Version: v8.4.0-alpha-326-gfbcb35cd3d
Edition: Community
Git Commit Hash: fbcb35cd3d7b8ab3ebffe2af26fea7ab19365568

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions