Cant Select Updated Node

[kapilpipaliya]

I run this query first, it create a node:
CREATE (n:AttributesType {id: 'a'}) return n
then I update it with following query:

MATCH (n:AttributesType {id: 'a'})
SET n+={id: 'a2'}
RETURN n

now this query is returning 0 nodes, but it should return 1 node:
MATCH (n:AttributesType {id: 'a2'}) RETURN n

[kapilpipaliya]

I cant replace all properties of the node:

MATCH (n:AttributesType {id: 'a'})
SET n={id: 'a2'}
RETURN n

[niclasko]

Many thanks for your comments :-)

Updating the attributes of a node with set-statement does not update the node-attribute-index (which is set when creating/merging a new node to the database). The actual attribute does change however, and you can lookup the node using a where-statement like this:
match (n) where n.id = 'a2' return n
I certainly agree that this is a shortcoming and in this case the node-attribute-index should indeed be updated as well (remove the pointer to node from the old attribute value ('a') and add a new pointer from new attribute value ('a2')). Good catch!

For your second issue (replace all properties of the node using set n={id:'a2'}), this is not implemented as I have never had a need for it, but I believe it could be useful.

Not sure when I will have the time to fix these things, but I am grateful for your valuable feedback :-)

[kapilpipaliya]

Thank you very much for replying.

can you please also tell me how to delete a node?

Thanks.

[niclasko]

Hello again. Great question. Deleting nodes, relationships or properties is not implemented yet unfortunately.