Invalid TO vertex for edge when using Batch updates

[sudhamab]

Hi Team,

I am using OrientJS version 3.0.0-beta.1

And trying to do a batch update using code as below

      let someValidUserRid = "#1:0";
      let arrayOfBookNames = ["Harry Potter", "Advanced OrientJS"];

      let batch = `begin; 
        foreach ($bookname in :booklist) {
          let $v1 = update Book set name = $bookname UPSERT where name = $bookname;
          let $e = create edge Owns from :user_rid to $v1;
        } 
        commit;
        return  $e;`;

      return session
      .batch(batch, {params: { booklist: arrayOfBookNames, user_rid: someValidUserRid}})
      .all()

However, I get an error "Invalid TO vertex for edge". I was expecting to get a reference to the updated record and then use that to create an Edge from the User to that Vertex.

I faced the same issue when using transactions as well.

Am I missing something?

[luigidellaquila]

Hi @sudhamab

Please try to add a RETURN AFTER to the UPDATE statement:

update Book set name = $bookname UPSERT RETURN AFTER where name = $bookname;

Thanks

Luigi

[luigidellaquila]

Hi @sudhamab

I found a bug and fixed it, it will be released with OrientDB v 3.0.8

Thanks

Luigi

[sudhamab]

thanks Luigi! Glad you found the issue