Page 1 of 1

Waaayyyyy smurf off!

Posted: Thu Jul 12, 2007 7:59 pm
by BDKR
After trying to figure out what's going on for 90 minutes with some transactonal code that fails to rollback, I find this:

http://bugs.mysql.com/bug.php?id=28727

Holy Crap!!!!!

And that's a MAJOR BUG IMHO! If for no other reason then the fact that MySQL literature (not all of it) leads one to believe that ALTER statements can be rolled back.

That's just wonderful! :evil:

Posted: Thu Jul 12, 2007 8:06 pm
by feyd
Why would you think ALTER can be rolled back?

Posted: Thu Jul 12, 2007 8:15 pm
by Jenk
Because as Laas (bug reporter) explains, it fails ACID standards, which InnoDB claims to pass.

It's also nice to know you can rollback any changes..

Posted: Thu Jul 12, 2007 9:36 pm
by BDKR
Jenk wrote: Because as Laas (bug reporter) explains, it fails ACID standards, which InnoDB claims to pass.

100% agreement here.

It's a good thing at least that my dbUtility class creates a backup of the table to be altered. I guess I can make that part of an manual rollback procedure.