The documentation states that REPEATABLE_READ is t...
# exposed
e
The documentation states that REPEATABLE_READ is the default isolation level, but the implementation seems to use READ_COMMITTED for everything but MySQL: https://www.jetbrains.com/help/exposed/transactions.html#r2dbc-transaction-isolation. I assume it's the docs that need updating?
👍 1
o
That's interesting, it looks like it was made like this since the creation of r2dbc module if I don't make a mistake.
Copy code
// JDBC
fun getDefaultIsolationLevel(db: Database): Int =
    when (db.dialect) {
        is SQLiteDialect -> Connection.TRANSACTION_SERIALIZABLE
        is MysqlDialect -> Connection.TRANSACTION_REPEATABLE_READ
        else -> Connection.TRANSACTION_READ_COMMITTED
    }

// R2DBC
fun getDefaultIsolationLevel(db: R2dbcDatabase): IsolationLevel =
    when (db.dialect) {
        is MysqlDialect -> IsolationLevel.REPEATABLE_READ
        else -> IsolationLevel.READ_COMMITTED
    }