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

Use backticks in all Studio-generated queries #366

Closed
luinav opened this issue Apr 21, 2016 · 6 comments
Closed

Use backticks in all Studio-generated queries #366

luinav opened this issue Apr 21, 2016 · 6 comments

Comments

@luinav
Copy link

luinav commented Apr 21, 2016

I have successfully created a class called "IP-DMZ-INET" which is a subclass of vertex V. I have added a record without any problem.
But when I hit the buttong "Query All" of this class from the Orientdb Studio -> Schema
I get the following error "com.orienttechnologies.orient.core.sql.OcommandSQLParsingException: Error on parsing command at position #0: Error parsing query: select * from IP-DMZ-INET Encountered " "-" "-"" at line 1, column 17. Was expecting one of: ... []"

The same error occurs when I write "select from IP-DMZ-INET" in the browse tab.

I am using oriendb-community-2.1.15

@wolf4ood
Copy link
Member

hi @luinav

you should use backtick in Browse tab.

select from `IP-DMZ-INET`

I will fix the studio part to use backtick in Query All

@wolf4ood wolf4ood self-assigned this Apr 21, 2016
@wolf4ood wolf4ood added this to the 2.1.x (next hotfix) milestone Apr 21, 2016
@luinav
Copy link
Author

luinav commented Apr 22, 2016

I can confirm that it is ok if I use backticks.

Thank you for your quick support

@wolf4ood wolf4ood modified the milestones: 2.1.x (next hotfix), 2.2.x Jun 15, 2016
@santo-it santo-it added the bug label Jan 2, 2017
@santo-it
Copy link

santo-it commented Jan 2, 2017

Thanks for submitting this. Verified as described

All queries sent by Studio should use `, not only the "query all". Other commands, including create and drop are failing

Thanks,

@santo-it santo-it added the P2 label Jan 2, 2017
@santo-it santo-it changed the title Class name with invalid characters Use backticks in all Studio-generated queries Jan 4, 2017
@santo-it santo-it added the PBL1 label Jan 4, 2017
wolf4ood added a commit that referenced this issue Jan 9, 2017
wolf4ood added a commit that referenced this issue Jan 9, 2017
@wolf4ood wolf4ood closed this as completed Jan 9, 2017
@robfrank robfrank modified the milestones: 2.2.x (next hotfix), 2.2.15 Jan 16, 2017
@wolf4ood wolf4ood reopened this Jan 17, 2017
@wolf4ood
Copy link
Member

wolf4ood commented Jan 17, 2017

Databases created with ODB < 2.1 don't support back tick.
I will remove usage of back tick for those dbs

@wolf4ood
Copy link
Member

@santo-it
Implemented

@santo-it
Copy link

thanks. made a quick test. seems okay. closing. thanks again

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

No branches or pull requests

5 participants