HiLo sequences are being dropped when specifying a default schema

[ChristopherVR]

I'm having an issue where with each new migration file being generated our HiLo sequences are being dropped. This only happens if I add a default schema to the DbContext. This is the result when creating new migrations:

Here is the necessary code to reproduce this issue:

protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
        modelBuilder.HasDefaultSchema("MyDefaultSchema");
        
         modelBuilder.HasSequence<int>("HiLoTestSeq", "MyDefaultSchema")
            .StartsAt(10) // Make provision for defaults
            .IncrementsBy(5);
}
   
public class TestSchemaEntity
{
    public int Id { get; private set; }
}

internal class TestSchemaEntityTypeConfiguration : IEntityTypeConfiguration<TestSchemaEntity>
{
    public void Configure(EntityTypeBuilder<TestSchemaEntity> builder)
    {
        builder.ToTable("TestSchemaTable", "MyDefaultSchema");

        builder.HasKey(r => r.Id);

        builder.Property(r => r.Id).UseHiLo("HiLoTestSeq", "MyDefaultSchema");
    }
}

EF Core version:
Database provider:  Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET 6.0
Operating system: Window 11
IDE:  Visual Studio 2022 16.3

[bricelam]

Looks like this stems from some very strange behavior in FindSequence.

modelBuilder
    .HasDefaultSchema("dbo")
    .HasSequence("TheSequence");

// Not found
model.FindSequence("TheSequence", "dbo");

// Found. Result's schema is dbo
model.FindSequence("TheSequence");

modelBuilder
    .HasDefaultSchema("dbo")
    .HasSequence("TheSequence", "dbo");

// Found
model.FindSequence("TheSequence", "dbo");

// Not found
model.FindSequence("TheSequence");