TRANSACTION DSC工具在迁移MySQL事务处理语句时会根据GaussDB(DWS)特性进行相应适配。 输入示例 1 2 3 4 5 6 7 8 910111213141516 ##该声明仅适用于会话中执行的下一个单个事务SET TRANSACTION ISOLATION LEVEL READ COMMITTED;SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;SET TRANSACTION READ ONLY;SET TRANSACTION READ WRITE;SET TRANSACTION ISOLATION LEVEL READ COMMITTED,READ ONLY;SET TRANSACTION ISOLATION LEVEL SERIALIZABLE,READ WRITE;##使用SESSION关键字,适用于当前会话中执行的所有后续事务START TRANSACTION;SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;commit ; 输出示例 1 2 3 4 5 6 7 8 910111213141516 --该声明仅适用于会话中执行的下一个单个事务SET LOCAL TRANSACTION ISOLATION LEVEL READ COMMITTED;SET LOCAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;SET LOCAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;SET LOCAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;SET LOCAL TRANSACTION READ ONLY;SET LOCAL TRANSACTION READ WRITE;SET LOCAL TRANSACTION ISOLATION LEVEL READ COMMITTED READ ONLY;SET LOCAL TRANSACTION ISOLATION LEVEL SERIALIZABLE READ WRITE;--使用SESSION关键字,适用于当前会话中执行的所有后续事务START TRANSACTION;SET SESSION CHARACTERIS
TICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;SET SESSION CHARACTERISTI
CS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE;SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE;COMMIT WORK;
