I've found weird transaction behaviour on MYSQL. having ```object TransactionTestTable: LongIdTable(...

# exposed

[than_]

I've found weird transaction behaviour on MYSQL.
having

object TransactionTestTable: LongIdTable(){
    val foo = integer("foo").check { it greater 0 }
}

when I do

newSuspendedTransaction {
    TransactionTestTable.insert { it[foo] = 1 }
    throw IllegalStateException("FAIL")
}

the transaction performs a rollback correctly and nothing gets inserted into the table
but when I do

newSuspendedTransaction {
    TransactionTestTable.insert { it[foo] = 1 }
    TransactionTestTable.insert { it[foo] = 0 }
}

the transaction still fails, but the first value gets inserted in the database.
Is this intentional or a bug?

[benkuly]

I have exactly the same problem. It seems that newSuspendedTransaction always commits at end and don't uses the parent transaction.

[than_]

https://github.com/JetBrains/Exposed/issues/1376#issuecomment-986913775

[than_]

here is a link to the issue

[than_]

problem was useLocalTransactionState set to true when disabled, this problem dissapeared

[benkuly]

and where can I find this property in exposed?

[than_]

you'd have to set it not in exposed but in your connector

[than_]

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-connp-props-performance-extensions.html

[than_]

if you use hikari they expose it in their configuration as well