Motivation:

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.