You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@franciscojavierarceo I think this is because there's a SQLite bug on version < 3.41 on LIMIT ? clauses on virtual tables. In a lot of sqlite-vec docs the example KNN query is:
select
rowid,
distance
from vec_example
where column match ?
order by distance
limit100
But this query won't work on SQLite version < 3.41, which is causing this bug.
The workaround is to provide the limit as a WHERE clause like so:
select
rowid,
distance
from vec_example
where column match ?
and k =100order by distance
I'll be sure to document this more - tbh I might not even show the LIMIT 100 variant anymore, since many people are stuck on old SQLite versions in practice
Is your feature request related to a problem? Please describe.
Can't run
sqlite_vec
on 3.11 or non-Darwin OS.Describe the solution you'd like
Able to run sqlite vector search on Linux and not limited to 3.11
Describe alternatives you've considered
N/A
Additional context
#4209
The text was updated successfully, but these errors were encountered: