test

ensure the LEFT JOIN behaves as expected #1052

Job	Run time
linux-integration-mysql	4m 21s
linux-integration-mongo	3m 28s
linux-integration-psql	4m 49s
linux-integration-sqlite	2m 9s
unit-tests / api-breakage	2m 39s
unit-tests / linux-unit (swift:5.9-jammy, debug)	2m 2s
unit-tests / macos-unit (macos-14, latest-stable)	2m 7s
unit-tests / lint	0s
unit-tests / linux-unit (swift:5.10-noble, debug)	2m 30s
unit-tests / macos-unit (macos-15, latest-stable)	1m 43s
unit-tests / linux-unit (swift:6.0-noble, debug)	2m 22s
unit-tests / linux-unit (swift:6.0-noble, release)	29s
unit-tests / ios-unit	0s
unit-tests / musl	0s
unit-tests / windows-unit	0s
	28m 39s

Provide feedback