Cannot create an Edge from and to the same Vertex

[morkai]

Tested on 1.3.0 and 1.4.0-SNAPSHOT from 2013-01-24.

The following SQL:

CREATE VERTEX OGraphVertex
CREATE EDGE OGraphEdge FROM #8:0 TO #8:0

fails with the following error:

Error: com.orientechnologies.orient.core.exception.OConcurrentModificationException: Cannot UPDATE the record #8:0 because the version is not the latest. Probably you are updating an old record or it has been modified by another user (db=v1 your=v0)

The edge is created but without the in/out properties. SELECT FROM #9:0 returns:

{
  "result": [{
      "@type": "d", "@rid": "#9:0", "@version": 0
    }
  ]
}

(selecting/deleting all edges won't include/delete this one) and the RID of #9:0 is added to the out property of the vertex.

Creating an edge from and to the same vertex using INSERT and UPDATE works:

INSERT INTO OGraphVertex
INSERT INTO OGraphEdge SET out=#8:0, in=#8:0
UPDATE #8:0 ADD out = #9:0
UPDATE #8:0 ADD in = #9:0

btw. update #8:0 add out=#9:0 doesn't work:

Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #19: Found unexpected keyword '=#9:0' while it was expected '[=]'. Use UPDATE <class>|cluster:<cluster>> [SET|ADD|PUT|REMOVE|INCREMENT] [[,] <field-name> = <expression>|<sub-command>]* [WHERE <conditions>]
Command: update #8:0 add out=#9:0
---------------------------^

Add a space before and after the = and it works (while spaces or no spaces in INSERT is OK).

[lvca]

Use the create vertex and create edge commands to work with graph elements.

[morkai]

create vertex and create edge commands do not work in this case (insert and update do). That's the issue.

[lvca]

What does man "do not work"? Exceptions? Crash? Edge/Vertex not created?

[morkai]

As I wrote before:

Error: com.orientechnologies.orient.core.exception.OConcurrentModificationException: Cannot UPDATE the record #8:0 because the version is not the latest. Probably you are updating an old record or it has been modified by another user (db=v1 your=v0)

[lvca]

OK, let me create a test case

[lvca]

Postponed.

[lvca]

Already fixed in 1.7.9