I may have been mistaken about that rollback not happening. Sorry for the false alarm.
Shawn On Apr 15, 3:46 am, Jeremy Evans <[email protected]> wrote: > On Apr 14, 2:49 am, Shawn <[email protected]> wrote: > > > I just executed multiple operations inside a transaction: > > > db.transaction do > > > # db op1 > > # db op2 > > # db op3 > > ... > > end > > > op3 was an explicit SQL operation (db << sql_string), and it failed > > due to a syntax error. However, operations 1 and 2 took effect did > > not rollback. Why not? > > Probably because the database doesn't support transactions for what > you are doing. For example, MySQL's MyISAM table engine (the default > I believe) doesn't support transactions, and a few databases including > MySQL don't support transactions for schema modifications. > > Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
