Postgres error 42601
occurs when using _relevance
parameter
#24042
Labels
bug/1-unconfirmed
Bug should have enough information for reproduction, but confirmation has not happened yet.
kind/bug
A reported bug.
team/client
Issue for team Client.
topic: fullTextSearch
topic: postgresql
topic _relevance
Bug description
I'm faced with the error when I try to search text containing two words separated by a space. So if the search text doesn't match any data in db, then it works fine, but if there is some matching data - the error occurs.
The error:
The query that I try to send is in prisma information section. It contains
_relevance
field, and I think the problem is in its handling (without this field the query works as expected in any cases).How to reproduce
For example, if I send a string kinda
first sec
, and the db has a record withfirst second
, so it will crash with the db (postgres) error42601
. But if I sendfirst se1
(two words, but there is no data matching this text) or any string containing one word, it will work.Expected behavior
No response
Prisma information
Environment & setup
Prisma Version
The text was updated successfully, but these errors were encountered: