Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
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
-
- Closed
-
- is part of
-
MDEV-34939 vector search in 11.7
-
- Closed
-
- relates to
-
MDEV-32887 vector search
-
- Stalled
-