npgsql/npgsql

When reading a bit type value, I encountered a bug that caused an infinite loop under certain conditions. Please let me know if there is a solution.
For example, the following code will not finish and will continue to run.

using (var conn = new NpgsqlConnection(connnectionString))
{
    conn.Open();

    using (var cmd = conn.CreateCommand())
    {
        cmd.CommandText = @"SELECT 1::bit(100000);";

        using (var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
        {
            reader.Read();
            reader.GetValue(0); // loop!!
        }
    }
}

The cause is that in BitStringHandler , if a bit value cuts across a buffer boundary the last byte of the cannot be read, resulting in an infinite loop. The buf.ReadBytesLeft property remains at 1 and the loop cannot be escaped.

npgsql/BitStringHandler.cs at dev · npgsql/npgsql · GitHub

Above example is terrible, but our application is facing same problem. It reads 16-bit column values, and cuts across a buffer boundary depending on the data state.

It works if CommandBehavior is the default, but we use Dapper, and Dapper's Query method internally sets CommandBehavior.SequentialAccess.

Dapper / SqlMapper.cs at master · StackExchange / Dapper · GitHub

Is there any solution?