This is an automated email from the ASF dual-hosted git repository.
panjuan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new cd8e2bd change camel case sql-case-ids to snake case (#12901)
cd8e2bd is described below
commit cd8e2bde275a5cba9e1405f9f9e6daca7c95f0df
Author: Thanoshan MV <[email protected]>
AuthorDate: Tue Oct 5 15:54:28 2021 +0530
change camel case sql-case-ids to snake case (#12901)
---
.../main/resources/case/tcl/begin-transaction.xml | 8 ++---
.../src/main/resources/case/tcl/commit.xml | 16 +++++-----
.../src/main/resources/case/tcl/rollback.xml | 10 +++----
.../main/resources/case/tcl/set-auto-commit.xml | 12 ++++----
.../main/resources/case/tcl/set-constraints.xml | 6 ++--
.../main/resources/case/tcl/set-transaction.xml | 34 +++++++++++-----------
.../sql/supported/tcl/begin-transcation.xml | 8 ++---
.../main/resources/sql/supported/tcl/commit.xml | 16 +++++-----
.../main/resources/sql/supported/tcl/rollback.xml | 10 +++----
.../sql/supported/tcl/set-auto-commit.xml | 12 ++++----
.../sql/supported/tcl/set-constraints.xml | 6 ++--
.../sql/supported/tcl/set-transaction.xml | 34 +++++++++++-----------
12 files changed, 86 insertions(+), 86 deletions(-)
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/begin-transaction.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/begin-transaction.xml
index 379b678..03acb89 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/begin-transaction.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/begin-transaction.xml
@@ -18,11 +18,11 @@
<sql-parser-test-cases>
<begin-transaction sql-case-id="begin" />
- <begin-transaction sql-case-id="beginTransaction" />
- <begin-transaction sql-case-id="beginWithName" />
+ <begin-transaction sql-case-id="begin_transaction" />
+ <begin-transaction sql-case-id="begin_with_name" />
<begin-transaction sql-case-id="begin_with_variable_name" />
- <begin-transaction sql-case-id="beginReadCommitted" />
- <begin-transaction sql-case-id="beginReadOnly" />
+ <begin-transaction sql-case-id="begin_read_committed" />
+ <begin-transaction sql-case-id="begin_read_only" />
<begin-transaction sql-case-id="begin_with_transaction_mode" />
<begin-transaction sql-case-id="begin_with_mark_transaction" />
<begin-transaction sql-case-id="begin_distributed_transaction" />
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/commit.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/commit.xml
index 7278ba9..edfd8b6 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/commit.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/commit.xml
@@ -19,13 +19,13 @@
<sql-parser-test-cases>
<commit sql-case-id="commit" />
<commit sql-case-id="commit_transaction" />
- <commit sql-case-id="commitWithName" />
- <commit sql-case-id="commitWithComment" />
- <commit sql-case-id="commitForce" />
- <commit sql-case-id="commitPrepare" />
+ <commit sql-case-id="commit_with_name" />
+ <commit sql-case-id="commit_with_comment" />
+ <commit sql-case-id="commit_force" />
+ <commit sql-case-id="commit_prepare" />
<commit sql-case-id="commit_in_pg" />
- <commit sql-case-id="commitWorkWithComment" />
- <commit sql-case-id="commitWork" />
- <commit sql-case-id="commitWriteBatch" />
- <commit sql-case-id="commitWorkForce" />
+ <commit sql-case-id="commit_work_with_comment" />
+ <commit sql-case-id="commit_work" />
+ <commit sql-case-id="commit_write_batch" />
+ <commit sql-case-id="commit_work_force" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/rollback.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/rollback.xml
index 940c026..0347a0a 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/rollback.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/rollback.xml
@@ -19,11 +19,11 @@
<sql-parser-test-cases>
<rollback sql-case-id="rollback" />
<rollback sql-case-id="rollback_transaction" />
- <rollback sql-case-id="rollbackWithName" />
- <rollback sql-case-id="rollbackToSavepoint" />
- <rollback sql-case-id="rollbackForce" />
- <rollback sql-case-id="rollbackPrepare" />
+ <rollback sql-case-id="rollback_with_name" />
+ <rollback sql-case-id="rollback_to_savepoint" />
+ <rollback sql-case-id="rollback_force" />
+ <rollback sql-case-id="rollback_prepare" />
<rollback sql-case-id="rollback_in_pg" />
- <rollback sql-case-id="rollbackWorkForce" />
+ <rollback sql-case-id="rollback_work_force" />
<rollback sql-case-id="abort" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-auto-commit.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-auto-commit.xml
index c642060..2b5c8d0 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-auto-commit.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-auto-commit.xml
@@ -17,10 +17,10 @@
-->
<sql-parser-test-cases>
- <set-auto-commit sql-case-id="setAutoCommitOn" auto-commit="true" />
- <set-auto-commit sql-case-id="setAutoCommitOnWithScope" auto-commit="true"
/>
- <set-auto-commit sql-case-id="setAutoCommitOff" auto-commit="false" />
- <set-auto-commit sql-case-id="setAutoCommitOffWithScope"
auto-commit="false" />
- <set-auto-commit sql-case-id="setImplicitTransactionsOn"
auto-commit="true" />
- <set-auto-commit sql-case-id="setImplicitTransactionsOff"
auto-commit="false" />
+ <set-auto-commit sql-case-id="set_auto_commit_on" auto-commit="true" />
+ <set-auto-commit sql-case-id="set_auto_commit_on_with_scope"
auto-commit="true" />
+ <set-auto-commit sql-case-id="set_auto_commit_off" auto-commit="false" />
+ <set-auto-commit sql-case-id="set_auto_commit_off_with_scope"
auto-commit="false" />
+ <set-auto-commit sql-case-id="set_implicit_transactions_on"
auto-commit="true" />
+ <set-auto-commit sql-case-id="set_implicit_transactions_off"
auto-commit="false" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-constraints.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-constraints.xml
index 1e857fa..ad5c7fe 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-constraints.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-constraints.xml
@@ -17,7 +17,7 @@
-->
<sql-parser-test-cases>
- <set-constraints sql-case-id="setConstraintImmediate" />
- <set-constraints sql-case-id="setConstraintsAllImmediate" />
- <set-constraints sql-case-id="setConstraintsDeferred" />
+ <set-constraints sql-case-id="set_constraint_immediate" />
+ <set-constraints sql-case-id="set_constraints_all_immediate" />
+ <set-constraints sql-case-id="set_constraints_deferred" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-transaction.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-transaction.xml
index 28e1f2a..e5ee258 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-transaction.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/tcl/set-transaction.xml
@@ -17,21 +17,21 @@
-->
<sql-parser-test-cases>
- <set-transaction sql-case-id="setTransaction" />
- <set-transaction sql-case-id="setGlobalTransaction" />
- <set-transaction sql-case-id="setSessionTransaction" />
- <set-transaction sql-case-id="setTransactionReadOnly" />
- <set-transaction sql-case-id="setTransactionReadWriteWithName" />
- <set-transaction sql-case-id="setTransactionIsolationLevelSerializable" />
- <set-transaction sql-case-id="setTransactionIsolationLevelReadCommitted" />
- <set-transaction sql-case-id="setTransactionUseRollbackSegment" />
- <set-transaction sql-case-id="setTransactionWithName" />
- <set-transaction sql-case-id="setTransactionSnapshot" />
- <xa sql-case-id="xa-recover" />
- <xa sql-case-id="xa-start" />
- <xa sql-case-id="xa-begin" />
- <xa sql-case-id="xa-end" />
- <xa sql-case-id="xa-prepare" />
- <xa sql-case-id="xa-commit" />
- <xa sql-case-id="xa-rollback" />
+ <set-transaction sql-case-id="set_transaction" />
+ <set-transaction sql-case-id="set_global_transaction" />
+ <set-transaction sql-case-id="set_session_transaction" />
+ <set-transaction sql-case-id="set_transaction_read_only" />
+ <set-transaction sql-case-id="set_transaction_read_write_with_name" />
+ <set-transaction
sql-case-id="set_transaction_isolation_level_serializable" />
+ <set-transaction
sql-case-id="set_transaction_isolation_level_read_committed" />
+ <set-transaction sql-case-id="set_transaction_use_rollback_segment" />
+ <set-transaction sql-case-id="set_transaction_with_name" />
+ <set-transaction sql-case-id="set_transaction_snapshot" />
+ <xa sql-case-id="xa_recover" />
+ <xa sql-case-id="xa_start" />
+ <xa sql-case-id="xa_begin" />
+ <xa sql-case-id="xa_end" />
+ <xa sql-case-id="xa_prepare" />
+ <xa sql-case-id="xa_commit" />
+ <xa sql-case-id="xa_rollback" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/begin-transcation.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/begin-transcation.xml
index 0e4d95e..709cbe7 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/begin-transcation.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/begin-transcation.xml
@@ -18,11 +18,11 @@
<sql-cases>
<sql-case id="begin" value="BEGIN" db-types="MySQL,PostgreSQL" />
- <sql-case id="beginTransaction" value="BEGIN TRANSACTION"
db-types="SQLServer,PostgreSQL" />
- <sql-case id="beginWithName" value="BEGIN TRANSACTION transaction1"
db-types="SQLServer" />
+ <sql-case id="begin_transaction" value="BEGIN TRANSACTION"
db-types="SQLServer,PostgreSQL" />
+ <sql-case id="begin_with_name" value="BEGIN TRANSACTION transaction1"
db-types="SQLServer" />
<sql-case id="begin_with_variable_name" value="BEGIN TRANSACTION
@TranName" db-types="SQLServer" />
- <sql-case id="beginReadCommitted" value="BEGIN ISOLATION LEVEL READ
COMMITTED" db-types="PostgreSQL" />
- <sql-case id="beginReadOnly" value="BEGIN READ ONLY" db-types="PostgreSQL"
/>
+ <sql-case id="begin_read_committed" value="BEGIN ISOLATION LEVEL READ
COMMITTED" db-types="PostgreSQL" />
+ <sql-case id="begin_read_only" value="BEGIN READ ONLY"
db-types="PostgreSQL" />
<sql-case id="begin_with_transaction_mode" value="BEGIN TRANSACTION
ISOLATION LEVEL READ COMMITTED" db-types="PostgreSQL" />
<sql-case id="begin_with_mark_transaction" value="BEGIN TRANSACTION
CandidateDelete WITH MARK N'Deleting a Job Candidate'" db-types="SQLServer" />
<sql-case id="begin_distributed_transaction" value="BEGIN DISTRIBUTED
TRANSACTION" db-types="SQLServer" />
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/commit.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/commit.xml
index 5492613..0e3dfef 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/commit.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/commit.xml
@@ -19,13 +19,13 @@
<sql-cases>
<sql-case id="commit" value="COMMIT"
db-types="MySQL,Oracle,SQLServer,PostgreSQL" />
<sql-case id="commit_transaction" value="COMMIT TRANSACTION"
db-types="SQLServer" />
- <sql-case id="commitWithName" value="COMMIT TRANSACTION transaction1"
db-types="SQLServer" />
- <sql-case id="commitWithComment" value="COMMIT COMMENT 'comment1'"
db-types="Oracle" />
- <sql-case id="commitForce" value="COMMIT FORCE 'transaction1'"
db-types="Oracle" />
- <sql-case id="commitPrepare" value="COMMIT PREPARED 'transaction1'"
db-types="PostgreSQL" />
+ <sql-case id="commit_with_name" value="COMMIT TRANSACTION transaction1"
db-types="SQLServer" />
+ <sql-case id="commit_with_comment" value="COMMIT COMMENT 'comment1'"
db-types="Oracle" />
+ <sql-case id="commit_force" value="COMMIT FORCE 'transaction1'"
db-types="Oracle" />
+ <sql-case id="commit_prepare" value="COMMIT PREPARED 'transaction1'"
db-types="PostgreSQL" />
<sql-case id="commit_in_pg" value="COMMIT TRANSACTION AND NO CHAIN"
db-types="PostgreSQL" />
- <sql-case id="commitWorkWithComment" value="COMMIT WORK COMMENT
'comment1'" db-types="Oracle" />
- <sql-case id="commitWork" value="COMMIT WORK" db-types="Oracle" />
- <sql-case id="commitWriteBatch" value="COMMIT WRITE BATCH"
db-types="Oracle" />
- <sql-case id="commitWorkForce" value="COMMIT WORK FORCE '22.14.67'"
db-types="Oracle" />
+ <sql-case id="commit_work_with_comment" value="COMMIT WORK COMMENT
'comment1'" db-types="Oracle" />
+ <sql-case id="commit_work" value="COMMIT WORK" db-types="Oracle" />
+ <sql-case id="commit_write_batch" value="COMMIT WRITE BATCH"
db-types="Oracle" />
+ <sql-case id="commit_work_force" value="COMMIT WORK FORCE '22.14.67'"
db-types="Oracle" />
</sql-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/rollback.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/rollback.xml
index 83406f1..7f24b25 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/rollback.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/rollback.xml
@@ -19,11 +19,11 @@
<sql-cases>
<sql-case id="rollback" value="ROLLBACK"
db-types="MySQL,Oracle,PostgreSQL,SQLServer" />
<sql-case id="rollback_transaction" value="ROLLBACK TRAN @TransactionName"
db-types="SQLServer" />
- <sql-case id="rollbackWithName" value="ROLLBACK TRANSACTION transaction1"
db-types="SQLServer" />
- <sql-case id="rollbackToSavepoint" value="ROLLBACK TO savepoint1" />
- <sql-case id="rollbackForce" value="ROLLBACK FORCE 'transaction1'"
db-types="Oracle" />
- <sql-case id="rollbackPrepare" value="ROLLBACK PREPARED 'transaction1'"
db-types="PostgreSQL" />
+ <sql-case id="rollback_with_name" value="ROLLBACK TRANSACTION
transaction1" db-types="SQLServer" />
+ <sql-case id="rollback_to_savepoint" value="ROLLBACK TO savepoint1" />
+ <sql-case id="rollback_force" value="ROLLBACK FORCE 'transaction1'"
db-types="Oracle" />
+ <sql-case id="rollback_prepare" value="ROLLBACK PREPARED 'transaction1'"
db-types="PostgreSQL" />
<sql-case id="rollback_in_pg" value="ROLLBACK TRANSACTION AND CHAIN"
db-types="PostgreSQL" />
- <sql-case id="rollbackWorkForce" value="ROLLBACK WORK FORCE 'string1'"
db-types="Oracle" />
+ <sql-case id="rollback_work_force" value="ROLLBACK WORK FORCE 'string1'"
db-types="Oracle" />
<sql-case id="abort" value="ABORT" db-types="PostgreSQL" />
</sql-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-auto-commit.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-auto-commit.xml
index b6ffa44..638c518 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-auto-commit.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-auto-commit.xml
@@ -17,10 +17,10 @@
-->
<sql-cases>
- <sql-case id="setAutoCommitOn" value="SET AUTOCOMMIT = 1" db-types="MySQL"
/>
- <sql-case id="setAutoCommitOnWithScope" value="SET @@SESSION.AUTOCOMMIT =
ON" db-types="MySQL" />
- <sql-case id="setAutoCommitOff" value="SET AUTOCOMMIT = 0"
db-types="MySQL" />
- <sql-case id="setAutoCommitOffWithScope" value="SET SESSION AUTOCOMMIT =
OFF" db-types="MySQL" />
- <sql-case id="setImplicitTransactionsOn" value="SET IMPLICIT_TRANSACTIONS
ON" db-types="SQLServer" />
- <sql-case id="setImplicitTransactionsOff" value="IF @@TRANCOUNT > 0 COMMIT
TRAN SET IMPLICIT_TRANSACTIONS OFF" db-types="SQLServer" />
+ <sql-case id="set_auto_commit_on" value="SET AUTOCOMMIT = 1"
db-types="MySQL" />
+ <sql-case id="set_auto_commit_on_with_scope" value="SET
@@SESSION.AUTOCOMMIT = ON" db-types="MySQL" />
+ <sql-case id="set_auto_commit_off" value="SET AUTOCOMMIT = 0"
db-types="MySQL" />
+ <sql-case id="set_auto_commit_off_with_scope" value="SET SESSION
AUTOCOMMIT = OFF" db-types="MySQL" />
+ <sql-case id="set_implicit_transactions_on" value="SET
IMPLICIT_TRANSACTIONS ON" db-types="SQLServer" />
+ <sql-case id="set_implicit_transactions_off" value="IF @@TRANCOUNT > 0
COMMIT TRAN SET IMPLICIT_TRANSACTIONS OFF" db-types="SQLServer" />
</sql-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-constraints.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-constraints.xml
index a15424c..45371c7 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-constraints.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-constraints.xml
@@ -17,7 +17,7 @@
-->
<sql-cases>
- <sql-case id="setConstraintImmediate" value="SET CONSTRAINT emp_job_nn
IMMEDIATE" db-types="Oracle" />
- <sql-case id="setConstraintsAllImmediate" value="SET CONSTRAINTS ALL
IMMEDIATE" db-types="Oracle" />
- <sql-case id="setConstraintsDeferred" value="SET CONSTRAINTS emp_job_nn,
emp_salary_min DEFERRED" db-types="Oracle" />
+ <sql-case id="set_constraint_immediate" value="SET CONSTRAINT emp_job_nn
IMMEDIATE" db-types="Oracle" />
+ <sql-case id="set_constraints_all_immediate" value="SET CONSTRAINTS ALL
IMMEDIATE" db-types="Oracle" />
+ <sql-case id="set_constraints_deferred" value="SET CONSTRAINTS emp_job_nn,
emp_salary_min DEFERRED" db-types="Oracle" />
</sql-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-transaction.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-transaction.xml
index 325b474..d1d2706 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-transaction.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/tcl/set-transaction.xml
@@ -17,21 +17,21 @@
-->
<sql-cases>
- <sql-case id="setTransaction" value="SET TRANSACTION ISOLATION LEVEL
REPEATABLE READ" db-types="MySQL,PostgreSQL,SQLServer" />
- <sql-case id="setGlobalTransaction" value="SET GLOBAL TRANSACTION
ISOLATION LEVEL REPEATABLE READ" db-types="MySQL" />
- <sql-case id="setSessionTransaction" value="SET SESSION CHARACTERISTICS AS
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="PostgreSQL" />
- <sql-case id="setTransactionReadOnly" value="SET TRANSACTION READ ONLY"
db-types="MySQL,Oracle" />
- <sql-case id="setTransactionReadWriteWithName" value="SET TRANSACTION READ
WRITE NAME 'Toronto'" db-types="Oracle" />
- <sql-case id="setTransactionIsolationLevelSerializable" value="SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE" db-types="Oracle" />
- <sql-case id="setTransactionIsolationLevelReadCommitted" value="SET
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="Oracle" />
- <sql-case id="setTransactionUseRollbackSegment" value="SET TRANSACTION USE
ROLLBACK SEGMENT rbs_ts" db-types="Oracle" />
- <sql-case id="setTransactionWithName" value="SET TRANSACTION NAME
'comment1'" db-types="Oracle,SQLServer" />
- <sql-case id="setTransactionSnapshot" value="SET TRANSACTION SNAPSHOT
'snapshot1'" db-types="PostgreSQL" />
- <sql-case id="xa-recover" value="XA RECOVER" db-types="MySQL" />
- <sql-case id="xa-start" value="XA start 'abcdef7' join" db-types="MySQL" />
- <sql-case id="xa-begin" value="XA begin 'abcdef7' join" db-types="MySQL" />
- <sql-case id="xa-end" value="XA end 'abcdef7'" db-types="MySQL" />
- <sql-case id="xa-prepare" value="XA prepare 'abcdef7'" db-types="MySQL" />
- <sql-case id="xa-commit" value="XA commit 'abcdef7'" db-types="MySQL" />
- <sql-case id="xa-rollback" value="XA rollback 'abcdef7'" db-types="MySQL"
/>
+ <sql-case id="set_transaction" value="SET TRANSACTION ISOLATION LEVEL
REPEATABLE READ" db-types="MySQL,PostgreSQL,SQLServer" />
+ <sql-case id="set_global_transaction" value="SET GLOBAL TRANSACTION
ISOLATION LEVEL REPEATABLE READ" db-types="MySQL" />
+ <sql-case id="set_session_transaction" value="SET SESSION CHARACTERISTICS
AS TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="PostgreSQL" />
+ <sql-case id="set_transaction_read_only" value="SET TRANSACTION READ ONLY"
db-types="MySQL,Oracle" />
+ <sql-case id="set_transaction_read_write_with_name" value="SET TRANSACTION
READ WRITE NAME 'Toronto'" db-types="Oracle" />
+ <sql-case id="set_transaction_isolation_level_serializable" value="SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE" db-types="Oracle" />
+ <sql-case id="set_transaction_isolation_level_read_committed" value="SET
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="Oracle" />
+ <sql-case id="set_transaction_use_rollback_segment" value="SET TRANSACTION
USE ROLLBACK SEGMENT rbs_ts" db-types="Oracle" />
+ <sql-case id="set_transaction_with_name" value="SET TRANSACTION NAME
'comment1'" db-types="Oracle,SQLServer" />
+ <sql-case id="set_transaction_snapshot" value="SET TRANSACTION SNAPSHOT
'snapshot1'" db-types="PostgreSQL" />
+ <sql-case id="xa_recover" value="XA RECOVER" db-types="MySQL" />
+ <sql-case id="xa_start" value="XA start 'abcdef7' join" db-types="MySQL" />
+ <sql-case id="xa_begin" value="XA begin 'abcdef7' join" db-types="MySQL" />
+ <sql-case id="xa_end" value="XA end 'abcdef7'" db-types="MySQL" />
+ <sql-case id="xa_prepare" value="XA prepare 'abcdef7'" db-types="MySQL" />
+ <sql-case id="xa_commit" value="XA commit 'abcdef7'" db-types="MySQL" />
+ <sql-case id="xa_rollback" value="XA rollback 'abcdef7'" db-types="MySQL"
/>
</sql-cases>
