The documentation states that REPEATABLE_READ is t...

# exposed

[Erlend Halvorsen]

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?

[Oleg Babichev]

That's interesting, it looks like it was made like this since the creation of r2dbc module if I don't make a mistake.

// 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
    }