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

QueryFailedError: Syntax error when querying a file path #391

Open
AdamBraun opened this issue Mar 26, 2024 · 0 comments
Open

QueryFailedError: Syntax error when querying a file path #391

AdamBraun opened this issue Mar 26, 2024 · 0 comments

Comments

@AdamBraun
Copy link

AdamBraun commented Mar 26, 2024

Describe the bug

The . in a query throws an error

QueryFailedError: Syntax error at line 1 col 1:
1 /some/image.jpeg
   ^
Unexpected value token: "/some/image.jpeg". Instead, I was expecting to see one of the following:
    - A "start_list" token



💥 This is a nasty error, which was unexpected by pg-mem. Also known "a bug" 😁 Please file an issue !

Failed SQL statement: SELECT "LibraryEntity"."ownerId" AS "LibraryEntity_ownerId" FROM "libraries" "LibraryEntity" WHERE ( ("LibraryEntity"."importPaths" = '/some/image.jpeg') AND ( "LibraryEntity"."deletedAt" IS NULL ) LIMIT 1;

To Reproduce

CREATE TABLE "libraries" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "ownerId" uuid NOT NULL, "importPaths" text array NOT NULL)

pg-mem version

2.8.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant