Cannot INSERT into Type.LINK a rid value returned from a nested SELECT (original) (raw)
ArcadeDB Version:
v23.5.1-SNAPSHOT (build d65cada/1684331816646/main)
OS and JDK Version:
Windows 10 10.0 - OpenJDK 64-Bit Server VM 11.0.12 (Corretto-11.0.12.7.1)
Expected behavior
I have a document type (let's call it B) that contains a property of Type.LINK (let's call it link), which points to a property in another document type (let's call it A).
If I select the rid from A, retrieve it as a RID object and then use it as a parameter in a prepared INSERT statement, it works: the rid value is inserted into the LINK property.
I thought it should be possible to accomplish the same result in one SQL command: "INSERT INTO B SET link = (SELECT @rid A WHERE [...]"
Actual behavior
If I insert the rid value obtained from a nested select, the engine inserts null.
Steps to reproduce
Execute the attached test case.