[Test, IssueLink("https://github.com/npgsql/npgsql/issues/4365")]
public async Task In_different_schemas_same_type_with_child()
{
	var csb = new NpgsqlConnectionStringBuilder(ConnectionString)
	{
		ApplicationName = nameof(In_different_schemas_same_type_with_child),  // Prevent backend type caching in TypeHandlerRegistry
		Pooling = false
	};

	await using var conn = await OpenConnectionAsync(csb);

	await using var _ = await CreateTempSchema(conn, out var firstSchemaName);
	await using var __ = await CreateTempSchema(conn, out var secondSchemaName);

	await conn.ExecuteNonQueryAsync($"CREATE TYPE {firstSchemaName}.child_composite AS (name text)");
	await conn.ExecuteNonQueryAsync($"CREATE TYPE {firstSchemaName}.composite AS (id int, child {firstSchemaName}.child_composite)");
	await conn.ExecuteNonQueryAsync($"CREATE TYPE {secondSchemaName}.child_composite AS (name text)");
	await conn.ExecuteNonQueryAsync($"CREATE TYPE {secondSchemaName}.composite AS (id int, child {secondSchemaName}.child_composite)");

	await conn.ExecuteNonQueryAsync(
		@$"
CREATE TABLE {firstSchemaName}.composite_table (mycomposite {firstSchemaName}.composite);
INSERT INTO {firstSchemaName}.composite_table VALUES(ROW(1, ROW('1')));

CREATE TABLE {secondSchemaName}.composite_table (mycomposite {secondSchemaName}.composite);
INSERT INTO {secondSchemaName}.composite_table VALUES(ROW(2, ROW('2')));
		");

	conn.ReloadTypes();
	conn.TypeMapper
		.MapComposite<ChildComposite>($"{firstSchemaName}.child_composite")
		.MapComposite<ParentComposite>($"{firstSchemaName}.composite")
		.MapComposite<ChildComposite>($"{secondSchemaName}.child_composite")
		.MapComposite<ParentComposite>($"{secondSchemaName}.composite");
	await using var cmd = conn.CreateCommand();
	cmd.CommandText = $"SELECT * FROM {firstSchemaName}.composite_table; SELECT * FROM {secondSchemaName}.composite_table";
	await using var reader = await cmd.ExecuteReaderAsync();
	Assert.IsTrue(await reader.ReadAsync());
	Assert.That(reader.GetDataTypeName(0), Is.EqualTo($"{firstSchemaName}.composite"));
	var firstParentComposite = reader.GetFieldValue<ParentComposite>(0);
	Assert.That(firstParentComposite.ID, Is.EqualTo(1));
	Assert.NotNull(firstParentComposite.Child);
	Assert.That(firstParentComposite.Child!.Name, Is.EqualTo("1"));
	Assert.IsTrue(await reader.NextResultAsync());
	Assert.IsTrue(await reader.ReadAsync());
	Assert.That(reader.GetDataTypeName(0), Is.EqualTo($"{secondSchemaName}.composite"));
	var secondParentComposite = reader.GetFieldValue<ParentComposite>(0);
	Assert.That(secondParentComposite.ID, Is.EqualTo(2));
	Assert.NotNull(secondParentComposite.Child);
	Assert.That(secondParentComposite.Child!.Name, Is.EqualTo("2"));
}

class ParentComposite
{
	public int ID { get; set; }
	public ChildComposite? Child { get; set; }
}

class ChildComposite
{
	public string? Name { get; set; }
}