Are the change events of a transaction always guaranteed to appear in the order in which they are executed? For example, if two concurrent transactions are being executed, the below sequence shows the order of the operations being maintained even if the transactions themselves are not grouped together.
txn1 - operation1
txn1 - operation2
txn2 - operation1
txn1 - operation3
txn1 - operation4
txn2 - operation2
txn2 - operation3
txn2 - operation4
Is there a possibility of the change events appearing as:
txn1 - operation1
txn1 - operation2
txn2 - operation1
txn1 - operation4
txn1 - operation3
txn2 - operation4
txn2 - operation3
txn2 - operation2