Use k constraint for sqlite-vec knn queries
Assisted-by: Claude Opus 4.6 via pi
change kksykkxnrmvykvvtuqlswunmvxyrxvlr
commit fad211cbbb9dfaff9ee5abc1bab1dd1e12c41db3
author Alpha Chen <alpha@kejadlen.dev>
date
parent zyllwyrs 
diff --git a/bin/semantic-search b/bin/semantic-search
index 10e1772..23e594d 100755
--- a/bin/semantic-search
+++ b/bin/semantic-search
@@ -158,9 +158,8 @@ def search_cmd(args):
         SELECT p.episode, p.timestamp, p.text, v.distance
         FROM vec_paragraphs v
         JOIN paragraphs p ON p.id = v.id
-        WHERE v.embedding MATCH ?
+        WHERE v.embedding MATCH ? AND k = ?
         ORDER BY v.distance
-        LIMIT ?
         """,
         (serialize_f32(query_embedding.tolist()), args.limit),
     ).fetchall()