Oh sorry - I *did* miss that!! :) But look at the URI I posted... it says 2.1, surely this page should not appear in 2.1 if it is a 2.2 feature.
Anyway... any chance you could help me write the commands to manually update the edges? from A ----> friend ----> B to A ----> friend ----> C something like.... 1. Update B remove in friend 2. Update friend set out C 3. Update C set in friend On Wednesday, April 20, 2016 at 4:44:09 PM UTC+1, Luigi Dell'Aquila wrote: > > 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] <javascript:>>: > >> >> 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] <javascript:>. >> 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.
