Would this be considered as both Read-Write conflict and Write-Write conflict?
Read-Write conflict - b/c Transaction A is writing to what B is reading and vice versa.
Write-Write conflict - b/c Transaction A is writing to where Transaction B is writing
solovoy
If transaction B doesn't write to 3 but only read 3, there will also be conflicts, right?
cgjdemo
@solovoy I think if transaction B doesn't write to 3 but only read 3, there is a READ-WRITE conflict. Only shared read does not have conflicts and any write should have exclusive access to the node it updates.
Faust
@solovoy If transaction B does not write to 3 but reads 3, there will be a conflict because transaction B cannot read anything that transaction A writes to (3) for this particular case of transactions.
Would this be considered as both Read-Write conflict and Write-Write conflict?
Read-Write conflict - b/c Transaction A is writing to what B is reading and vice versa.
Write-Write conflict - b/c Transaction A is writing to where Transaction B is writing
If transaction B doesn't write to 3 but only read 3, there will also be conflicts, right?
@solovoy I think if transaction B doesn't write to 3 but only read 3, there is a READ-WRITE conflict. Only shared read does not have conflicts and any write should have exclusive access to the node it updates.
@solovoy If transaction B does not write to 3 but reads 3, there will be a conflict because transaction B cannot read anything that transaction A writes to (3) for this particular case of transactions.