I'm not sure isolation is the right term, but I think it is. Let me know if not.
I'm doing an insert...select statement, from a table with keys into a lock table. I have some WHERE conditions by which I select the row I want.
From what I understand, first a select happens, then the result is used for an insert. The question is, is there a chance that while the insert is happening, my WHERE conditions no longer apply to the row I insert? ie, can another query change the rows I SELECT...INSERTed, or are they locked between the two queries?