Does anyone know this?
In the 4.0.17 and later build, the target table of an INSERT...SELECT can be
the same as the SELECT table (insert into table1...select ...from table1).
Does the process essentially happen in a natural lock? In other words,
could the table change between the data retrieved
In the 4.0.17 and later build, the target table of an INSERT...SELECT can be
the same as the SELECT table (insert into table1...select ...from table1).
Does the process essentially happen in a natural lock? In other words,
could the table change between the data retrieved in the select and the
