I was poking around sql.py tonight and noticed something odd: distributed_transaction_begin has code for mysql and postgres distributed_transaction_commit has code for mysql, postgres, and firebird.
The exception in begin says it only works on postgres though it has code for both postgres and mysql, the exception in commit says it only works in firebird and postgres though there is code for all three databases. Is there supposed to be code in begin for Firebird? http://www.web2py.com/AlterEgo/default/show/101 also states that distributed transactions are only available on postgres. http://www.mail-archive.com/[email protected]/msg24164.html seems to be where firebird was added and states that the way to use it is to call begin, make your updates, then call commit. However, unless I'm missreading the code, the exception in begin should fire preventing this from working. Am I missing something with the code or has the unit tests for this not been working since last October? Or did this break sometime after?
