Hi Simon, I think you missed line 7 in the docs ;-)
"This command was introduced in version 2.2." Thanks Luigi 2016-04-20 17:42 GMT+02:00 'Simon White' via OrientDB < [email protected]>: > > So this documentation is completely wrong?! > > http://orientdb.com/docs/2.1/SQL-Update-Edge.html > > > > > > On Wednesday, April 20, 2016 at 4:33:24 PM UTC+1, Ivan Mainetti wrote: >> >> Yes you're right, that feature will be in 2.2 >> >> >> >> Il giorno mercoledì 20 aprile 2016 17:23:07 UTC+2, Simon White ha scritto: >>> >>> 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
