How to modify a LINKSET after initial vertex creation

[Bill Blondin]

I have a simple model:

App   ---users--->   User

.xOut

where App has a LINKSET property, "xOut".

xOut is intended to contain a collection of "users" edge RID values.

No matter what I do, I can only set the xOut collection when I create a new vertex record.  Once that initial value is set, I can not add to it.

This syntax will create a new record and set the collection:

create vertex App set Name="app2", xOut=[#14:0]

None of the following will do anything to change the xOut collection:

update App add app.xOut = [#14:1] where @rid=#12:1

update #12:1 add app.xOut = [#14:1]

Explicit reset of the collection seems to work, but it's not a great solution if the list is long:

update App set xOut = [#14:1] where @rid=#12:1 

update #12:1 xOut = [#14:1]

 

The statements all appear to execute, but when I SELECT FROM App, I just get back the initial values that were saved when the vertex was created when using the "add" statements.

Am I missing something?

Bill 

[alessand...@gmail.com]

Hi Bill,

which version of OrientDb are you using?

Alessandro

[Bill Blondin]

latest production 2.0.11

[alessand...@gmail.com]

Hi Bill,

if you use orientdb-2.1-rc3, the following instructions work

update App add xOut = [#14:1] where @rid=#12:1

update #12:1 add xOut = [#14:1]

Alessandro

[Bill Blondin]

Thanks, I'll give it a try on the rc version

[Bill Blondin]

Just installed latest rc version (2.1 rc4), and now I receive the following errors when attempting to execute the following statements:

update #13:0 add xOut=#16:1

 Error on parsing command at position #21: Found unexpected keyword '=#16:1' while it was expected '[=]'.  

 

update #13:0 add User.xOut=#16:1

Error on parsing command at position #26: Found unexpected keyword '=#16:1' while it was expected '[=]'. 

update User add User.xOut=#16:1 where @rid=#13:0

 Error on parsing command at position #25: Found unexpected keyword '=#16:1' while it was expected '[=]'. 

update User add xOut=#16:1 where @rid=#13:0

Error on parsing command at position #20: Found unexpected keyword '=#16:1' while it was expected '[=]' 

update #13:0 add xOut=[#16:1]

Error on parsing command at position #21: Found unexpected keyword '=[#16:1]' while it was expected '[=]'. 

update #13:0 add User.xOut=[#16:1]

Error on parsing command at position #26: Found unexpected keyword '=[#16:1]' while it was expected '[=]'. 

update User add xOut=[#16:1] where @rid=#13:0

Error on parsing command at position #20: Found unexpected keyword '=[#16:1]' while it was expected '[=]'. 

[alessand...@gmail.com]

Hi Bill,

I try the query from the browse in Visual Studio and it works.

Alessandro

[Bill Blondin]

see attached

[alessand...@gmail.com]

Hi,

I have tried with version (2.1 rc4) and the query works ( see attached)

Alessandro

[Bill Blondin]

Perhaps there was an install issue on my end. I will try again.