Feature: Allow dynamic creation of both nodes and edges in relate statements

[nathanschwarz]

Original: Bug: RELATE statement with either a non existing IN / OUT edge should through an error and not make the insertion

Describe the bug

Running a RELATE statement with non existing nodes create a record in the edge and node tables, and do not throw.

Steps to reproduce

run the following queries :

RELATE person:i_do_not_exist->wrote->article:I_exist_or_not;
SELECT * FROM wrote;

will yield a result :

{
        "id": "wrote:doqgupvy005mpnlrs25j",
        "in": "person:i_do_not_exist",
        "out": "article:I_exist_or_not"
}

Expected behaviour

The relate statement should check that both edges exists before inserting in the relation table, and throw if one of the record is not found.

SurrealDB version

surrealDB 1.4 running in a docker container on Mac OS

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct