title: Why I can't insert new row into partially locked table in MySQL 5 InnoDB?
body: <p>In manual it said that InnoDB has row-level locking, so why if I select some of the rows with <code>FOR UPDATE</code> statement it won't let me insert new row into that table? New row shouldn't be locked after all, it wasn't selected.</p>