Re: [orientdb] update return after @rid not working version 1.7.7

2014-07-31 Thread alexander anguiano
Thanks! On Wednesday, July 30, 2014 6:17:35 PM UTC-5, Lvc@ wrote: > > Hi Alexander, > You found 2 bugs, one in documentation and the other in code: > > (1) documentation > > The "RETURN" keyword must go before WHERE, so try this: > > update TaskStatus set status = 'Running' RETURN AFTER @rid wher

Re: [orientdb] update return after @rid not working version 1.7.7

2014-07-30 Thread Luca Garulli
Hi Alexander, You found 2 bugs, one in documentation and the other in code: (1) documentation The "RETURN" keyword must go before WHERE, so try this: update TaskStatus set status = 'Running' RETURN AFTER @rid where status = 'Pending' limit 1 (2) code There is a bug where if the return value wa

[orientdb] update return after @rid not working version 1.7.7

2014-07-30 Thread alexander anguiano
I'm using orientdb 1.7.7 I have this update statement. update TaskStatus set status = 'Running' where status = 'Pending' limit 1 RETURN AFTER @rid I'm expecting the update to return a collection of rids it is failing because it doesn't like the return after keyword com.orientechnologies.ori