tursodatabase / tursodatabase/libsql
full text search not working as expected
Open
Nobody has claimed this yet.
- Dominant language
- C
- Stars
- 17.2k
- Forks
- 531
- Avg merge
- 1h 12m
- Merged PRs (30d)
- 1
Description
guys why does this query not work, even though there are records matching it
SELECT
*
FROM
playlists_fts
WHERE
playlists_fts MATCH 'foo'
ORDER BY
rank;
these are records in the virtual table
[ { title: 'foo', description: 'bar' } ]
i am using libsql client, db is sqlite3
this is migration
CREATE VIRTUAL TABLE playlists_fts USING fts5(
title,
description,
content='playlists',
content_rowid='id'
);
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No repository file or test is identified. Start by reproducing the supplied FTS5 migration, virtual-table rows, and MATCH query through the libsql client with sqlite3; determine whether the external-content table is populated and why the query returns no match. Done means the cause and expected behavior are established, with a focused fix or documented resolution.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100