This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 a57317bfee5 Add SQL parser test cases for MySQL (#37835)
a57317bfee5 is described below
commit a57317bfee56902ba916620d4e9524c742c3edc1
Author: Liang Zhang <[email protected]>
AuthorDate: Sun Jan 25 15:33:07 2026 +0800
Add SQL parser test cases for MySQL (#37835)
* Add SQL parser test cases for MySQL
* Add SQL parser test cases for MySQL
---
.../parser/src/main/resources/case/dcl/alter-user.xml | 19 +++++++++++++++++++
.../src/main/resources/case/dcl/create-user.xml | 19 +++++++++++++++++++
.../src/main/resources/case/ddl/alter-tablespace.xml | 4 ++++
test/it/parser/src/main/resources/case/dml/call.xml | 12 +++++++++++-
.../src/main/resources/case/tcl/set-transaction.xml | 2 ++
.../main/resources/sql/supported/dcl/alter-user.xml | 19 +++++++++++++++++++
.../main/resources/sql/supported/dcl/create-user.xml | 19 +++++++++++++++++++
.../resources/sql/supported/ddl/alter-tablespace.xml | 1 +
.../src/main/resources/sql/supported/dml/call.xml | 1 +
.../resources/sql/supported/tcl/set-transaction.xml | 9 ++++++---
10 files changed, 101 insertions(+), 4 deletions(-)
diff --git a/test/it/parser/src/main/resources/case/dcl/alter-user.xml
b/test/it/parser/src/main/resources/case/dcl/alter-user.xml
index 63461a6a755..4aad7e80fa0 100644
--- a/test/it/parser/src/main/resources/case/dcl/alter-user.xml
+++ b/test/it/parser/src/main/resources/case/dcl/alter-user.xml
@@ -34,6 +34,25 @@
<alter-user sql-case-id="alter_user_with_password_option" />
<alter-user sql-case-id="alter_user_with_password_options" />
<alter-user sql-case-id="alter_user_with_lock_option" />
+ <alter-user sql-case-id="alter_user_account_unlock_mysql" />
+ <alter-user sql-case-id="alter_user_with_max_connections_per_hour_mysql" />
+ <alter-user sql-case-id="alter_user_with_max_user_connections_mysql" />
+ <alter-user sql-case-id="alter_user_require_none_mysql" />
+ <alter-user sql-case-id="alter_user_require_ssl_mysql" />
+ <alter-user sql-case-id="alter_user_require_x509_mysql" />
+ <alter-user sql-case-id="alter_user_require_tls_specified_mysql" />
+ <alter-user sql-case-id="alter_user_password_expire_interval_mysql" />
+ <alter-user sql-case-id="alter_user_password_expire_never_mysql" />
+ <alter-user sql-case-id="alter_user_password_history_mysql" />
+ <alter-user sql-case-id="alter_user_password_reuse_interval_mysql" />
+ <alter-user sql-case-id="alter_user_password_require_optional_mysql" />
+ <alter-user sql-case-id="alter_user_password_require_yes_mysql" />
+ <alter-user sql-case-id="alter_user_failed_login_and_lock_time_mysql" />
+ <alter-user sql-case-id="alter_user_password_lock_time_unbounded_mysql" />
+ <alter-user sql-case-id="alter_user_identified_with_plugin_mysql" />
+ <alter-user sql-case-id="alter_user_identified_with_plugin_as_mysql" />
+ <alter-user sql-case-id="alter_user_identified_with_plugin_by_mysql" />
+ <alter-user
sql-case-id="alter_user_identified_with_plugin_by_random_mysql" />
<alter-user sql-case-id="alter_user_with_options" />
<alter-user sql-case-id="alter_external_user" />
<alter-user sql-case-id="alter_global_user" />
diff --git a/test/it/parser/src/main/resources/case/dcl/create-user.xml
b/test/it/parser/src/main/resources/case/dcl/create-user.xml
index 3c605873ebc..f71ac0baeaa 100644
--- a/test/it/parser/src/main/resources/case/dcl/create-user.xml
+++ b/test/it/parser/src/main/resources/case/dcl/create-user.xml
@@ -34,6 +34,25 @@
<create-user sql-case-id="create_user_with_password_option" />
<create-user sql-case-id="create_user_with_password_options" />
<create-user sql-case-id="create_user_with_lock_option" />
+ <create-user sql-case-id="create_user_account_unlock_mysql" />
+ <create-user sql-case-id="create_user_with_max_connections_per_hour_mysql"
/>
+ <create-user sql-case-id="create_user_with_max_user_connections_mysql" />
+ <create-user sql-case-id="create_user_require_none_mysql" />
+ <create-user sql-case-id="create_user_require_ssl_mysql" />
+ <create-user sql-case-id="create_user_require_x509_mysql" />
+ <create-user sql-case-id="create_user_require_tls_specified_mysql" />
+ <create-user sql-case-id="create_user_password_expire_interval_mysql" />
+ <create-user sql-case-id="create_user_password_expire_never_mysql" />
+ <create-user sql-case-id="create_user_password_history_mysql" />
+ <create-user sql-case-id="create_user_password_reuse_interval_mysql" />
+ <create-user sql-case-id="create_user_password_require_optional_mysql" />
+ <create-user sql-case-id="create_user_password_require_yes_mysql" />
+ <create-user sql-case-id="create_user_failed_login_and_lock_time_mysql" />
+ <create-user sql-case-id="create_user_password_lock_time_unbounded_mysql"
/>
+ <create-user sql-case-id="create_user_identified_with_plugin_mysql" />
+ <create-user sql-case-id="create_user_identified_with_plugin_as_mysql" />
+ <create-user sql-case-id="create_user_identified_with_plugin_by_mysql" />
+ <create-user
sql-case-id="create_user_identified_with_plugin_by_random_mysql" />
<create-user sql-case-id="create_user_with_options" />
<create-user sql-case-id="create_external_user" />
<create-user sql-case-id="create_global_user" />
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
b/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
index 730761fe94f..e9f6b1181d3 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
@@ -29,6 +29,10 @@
<alter-tablespace sql-case-id="alter_tablespace_innodb_add_datafile_doris"
db-types="Doris">
<tablespace start-index="17" stop-index="25" name="ts_innodb" />
</alter-tablespace>
+
+ <alter-tablespace sql-case-id="alter_tablespace_innodb_add_datafile_mysql">
+ <tablespace start-index="17" stop-index="25" name="ts_innodb" />
+ </alter-tablespace>
<alter-tablespace sql-case-id="alter_tablespace_read_only">
diff --git a/test/it/parser/src/main/resources/case/dml/call.xml
b/test/it/parser/src/main/resources/case/dml/call.xml
index 0895c29ba45..7f23541b70b 100644
--- a/test/it/parser/src/main/resources/case/dml/call.xml
+++ b/test/it/parser/src/main/resources/case/dml/call.xml
@@ -153,7 +153,17 @@
<literal-expression value="member2@localhost" start-index="45"
stop-index="63"/>
</procedure-parameter>
</call>
-
+
+ <call sql-case-id="call_with_owner_mysql">
+ <procedure-name name="analytics.proc_demo" start-index="5"
stop-index="23"/>
+ <procedure-parameter>
+ <parameter-marker-expression parameter-index="0" start-index="25"
stop-index="25"/>
+ </procedure-parameter>
+ <procedure-parameter>
+ <parameter-marker-expression parameter-index="1" start-index="28"
stop-index="28"/>
+ </procedure-parameter>
+ </call>
+
<call sql-case-id="call_with_owner_doris">
<procedure-name name="analytics.proc_demo" start-index="5"
stop-index="23"/>
<procedure-parameter>
diff --git a/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
b/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
index 26e4d8727d7..cbce0a98e31 100644
--- a/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
+++ b/test/it/parser/src/main/resources/case/tcl/set-transaction.xml
@@ -20,6 +20,8 @@
<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_session_transaction_read_only_mysql" />
+ <set-transaction sql-case-id="set_session_transaction_read_write_mysql" />
<set-transaction sql-case-id="set_transaction_read_only" />
<set-transaction sql-case-id="set_transaction_read_write" />
<set-transaction sql-case-id="set_transaction_read_write_with_name" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dcl/alter-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/alter-user.xml
index b35d02c0e2b..7a397f671b9 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/alter-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/alter-user.xml
@@ -34,6 +34,25 @@
<sql-case id="alter_user_with_password_option" value="ALTER USER user1
PASSWORD EXPIRE DEFAULT" db-types="MySQL" />
<sql-case id="alter_user_with_password_options" value="ALTER USER user1
PASSWORD EXPIRE DEFAULT PASSWORD HISTORY DEFAULT" db-types="MySQL" />
<sql-case id="alter_user_with_lock_option" value="ALTER USER user1 ACCOUNT
LOCK" db-types="MySQL" />
+ <sql-case id="alter_user_account_unlock_mysql" value="ALTER USER
user_unlock ACCOUNT UNLOCK" db-types="MySQL" />
+ <sql-case id="alter_user_with_max_connections_per_hour_mysql" value="ALTER
USER user_conn_limit WITH MAX_CONNECTIONS_PER_HOUR 10" db-types="MySQL" />
+ <sql-case id="alter_user_with_max_user_connections_mysql" value="ALTER
USER user_user_conn_limit WITH MAX_USER_CONNECTIONS 5" db-types="MySQL" />
+ <sql-case id="alter_user_require_none_mysql" value="ALTER USER user_none
REQUIRE NONE" db-types="MySQL" />
+ <sql-case id="alter_user_require_ssl_mysql" value="ALTER USER user_ssl
REQUIRE SSL" db-types="MySQL" />
+ <sql-case id="alter_user_require_x509_mysql" value="ALTER USER user_x509
REQUIRE X509" db-types="MySQL" />
+ <sql-case id="alter_user_require_tls_specified_mysql" value="ALTER USER
user_tls REQUIRE SUBJECT 'subj' ISSUER 'issuer' CIPHER 'cipher_name'"
db-types="MySQL" />
+ <sql-case id="alter_user_password_expire_interval_mysql" value="ALTER USER
user_expire_interval PASSWORD EXPIRE INTERVAL 30 DAY" db-types="MySQL" />
+ <sql-case id="alter_user_password_expire_never_mysql" value="ALTER USER
user_expire_never PASSWORD EXPIRE NEVER" db-types="MySQL" />
+ <sql-case id="alter_user_password_history_mysql" value="ALTER USER
user_history PASSWORD HISTORY 5" db-types="MySQL" />
+ <sql-case id="alter_user_password_reuse_interval_mysql" value="ALTER USER
user_reuse PASSWORD REUSE INTERVAL 10 DAY" db-types="MySQL" />
+ <sql-case id="alter_user_password_require_optional_mysql" value="ALTER
USER user_require_optional PASSWORD REQUIRE CURRENT OPTIONAL" db-types="MySQL"
/>
+ <sql-case id="alter_user_password_require_yes_mysql" value="ALTER USER
user_require_yes PASSWORD REQUIRE CURRENT" db-types="MySQL" />
+ <sql-case id="alter_user_failed_login_and_lock_time_mysql" value="ALTER
USER user_failed_lock PASSWORD EXPIRE DEFAULT FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 7" db-types="MySQL" />
+ <sql-case id="alter_user_password_lock_time_unbounded_mysql" value="ALTER
USER user_lock_unbounded PASSWORD EXPIRE DEFAULT PASSWORD_LOCK_TIME UNBOUNDED"
db-types="MySQL" />
+ <sql-case id="alter_user_identified_with_plugin_mysql" value="ALTER USER
user_plugin IDENTIFIED WITH 'ldap'" db-types="MySQL" />
+ <sql-case id="alter_user_identified_with_plugin_as_mysql" value="ALTER
USER user_plugin_as IDENTIFIED WITH 'ldap' AS 'pwd'" db-types="MySQL" />
+ <sql-case id="alter_user_identified_with_plugin_by_mysql" value="ALTER
USER user_plugin_by IDENTIFIED WITH 'ldap' BY 'pwd'" db-types="MySQL" />
+ <sql-case id="alter_user_identified_with_plugin_by_random_mysql"
value="ALTER USER user_plugin_rand IDENTIFIED WITH 'ldap' BY RANDOM PASSWORD"
db-types="MySQL" />
<sql-case id="alter_user_with_options" value="ALTER USER user1 WITH
MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 1 PASSWORD EXPIRE DEFAULT PASSWORD
HISTORY DEFAULT ACCOUNT LOCK" db-types="MySQL" />
<sql-case id="alter_user_with_password_doris" value="ALTER USER user1
IDENTIFIED BY 'pwd_doris'" db-types="Doris" />
<sql-case id="alter_user_doris_password_policy" value="ALTER USER
user_history PASSWORD EXPIRE DEFAULT PASSWORD HISTORY 5 PASSWORD REUSE INTERVAL
10 DAY" db-types="Doris" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
index 9ae7eaef403..94387b2fc85 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
@@ -34,6 +34,25 @@
<sql-case id="create_user_with_password_option" value="CREATE USER user1
DEFAULT ROLE role1 PASSWORD EXPIRE DEFAULT" db-types="MySQL,Doris" />
<sql-case id="create_user_with_password_options" value="CREATE USER user1
DEFAULT ROLE role1 PASSWORD EXPIRE DEFAULT PASSWORD HISTORY DEFAULT"
db-types="MySQL,Doris" />
<sql-case id="create_user_with_lock_option" value="CREATE USER user1
DEFAULT ROLE role1 ACCOUNT LOCK" db-types="MySQL,Doris" />
+ <sql-case id="create_user_account_unlock_mysql" value="CREATE USER
user_unlock DEFAULT ROLE role1 ACCOUNT UNLOCK" db-types="MySQL" />
+ <sql-case id="create_user_with_max_connections_per_hour_mysql"
value="CREATE USER user_conn_limit WITH MAX_CONNECTIONS_PER_HOUR 10"
db-types="MySQL" />
+ <sql-case id="create_user_with_max_user_connections_mysql" value="CREATE
USER user_user_conn_limit WITH MAX_USER_CONNECTIONS 5" db-types="MySQL" />
+ <sql-case id="create_user_require_none_mysql" value="CREATE USER user_none
REQUIRE NONE" db-types="MySQL" />
+ <sql-case id="create_user_require_ssl_mysql" value="CREATE USER user_ssl
REQUIRE SSL" db-types="MySQL" />
+ <sql-case id="create_user_require_x509_mysql" value="CREATE USER user_x509
REQUIRE X509" db-types="MySQL" />
+ <sql-case id="create_user_require_tls_specified_mysql" value="CREATE USER
user_tls REQUIRE SUBJECT 'subj' ISSUER 'issuer' CIPHER 'cipher_name'"
db-types="MySQL" />
+ <sql-case id="create_user_password_expire_interval_mysql" value="CREATE
USER user_expire_interval PASSWORD EXPIRE INTERVAL 30 DAY" db-types="MySQL" />
+ <sql-case id="create_user_password_expire_never_mysql" value="CREATE USER
user_expire_never PASSWORD EXPIRE NEVER" db-types="MySQL" />
+ <sql-case id="create_user_password_history_mysql" value="CREATE USER
user_history PASSWORD HISTORY 5" db-types="MySQL" />
+ <sql-case id="create_user_password_reuse_interval_mysql" value="CREATE
USER user_reuse PASSWORD REUSE INTERVAL 10 DAY" db-types="MySQL" />
+ <sql-case id="create_user_password_require_optional_mysql" value="CREATE
USER user_require_optional PASSWORD REQUIRE CURRENT OPTIONAL" db-types="MySQL"
/>
+ <sql-case id="create_user_password_require_yes_mysql" value="CREATE USER
user_require_yes PASSWORD REQUIRE CURRENT" db-types="MySQL" />
+ <sql-case id="create_user_failed_login_and_lock_time_mysql" value="CREATE
USER user_failed_lock PASSWORD EXPIRE DEFAULT FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 7" db-types="MySQL" />
+ <sql-case id="create_user_password_lock_time_unbounded_mysql"
value="CREATE USER user_lock_unbounded PASSWORD EXPIRE DEFAULT
PASSWORD_LOCK_TIME UNBOUNDED" db-types="MySQL" />
+ <sql-case id="create_user_identified_with_plugin_mysql" value="CREATE USER
user_plugin IDENTIFIED WITH 'ldap'" db-types="MySQL" />
+ <sql-case id="create_user_identified_with_plugin_as_mysql" value="CREATE
USER user_plugin_as IDENTIFIED WITH 'ldap' AS 'pwd'" db-types="MySQL" />
+ <sql-case id="create_user_identified_with_plugin_by_mysql" value="CREATE
USER user_plugin_by IDENTIFIED WITH 'ldap' BY 'pwd'" db-types="MySQL" />
+ <sql-case id="create_user_identified_with_plugin_by_random_mysql"
value="CREATE USER user_plugin_rand IDENTIFIED WITH 'ldap' BY RANDOM PASSWORD"
db-types="MySQL" />
<sql-case id="create_user_with_options" value="CREATE USER user1 DEFAULT
ROLE role1 WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 1 PASSWORD EXPIRE
DEFAULT PASSWORD HISTORY DEFAULT ACCOUNT LOCK" db-types="MySQL,Doris" />
<sql-case id="create_user_account_unlock_password_expire_interval_doris"
value="CREATE USER user_expire_interval DEFAULT ROLE role1 ACCOUNT UNLOCK
PASSWORD EXPIRE INTERVAL 30 DAY" db-types="Doris" />
<sql-case id="create_user_password_expire_never_doris" value="CREATE USER
user_expire_never PASSWORD EXPIRE NEVER" db-types="Doris" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
index 05dfc679cbc..828595babf8 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
@@ -20,6 +20,7 @@
<sql-case id="alter_tablespace_rename" value="ALTER TABLESPACE ts1 RENAME
TO ts2" db-types="MySQL,Oracle,Doris" />
<sql-case id="alter_tablespace_ndb_add_datafile_doris" value="ALTER
TABLESPACE ts_ndb ADD DATAFILE 'ts1.ibd' INITIAL_SIZE 100M ENGINE ndb"
db-types="Doris" />
<sql-case id="alter_tablespace_innodb_add_datafile_doris" value="ALTER
TABLESPACE ts_innodb ADD DATAFILE 'ts2.ibd' INITIAL_SIZE 50M ENGINE innodb"
db-types="Doris" />
+ <sql-case id="alter_tablespace_innodb_add_datafile_mysql" value="ALTER
TABLESPACE ts_innodb ADD DATAFILE 'ts2.ibd' INITIAL_SIZE 50M ENGINE=INNODB"
db-types="MySQL" />
<sql-case id="alter_tablespace_read_only" value="ALTER TABLESPACE ts1 READ
ONLY" db-types="Oracle" />
<sql-case id="alter_tablespace_read_write" value="ALTER TABLESPACE sales_1
READ WRITE" db-types="Oracle" />
<sql-case id="alter_tablespace_add_datafile" value="ALTER TABLESPACE ts1
ADD DATAFILE" db-types="Oracle" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/call.xml
b/test/it/parser/src/main/resources/sql/supported/dml/call.xml
index a57efa069b4..48801d76cfe 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/call.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/call.xml
@@ -22,6 +22,7 @@
<sql-case id="call_with_parameters_all_placeholder" value="CALL p(?, ?) "
db-types="MySQL,Doris" />
<sql-case id="call_with_parameters_all_expression" value="CALL p('user',
'order')" db-types="MySQL,Doris" />
<sql-case id="call_with_parameters_mix" value="CALL p(@order_id, 'user',
?)" db-types="MySQL,Doris" />
+ <sql-case id="call_with_owner_mysql" value="CALL analytics.proc_demo(?,
?)" db-types="MySQL" />
<sql-case id="call_with_owner_doris" value="CALL analytics.proc_demo(?,
?)" db-types="Doris" />
<sql-case id="call_with_named_notation_with_null" value="CALL p(a =>
null, b => 8, c => 2);" db-types="PostgreSQL" />
<sql-case id="call_with_named_notation" value="CALL p(b => 8, c =>
2, a => 0);" db-types="PostgreSQL" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
index 2afad90fe12..368f7535816 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/set-transaction.xml
@@ -19,15 +19,18 @@
<sql-cases>
<sql-case id="set_transaction" value="SET TRANSACTION ISOLATION LEVEL
REPEATABLE READ" db-types="MySQL,PostgreSQL,openGauss,SQLServer,Doris,Firebird"
/>
<sql-case id="set_global_transaction" value="SET GLOBAL TRANSACTION
ISOLATION LEVEL REPEATABLE READ" db-types="MySQL,Doris" />
+ <sql-case id="set_session_transaction" value="SET SESSION TRANSACTION
ISOLATION LEVEL READ COMMITTED" db-types="MySQL" />
+ <sql-case id="set_session_transaction_read_only_mysql" value="SET SESSION
TRANSACTION READ ONLY" db-types="MySQL" />
+ <sql-case id="set_session_transaction_read_write_mysql" value="SET SESSION
TRANSACTION READ WRITE" db-types="MySQL" />
<sql-case id="set_session_transaction_doris" value="SET SESSION
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="Doris" />
<sql-case id="set_session_transaction_read_only_doris" value="SET SESSION
TRANSACTION READ ONLY" db-types="Doris" />
<sql-case id="set_global_transaction_read_only_doris" value="SET GLOBAL
TRANSACTION READ ONLY" db-types="Doris" />
<sql-case id="set_transaction_read_only" value="SET TRANSACTION READ ONLY"
db-types="MySQL,Oracle,Doris" />
- <sql-case id="set_transaction_read_write" value="SET TRANSACTION READ
WRITE" db-types="Doris" />
+ <sql-case id="set_transaction_read_write" value="SET TRANSACTION READ
WRITE" db-types="MySQL,Doris" />
<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, SQLServer,Doris" />
- <sql-case id="set_transaction_isolation_level_read_committed" value="SET
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="Oracle, SQLServer,Doris"
/>
- <sql-case id="set_transaction_isolation_level_read_uncommitted" value="SET
TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" db-types="Doris" />
+ <sql-case id="set_transaction_isolation_level_read_committed" value="SET
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="MySQL,Oracle,
SQLServer,Doris" />
+ <sql-case id="set_transaction_isolation_level_read_uncommitted" value="SET
TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" db-types="MySQL,Doris" />
<sql-case id="set_transaction_isolation_level_snapshot" value="SET
TRANSACTION ISOLATION LEVEL SNAPSHOT" db-types="SQLServer" />
<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" />
