3) Even though the nested transaction has committed but since the parent transaction is rollback, shouldn't the change in the nested transaction rollback as well? This is not what
I am seeing with the example given in 2).
I got mixed up with nested subtransaction on this one. The internal nested transaction is top level so it is independent of the parent. Please ignore this question. =)
