MySql.Data version 8.0.31 doesn't set right isolation level
Posted by: Aniruddha Prasad
Date: October 20, 2022 05:48PM

When using MySql.Data version 8.0.31 with .Net 6.0, when the isolation level is set for a command, the command is executed at the default isolation level.

The sample below demonstrates the issue:

[TestMethod]
public void TestBuggyIso()
{
var connection = new MySqlConnection(ConnectionString);
connection.Open();
var transaction = connection.BeginTransaction(System.Data.IsolationLevel.Serializable);
MySqlCommand command = new("SELECT @@transaction_isolation;", connection, transaction);
var reader = command.ExecuteReader();
while (reader.Read())
{
string value = reader.GetString(0);
Assert.AreEqual(value, "SERIALIZABLE");
}
}

Here the isolation level should be Serializable but I see that the isolation level is set to REPEATABLE-READ.

Options: ReplyQuote


Subject
Written By
Posted
MySql.Data version 8.0.31 doesn't set right isolation level
October 20, 2022 05:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.