You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: