Hi! > What I am wondering is if we can do the same with alter table.
Well, for ALTER TABLE I guess you would lose the ability to rename multiple tables. That or the syntax would get pretty weird? > > Really though? This should be transactional DDL. > > Cheers, > --Brian > > On Dec 12, 2008, at 11:51 AM, "Eric Bergen" <[email protected]> wrote: > >> 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 > -- Roland Bouman http://rpbouman.blogspot.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
