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

Operations on column and table names with white space cause "invalid identifier" error #340

Open
baybal opened this Issue Dec 20, 2018 · 3 comments

Comments

2 participants
@baybal
Copy link

baybal commented Dec 20, 2018

Description

Attempting to filter of select a field with a white space results in invalid identifier error

{ "error": "could not perform WhereByRequest: invalid identifier: Auto ID" }

@avelino avelino added bug easy labels Dec 21, 2018

@baybal

This comment has been minimized.

Copy link
Author

baybal commented Dec 22, 2018

It also happens whenever you do an UPDATE on a filed with whitespace

@baybal

This comment has been minimized.

Copy link
Author

baybal commented Dec 24, 2018

I also have a not yet confirmed suspicion of the same thing happening with table names and schemas

@baybal

This comment has been minimized.

Copy link
Author

baybal commented Dec 24, 2018

confirming

`GET http://localhost:8000/DB0001/%3CABSTRACT/GENERAL%3E:%3CNODES%3E

{
"error": "pq: relation "\u003cABSTRACT.GENERAL\u003e:\u003cNODES\u003e" does not exist"
}`

`GET http://localhost:8000/DB0001/%22%3CABSTRACT/GENERAL%3E:%3CNODES%3E%22

{
"error": "pq: zero-length delimited identifier at or near """""
}`

@avelino avelino changed the title Operations on column names with white space cause "invalid identifier" error Operations on column and table names with white space cause "invalid identifier" error Dec 24, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment