Bug: Record IDs generated with rand() ulid() uuid() in custom functions generate same value

[bsheldrick]

Describe the bug

When using a random record id function to create a new record e.g. CREATE thing:ulid() in a custom function the value generated is the same on each function call. This results in a duplicate key error on subsequent calls.

Steps to reproduce

Define a function that creates records using a random function. In this example using ulid():

DEFINE FUNCTION fn::create_record_with_ulid($data: any) {
    LET $thing = CREATE thing:ulid() CONTENT {
        data: $data
    } RETURN AFTER;

    RETURN $thing;
};

Call the function wrapped in a transaction:

BEGIN TRANSACTION;
RETURN fn::create_record_with_ulid({ a: "b" });
COMMIT TRANSACTION;

The first call of the function will succeed. But any subsequent calls will produce an error:

Database record thing:01H5AB5KR7P6SCN9CV2E3B83AK already exists

This is the same behavior with the other random functions rand() and uuid(). I have only experienced this in custom functions.

A workaround to avoid this is to use the type::thing() function to create the record id in the custom function. For example.

DEFINE FUNCTION fn::create_record_with_ulid($data: any) {
    LET $id = type::thing("thing", rand::ulid());
    LET $thing = CREATE $id CONTENT {
        data: $data
    } RETURN AFTER;

    RETURN $thing;
};

Expected behaviour

I expect a new random record id to be generated when using rand() or ulid() or uuid() record id shortcuts to create records in a custom function.

SurrealDB version

1.0.0-beta.9+20230402.5eafebd for linux on x86_64

Contact Details

No response

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