HasFilter not being applied on MySql

Question

Iam trying to add this index on mysql database. The unique index is created but HasFilter isValid condition is not applied. Can anyone please help me what may be issue. isValid is tinyint(1) in the database

entityBuilder.HasIndex(e => new { e.LevelId, e.isValid, e.DeletedAt })
    .IsUnique()
    .HasFilter("isValid = 0");