Suppose the following two statements are executed in parallel:
-- before: col1=val1, col2=val2
UPDATE my_table SET col1=new_val1,col2=new_val2 WHERE col3=val3
SELECT col1,col2 FROM my_table WHERE col3=val3
Is it possible that the select
query returns col1=new_val1,col2=val2
, i.e., partially updated row?