I also get different behaviour between MyISAM (default engine) and InnoDB - locking seems to work as specified when using InnoDB tables.
I also get different behaviour between MyISAM (default engine) and InnoDB - locking seems to work as specified when using InnoDB tables.