I just marked atomic because I would not want to go so far as to say that it should be transactional.
So I meant, RENAME TABLE should be atomic in the sense that it is executed in an all or nothing manner. AFAIC, it is not so important to be able to say, start a transaction, insert some rows, rename table, do an update, and then do rollback to undo all changes. On Sat, Dec 13, 2008 at 10:14 PM, Brian Aker <[email protected]> wrote: > Does atomic mean all or nothing, or best effort? I would like to understand > what Brian Moon was doing. > > Cheers, > --Brian > > On Dec 13, 2008, at 1:11 PM, "Roland Bouman" <[email protected]> > wrote: > >> Hi! >> >> well, it should at least be *atomic* >> >> On Sat, Dec 13, 2008 at 9:34 PM, Brian Aker <[email protected]> wrote: >>> >>> What I am wondering is if we can do the same with alter table. >>> >>> 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/ > -- 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
