ArcadeDB Server v26.2.1-SNAPSHOT (build e960ee81eeed15581b7b659be926edcf788c6279/1770105344398/main)
Running on Linux 6.14.0-37-generic - OpenJDK 64-Bit Server VM 21.0.9
Using a query result sets as argument for CREATE EDGE causes the error:
Invalid vertex for edge creation: {@rid: #1:0}
For the following example:
CREATE VERTEX TYPE V;
CREATE EDGE TYPE E;
INSERT INTO V;
Then this fails:
LET $x = SELECT @rid FROM V;
CREATE EDGE E FROM $x.@rid TO $x.@rid
And also this fails:
CREATE EDGE E FROM (SELECT @rid FROM V).@rid TO (SELECT @rid FROM V).@rid
However, this works:
LET $x = (SELECT @rid FROM V).@rid;
CREATE EDGE E FROM $x TO $x