Bug: merge does not create the record if it does not exist

[huntipl]

Describe the bug

When calling merge with a RecordID that exists, it updates the specified fields. But when running it with RecordID that does not exist or with Table name only, it does nothing, where the same SurrealQL creates records when they do not exist.

Additionally, when running custom query with UPSERT MERGE it works as expected (creates new records).

Steps to reproduce

# Does nothing, returns None
res = await db.merge(RecordID("test", "id1"), {"key": 1})
print(f"Merge1: {res}")

# Does nothing, returns [] ???
res = await db.merge(Table("test"), {"key": 1})
print(f"Merge2: {res}")

res = await db.create(RecordID("test", "id2"), {"key": 1})
print(f"Create: {res}")

# This works fine
res = await db.merge(RecordID("test", "id2"), {"key2": 2})
print(f"Merge3: {res}")

# This also works fine
res = await db.query(""" UPSERT test MERGE {"key3":3} """)
print(f"Query: {res}")

Result:

Merge1: None
Merge2: []
Create: {'id': RecordID(table_name=test, record_id=id2), 'key': 1}
Merge3: {'id': RecordID(table_name=test, record_id=id2), 'key': 1, 'key2': 2}
Query: [{'result': [{'id': RecordID(table_name=test, record_id=taj7kiqxar7smnc7jnh6), 'key3': 3}], 'status': 'OK', 'time': '158.778µs'}]

Expected behaviour

Assuming the SurrealQL behavior of MERGE is correct, I expect the merge method of the SDK to behave the same way - so create records if they don't exist

SurrealDB version

2.1.4

surrealdb.py version

0.4.1

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