Hi-
Is there a way I can draw a diagram and match it to my input in isql?
I am trying to set the default transaction in each of my isql clients that are
open in separate windows.
In each isql I type: set transaction wait isolation level read committed.
I tried to make a chart like this to document what I am doing.
isql-1 isql-2
__________________________________________
980- tid | 982
_________________________________________________
update | update/wait
___________________________________________________
commit (no error)
___________________________________________________
new tid - 984 | 982
___________________________________________________
update/wait | update
____________________________________________________
| commit (error)
___________________________________________________
984 | 986 new tid
on p. 196 of volume 2 it says:
with no record_version - "it blocks this transaction from writing a new
version of the row...."
with wait : (allowable if - its own tid is newer than the other transactions
tid)
I don't want to retype the exact wording out of helen's book because of
copyright.
my diagram and the data in it don't make sense to me. on wait, if my tid is
newer (higher #)
than the other tid, why do I get the deadlock error?
I hope there is an easy way for someone to demonstrate this to me.
I wish I had tried this experiment with trying to figure out transactions a
long
time ago. I didn't realize I'd get this stuck.
Please assist-
I am really lost on this one. Not sure what I am missing.
thanks (3rdshiftcoder)
