On 4 Aug 2009, at 16:43, Brian Aker wrote:
Hi!
Just a quick note, the multi-table delete,update code was removed
from the tree. This was in an early list and just never happened.
Problems with it:
1) Multi/non-multi had different execution paths.
2) Test cases were added in 5.0 (since it hadn't really had testing).
3) The syntax was not in the SQL standard, and worse causes issues
with VIEWS longterm.
4) Caused a number of conflicts in the parser (all gone).
5) A single wrapped transaction gives you exactly the same thing.
6) WITH RETURNS was not possible with this in the code (which is...
well a thousand times more useful)
I did it as one large patch. Syntax aside.. if someone wanted to fix
the execution paths it might be ok to have, but it adds in all sorts
of other unresolved syntax issues.
I am working through a number of half completed features/oddballs
right now. This was the only user visable one.
As a heads up we are looking at refactoring our milestones right now
to bring Drizzle into production sooner.
But:
1) It's extremely widely used
2) It's extremely useful and convenient *not* to have to do this in a
transaction
This is sad, imho. It also makes migrations of even the simplest
applications a lot more difficult..
Cheers,
--
Mark Leith
MySQL Regional Support Manager, Americas
Sun Microsystems, Inc., http://www.sun.com/mysql/
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
