Details
-
New Feature
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
Description
Optimizer has to use the k-NN capable vector index for queries like
SELECT ... FROM table ORDER BY VEC_DISTANCE(col, const) LIMIT n |
That is
- ORDER BY VEC_DISTANCE
- one argument is a column of a table, the other is a constant
- LIMIT
- no WHERE clause
Attachments
Issue Links
- blocks
-
MDEV-33409 Index Condition Pushdown for k-ANN graph searches
- Open
-
MDEV-33412 cost-based optimizer choice for k-NN indexes
- Open
-
MDEV-33414 benchmark vector indexes
- In Testing
- is part of
-
MDEV-34939 vector search in 11.7
- In Testing
- relates to
-
MDEV-32887 k-ANN indexes for vectors
- In Progress