Waaayyyyy smurf off!

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Waaayyyyy smurf off!

Post 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:
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Why would you think ALTER can be rolled back?
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post 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..
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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.
Post Reply