There are many cases where MySQL supports the syntax but not the functionality. It silently accepts what you enter (whether it is data definition or queries) but it does not do what you think it should do. Most of this has to do with using MyISAM tables but features that only in InnoDB. See here for details http://sql-info.de/mysql/gotchas.html On 9/27/05, Nicolas Tostin <nicolast@logis.com.mx> wrote:
until now we've largely ignored people who aren't allowed to lock their tables and thus cannot use Drupal. Somebody suggested (http://drupal.org/node/1190#comment-55984) to use SELECT FOR UPDATE in database.mysql.inc instead. Is there any database expert who can comment on the pros and cons of the approach?
I remember we discuss this a few monthes ago see http://drupal.org/node/21439 The problem is that you need MySQL 4 and InnoDb tables to use this.