In the previous post we checked lock requests while
executing INSERT INTO t ... SELECT FROM tt where there is
an auto_increment column for which the value is generated
in the destination table with default
innodb_autoinc_lock_mode=1. Based on it I've
reported Bug #76563 that is already verified.
Let's continue to study a special case of the statement mentioned above, INSERT INTO t ... SELECT FROM t, that …