Thank you Grant,

Your answer gave me an insight to the roots of my misunderstanding. I was living with an idea of SELECT statement being an atomic operation.

But it appears...