Bug: update merge should not check required fields

[liusong1111]

Describe the bug

update tbl:id merge {} report error says field required but found NONE.

Steps to reproduce

DEFINE TABLE user SCHEMAFULL;
DEFINE FIELD name ON TABLE user TYPE string;
DEFINE FIELD nickname ON TABLE user TYPE opiton<string>;

CREATE user:sliu CONTENT { name: "sliu" };

UPDATE user:sliu MERGE {};

the last UPDATE statement report error:

'Found NONE for field `name`, with record `user:sliu`, but expected a string'

Expected behaviour

UPDATE user:sliu MERGE {};

should execute successfully and update no fields.

SurrealDB version

v1.4.2

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

[Dhghomon]

Thanks for the issue! It should indeed execute successfully and update nothing.