If my connection allows dirty reads, is it possible that I would get inconsistent results from multiple fields of the same row? Example:
Connection 1:
Update table1 set col1 = 1, col2 = 1 where primarykey = 1
Update table2 set col1 = 2, col2 = 2 where primarykey = 1
Connection 2:
select col1, col2 from table1 where primarykey = 1
is it possible that connection 2 could see non-equal values for col1 and col2? e.g., col1=1 and col2=2 , or, col1=2 and col2=1