Cannot execute UPDATE PUT/ADD/INCREMENT

[publicocean0]

OrientDB Version: 3

Java Version: 7

update ... add a = #4:3

give exception Cannot execute with UPDATE PUT/ADD/INCREMENT new executor.

how can i add a item to a set/list? why i can use remove 1 element and not insert 1 element ? It is a temporary bug?

for incrrement i can use :
update 48:24 set a = a+1 instead update 48:24 increment a = 1

[markk12]

i have the same problem. Passing from 2.x to 3.x ...
My scripts do not work anymore. In many cases, my db arrays contain 1000-10000 items, the idea of ​​passing the entire array each time to add only one item does not look so good.

[luigidellaquila]

Hi @publicocean0

This is not a temporary bug, we changed the array syntax a little bit in 3.0, now it's much more flexible and you can add elements on the left on the right with the following:

UPDATE #48:24 SET a = a || #4:3

or

UPDATE #48:24 SET a = #4:3 || a

Full syntax here http://orientdb.com/docs/3.0.x/sql/SQL-Syntax.html#array-concatenation

I know these breaking changes can be a bit annoying during the migration, but we decided to invest a lot on SQL syntax in v 3.0 and we had to sacrifice something. Please check that docs page, you will find a lot of new functionalities

Thanks

Luigi

[publicocean0]

cool :)

[publicocean0]

ops similar problem with put ....
i tried with || dont works
i tried to search in that page sql syntax ... i dont found

update #4:0 put b = "a" , 3

[luigidellaquila]

Hi @publicocean0

UPDATE ... PUT foo = bar, baz

is just syntax sugar for

UPDATE ... SET foo.bar = baz

So you can just use this form

Thanks

Luigi

[publicocean0]

ok thanks .... cool i like new syntax :)

if you could solve the problem also with lucene ... about searching inside field arrays and fiels hashmap having a specific key-vaue it would be great ....i could complete also a new feature i have in mind from long time ahaha

[ebingeorgedct]

how can i use isSet() in an update query. to add only if it does not exist in array