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.

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

Fix issue with select distinct #379

Closed
davidmezzetti opened this issue Nov 16, 2022 · 0 comments
Closed

Fix issue with select distinct #379

davidmezzetti opened this issue Nov 16, 2022 · 0 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@davidmezzetti
Copy link
Member

select distinct queries aren't being interpreted correctly. For example:

embeddings.search("select distinct id, text from txtai where similar('test')")

doesn't return the distinct id/text rows. There is most likely an issue with the query preprocessor and the distinct keyword.

In the meantime, the following workaround can be used:

embeddings.search("select distinct(id || text), id, text from txtai where similar('test')")
@davidmezzetti davidmezzetti added the bug Something isn't working label Nov 16, 2022
@davidmezzetti davidmezzetti added this to the v5.2.0 milestone Nov 16, 2022
@davidmezzetti davidmezzetti self-assigned this Nov 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant