Hello,
Is it possible theoretically or rather is it SQL compliant that a single select in one unit of work to give a result set that duplicates a row with the same PK? The select would be issued using READ_COMMITED isolation level and looks like this: "select col1, pk from table where col1=1 or col1=2 order by pk"
Of course there is another app that runs in parallel and updates some rows by changing the col1 column from 1 to 2.
Can the result set contain rows with the same pk but with different col1.
And if this is possible, can this be rated as phantom read manifestation?
A theoretical cover of the issue would be much appreciated.
Regards, Horia Muntean
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
