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

SQL REMOVE of a field fails when followed by additional SQL synatx #7362

Closed
SafwanHak opened this issue Apr 24, 2017 · 2 comments
Closed

SQL REMOVE of a field fails when followed by additional SQL synatx #7362

SafwanHak opened this issue Apr 24, 2017 · 2 comments
Assignees
Labels
Milestone

Comments

@SafwanHak
Copy link

OrientDB Version: 2.2

Java Version: 8

OS: Centos

Actual behavior

Database error that syntax is invalid.

Steps to reproduce

Found a bug as we translate our mongo code to Orient. Look at fieldX, it's just a field that we want to remove, not an array.. if it's the last instruction in SQL before the WHERE it works, if it's followed by any other SQL syntax it'll fail.

this query will work
update Test ADD names="abc" SET AGE=1 remove names = "blah4", fieldX where @Rid=#29:7

this query will break because fieldX is followed by an additional SQL syntax
update Test ADD names="abc" remove names = "blah4", fieldX SET AGE=1 where @Rid=#29:7

@luigidellaquila luigidellaquila self-assigned this Apr 24, 2017
@luigidellaquila
Copy link
Member

Hi @SafwanHak

This could be a parsing problem, I'll check it asap

Thanks

Luigi

@luigidellaquila
Copy link
Member

Hi @SafwanHak

I just pushed a fix on 2.2.x branch. The fix will be released in next few days with 2.2.19

Thanks

Luigi

@luigidellaquila luigidellaquila added this to the 2.2.19 milestone Apr 24, 2017
@lvca lvca modified the milestones: 2.2.x (next hotfix), 2.2.19 Apr 24, 2017
@robfrank robfrank modified the milestones: 2.2.x (next hotfix), 2.2.19 Apr 25, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

4 participants