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
