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

PostgreSQL storage: guard against contains queries on non data fields. #2435

Open
dim opened this issue Feb 24, 2020 · 1 comment
Open

PostgreSQL storage: guard against contains queries on non data fields. #2435

dim opened this issue Feb 24, 2020 · 1 comment
Labels
bug stale For marking issues as stale. Labeled issues will be closed soon if label is not removed.

Comments

@dim
Copy link

dim commented Feb 24, 2020

PostgreSQL doesn't support @> operator usage on non JSONB fields, e.g.:

http GET http://localhost:9080/v1/buckets?contains_id=x  --auth="xxx"
HTTP/1.1 503 Service Unavailable

Logs:

Message: ProgrammingError("(psycopg2.errors.UndefinedFunction) operator does not exist: text @> text[]\nLINE 7: ...N ('864c05df-81d1-c946-9900-de717c6f882c') AND id @> ARRAY['...\n                                                             ^\nHINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.\n")
@leplatrem leplatrem added the bug label Feb 24, 2020
@leplatrem
Copy link
Contributor

Nice catch! Thanks for reporting!

@alexcottner alexcottner added the stale For marking issues as stale. Labeled issues will be closed soon if label is not removed. label Jul 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug stale For marking issues as stale. Labeled issues will be closed soon if label is not removed.
Projects
None yet
Development

No branches or pull requests

3 participants