How to disable implicit commit

MySQL & MariaDB Other MySQL® Questions
1

Is there any way to disable implicit COMMIT in case of statements like START TRANSACTION, CREATE TABLE etc?

[URL]http://dev.mysql.com/doc/refman/5.1/en/implicit-commit.html[/URL]

It would be very useful for catching hidden application bugs - I never want to commit a transaction if I haven’t run COMMIT statement.

And another question, is there any session status variable, which indicates an open transaction?

Thank you, Vojtech

2

No, and no. The second one is odd, because the protocol and the session actually know that there’s an open transaction – it just isn’t exposed to the user.

3

Thats really odd ( Thank you Baron, I’ll try to simulate it in our acpplication database layer.