Code Igniter database transactions

[eluser]kirilisa[/eluser]
Ah yeah after scrolling up and seeing your other comment I kinda figured you were using INNODB by default.

Well it's good to hear that your tests have all indicated things work well when db_debug is set to FALSE. I'm developing a rather enormous app which is going to be fraught with transactions so the bugginess has me quite unhappy!

The freezing is definitely annoying, but what really flips me out is the second thing, how when using trans_start and trans_complete it will in fact update the table if you reload, even though it has crashed with an error. Do you observe this behavior as well?

When I first ran into this problem I did a bunch of hunting on the forums and found a fair number of transaction related posts, eg:
http://ellislab.com/forums/viewthread/68368/
http://codeigniter.com/bug_tracker/bug/4339/
http://codeigniter.com/bug_tracker/bug/4299/ (which I see you posted on)

So it is clear that the whole transaction thing really does need some looking at. I hope that they will get around to it in the next version of CI. I posted this same error in the bug Report forums some weeks ago but unfortunately got no response so I'm not sure how else to submit it.