Bug #110791 OpenAsync(CancellationToken) doesn't throw for cancelled token

Description:
If MySqlConnection.OpenAsync(CancellationToken) is called with a cancelled CancellationToken, and if there is a ready connection in the pool, the pooled connection is returned. The expectation is that any method called with a cancelled CancellationToken will throw a TaskCanceledException.

This was fixed in 8.0.30 for bug #106243 but now regressed in 8.0.33.

How to repeat:
Run the following C# code. Expectation is that an exception is thrown from the last line, but it is not.

using var connection = new MySqlConnection("...");
connection.Open();
connection.Close();

using var cts = new CancellationTokenSource();
cts.Cancel();
await connection.OpenAsync(cts.Token);

Hello Bradley Grainger,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil

Could not be reproduced in Connector/NET 8.2.0.

Please reopen or file a new bug if the problem persists.

I can repro the problem with MySql.Data 8.3.0 using the code in the original bug report.

The last line should throw an exception, but it doesn't.

Note: it is necessary to have an open connection in the pool to reproduce the bug. Opening a new connection with a cancelled CancellationToken will throw an exception, as expected.