How to disable implicit commit

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

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

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.

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