Currently, START TRANSACTION does not allow READ ONLY and WITH CONSISTENT SNAPSHOT to be used at the same time. Multiple transaction properties need to be separated by commas. e.g. START TRANSACTION WITH CONSISTENT SNAPSHOT, READ ONLY
Modification:
Correct transaction statement building
Correct incorrect description in javadoc of MySqlTransactionDefinition
Add unit test for transaction statement building
Add integration test for start transaction with consistent and read only
Result:
READ ONLY and WITH CONSISTENT SNAPSHOT can be used simultaneously in a transaction.
Motivation:
Currently,
START TRANSACTION
does not allowREAD ONLY
andWITH CONSISTENT SNAPSHOT
to be used at the same time. Multiple transaction properties need to be separated by commas. e.g.START TRANSACTION WITH CONSISTENT SNAPSHOT, READ ONLY
Modification:
MySqlTransactionDefinition
Result:
READ ONLY
andWITH CONSISTENT SNAPSHOT
can be used simultaneously in a transaction.