MySQL, transactions, loss of connection 1

[sleipnir214]

Can anyone point me to authoritative documentation on MySQL's behavior when a connection breaks during a transaction?

 

[KarveR]

http://www.mysql.com/doc/C/o/Communication_errors.html

***************************************
Party on, dudes!

 

[sleipnir214]

Can someone give me a link or a reference that actually answers my question?

 

[KarveR]

I thought I was rather close, still if you search Mysql.com you may find more cloesly related material, but your question was a bit vague, error codes can be searched for far more easily and google tends to show them quite well. ***************************************
Party on, dudes!

 

[sleipnir214]

It was close, except that it doesn't get around to answering the core question: What is MySQL's behavior is when a connection fails during a transaction?

Here's the specific hypothetical: I have begun a block of statements with BEGIN. I have completed three of the five UPDATE statements I intended to perform when my connection to the server is severed. I never issue the COMMIT statement.

I assume that MySQL would rollback my transaction -- that's that I would have it do if I were writing it. But for purposes of project documentation, I need an authoritative source which definitively states MySQL will rollback or commit the transaction.

 

[KarveR]

Ok heres a few that get close,

http://www.mysql.com/doc/I/n/InnoDB_transaction_model.html

http://www.mysql.com/doc/M/i/Missing_Transactions.html

and how to not use commit or rollback

http://www.mysql.com/doc/C/o/Commit-rollback.html

if you rummage around there some more you may find exactly the wording you are looking for.
Hope this shaves a few months off digging through their site. ***************************************
Party on, dudes!