Skip to content

SHOW CREATE TABLE works incorrectly for auto-embeddings tables #3782

@PavelShilin89

Description

@PavelShilin89

Bug Description:

Description

When a table is created with MODEL_NAME (auto-embeddings), SHOW CREATE TABLE returns incorrect output:

Outputs extra parameter: includes knn_dims (auto-computed), even though knn_dims and model_name are mutually exclusive
Loses required parameter: doesn't output FROM (mandatory for auto-embeddings)

MRE

mysql -h0 -P9306 -e "CREATE TABLE t (title TEXT, vec FLOAT_VECTOR KNN_TYPE='hnsw' HNSW_SIMILARITY='l2' MODEL_NAME='sentence-transformers/all-MiniLM-L6-v2' FROM='title')" && mysql -h0 -P9306 -e "SHOW CREATE TABLE t\G"
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE t (
id bigint,
title text,
vec float_vector knn_type='hnsw' knn_dims='384' hnsw_similarity='L2' model_name='sentence-transformers/all-MiniLM-L6-v2'
)

Manticore Search Version:

Manticore 13.11.6 c18501cc3@25092509 dev (columnar 8.0.6 9a3b45b@25092117) (secondary 8.0.6 9a3b45b@25092117) (knn 8.0.6 9a3b45b@25092117) (embeddings 1.0.1)

Operating System Version:

Ubuntu 24.04.3 LTS

Have you tried the latest development version?

Yes

Internal Checklist:

To be completed by the assignee. Check off tasks that have been completed or are not applicable.

  • Implementation completed
  • Tests developed
  • Documentation updated
  • Documentation reviewed

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions