https://bugzilla.wikimedia.org/show_bug.cgi?id=47055
--- Comment #15 from Marc A. Pelletier <[email protected]> --- (In reply to comment #10) > PostgreSQL has an > extended FOR UPDATE syntax. You can do "FOR UPDATE OF mytable", which will > only > lock that table. Hmm, no. FOR UPDATE OF isn't a postgres extension, but a part SQL which mysql doesn't implement fully (SQL:2003 14.1.). But yeah, trying to lock on an outer join is fundamentally nonsensical, and mysql not throwing an exception is a standard compliance bug at best - it's unwise to rely on that kind of behaviour. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
