It's only atomic in terms of table locking and DML. All tables to be renamed are locked before the rename happens so it's not possible to sneak in some DML between renames in a single rename table statement execution. Is it possible to keep the function of both alter table rename and rename table and just simplify the code path?
On Fri, Dec 12, 2008 at 11:38 AM, Brian Aker <[email protected]> wrote: > Hi! > > I don't see how the command can be atomic internal to the server. We have no > transactional DDL in any engine... I can not see how we would have an "all > or nothing" case occur, especially with a system failure. > > Cheers, > -Brian > > On Dec 12, 2008, at 11:31 AM, Monty Taylor wrote: > >> Brian Aker wrote: >>> >>> Hi! >>> >>> On Dec 12, 2008, at 10:34 AM, Harrison Fisk wrote: >>> >>>> The big advantage with RENAME TABLE is that you can do multiple tables >>>> at a time in an atomic fashion. >>> >>> >>> It is an atomic "command" but that is not an atomic action. >> >> Really? That's potentially unsettling. >> >> >> >>> Cheers, >>> -Brian >>> >>> -- >>> _______________________________________________________ >>> Brian "Krow" Aker, brian at tangent.org >>> Seattle, Washington >>> http://krow.net/ <-- Me >>> http://tangent.org/ <-- Software >>> _______________________________________________________ >>> You can't grep a dead tree. >>> >>> >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~drizzle-discuss >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >> > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Eric Bergen [email protected] http://www.provenscaling.com _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
