Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQLite: Add support for WHERE clause on the FTS5 Table Name #3204

Open
ankitrgadiya opened this issue Feb 15, 2024 · 1 comment · May be fixed by #3498
Open

SQLite: Add support for WHERE clause on the FTS5 Table Name #3204

ankitrgadiya opened this issue Feb 15, 2024 · 1 comment · May be fixed by #3498
Labels
📚 sqlite enhancement New feature or request

Comments

@ankitrgadiya
Copy link

What do you want to change?

SQLite supports WHERE clause directly over the Table name to query all the columns.

CREATE VIRTUAL TABLE IF NOT EXISTS ft
USING fts5(id, name, content);
SELECT name, snippet(ft, -1, "...", "...", "", 30)
FROM ft
WHERE ft MATCH @query

But SQLC does not work with this Query.

# package gen
query.sql:77:7: column "ft" does not exist

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

Go
@ankitrgadiya ankitrgadiya added enhancement New feature or request triage New issues that hasn't been reviewed labels Feb 15, 2024
@ankitrgadiya ankitrgadiya changed the title Add support for WHERE clause on the FTS5 Table Name SQLite: Add support for WHERE clause on the FTS5 Table Name Feb 15, 2024
@kyleconroy kyleconroy added 📚 sqlite and removed triage New issues that hasn't been reviewed labels Mar 4, 2024
@ChristianChiarulli ChristianChiarulli mentioned this issue Jul 3, 2024
Open
@naspeh naspeh linked a pull request Jul 22, 2024 that will close this issue
Open
@naspeh
Copy link

naspeh commented Sep 13, 2024

I have created PR for this #3498.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
📚 sqlite enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix(sqlite): allow using fts5 table name in the where clause naskoro/sqlc
3 participants
@kyleconroy @naspeh @ankitrgadiya