Bug: subquery runs create twice

[EllisVerhoest]

Describe the bug

A CREATE subquery causes the document to be created twice

Steps to reproduce

DELETE FROM person,address;

CREATE ONLY person CONTENT {
	address: (CREATE ONLY address CONTENT {
		city: "Whiterun"
	})
};

SELECT * FROM person;
SELECT * FROM address;

-------- Query 1 (286.108µs) --------

[]

-------- Query 2 (654.175µs) --------

{
	address: {
		city: 'Whiterun',
		id: address:omd5nanwq9tb21ebrtoq
	},
	id: person:0au96ptpf4t38j53ixfn
}

-------- Query 3 (82.009µs) --------

[
	{
		address: {
			city: 'Whiterun',
			id: address:omd5nanwq9tb21ebrtoq
		},
		id: person:0au96ptpf4t38j53ixfn
	}
]

-------- Query 4 (61.151µs) --------

[
	{
		city: 'Whiterun',
		id: address:8z0fei97lju8f9b7wwi1
	},
	{
		city: 'Whiterun',
		id: address:omd5nanwq9tb21ebrtoq
	}
]

Expected behaviour

The subquery create should only create one address document.

SurrealDB version

2.0.0+20240513.1c09e18 for linux on x86_64

Contact Details

ellis.v@aspirecomps.co.uk

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