Thanks
Matthew Shannon, September 17, 2016 - 6:53 am UTC
Thanks for the help.
I want (and logically expect) the worker thread to see the value "Queued" once it gets hold of the lock.
I just wanted to double check with DB experts there was no way the worker thread could see the value "New". Such that when the lock released from the primary thread due to its commit, that there was no way the worker thread upon immediately obtaining the lock could somehow see the value "New" value rather than the committed "Queued" value.
thanks again for your help.
September 17, 2016 - 3:01 pm UTC
If you search this site for "write consistency" there's some interesting information about how we handle all of this.