As far as I can tell this *does not maintain graph consistency* i.e. automatically remove the out edge on the old vertex and set it on the new - it simply updates the edge so I would have to manage the edges myself. The documentation suggests that update edge would do this for me?
On Wednesday, April 20, 2016 at 4:16:43 PM UTC+1, Ivan Mainetti wrote: > > Hi, > > use this: > > UPDATE 50:12 SET out=14:10 > > > > Il giorno mercoledì 20 aprile 2016 17:09:05 UTC+2, Simon White ha scritto: >> >> I am probably being stupid but I am trying to run the sql UPDATE EDGE >> command (from the docs http://orientdb.com/docs/2.1/SQL-Update-Edge.html) >> >> But I can't get it to run.... >> >> UPDATE EDGE Friend SET out = (SELECT FROM #14:10) WHERE @rid = '#50:12' >> >> >> >> >> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error >> on parsing command at position #0: Error parsing query: UPDATE EDGE Friend >> set out = #14:10 Encountered " <EDGE> "EDGE "" at line 1, column 8. Was >> expecting one of: <TO> ... <VALUES> ... <SET> ... <ADD> ... <PUT> ... >> <MERGE> ... <CONTENT> ... <REMOVE> ... <ORDER> ... <GROUP> ... <OFFSET> ... >> <RECORD> ... <LUCENE> ... <NEAR> ... <WITHIN> ... <EXCEPTION> ... <FIND> >> ... <REFERENCES> ... <THIS> ... <RECORD_ATTRIBUTE> ... <INTEGER_LITERAL> >> ... "(" ... "[" ... "?" ... ":" ... "-" ... "*" ... <IN> ... <KEY> ... >> <CLUSTER> ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <INDEX_IDENTIFIER> >> ... <INDEXVALUES_IDENTIFIER> ... <INDEXVALUESASC_IDENTIFIER> ... >> <INDEXVALUESDESC_IDENTIFIER> ... <CLUSTER_IDENTIFIER> ... >> <CLUSTER_NUMBER_IDENTIFIER> ... <METADATA_IDENTIFIER> ... "#" ... >> >> I need to update the OUT value of an edge whilst maintaining the graph >> consistency with vertices and *without recreating the edge* >> > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.