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 d1110cacba1 Add more SQL parser test cases on Doris (#37634)
d1110cacba1 is described below
commit d1110cacba1210070bc97db5fab7c9abbd6c99cb
Author: Liang Zhang <[email protected]>
AuthorDate: Sun Jan 4 17:00:22 2026 +0800
Add more SQL parser test cases on Doris (#37634)
---
.../parser/src/main/resources/case/dcl/revoke.xml | 1 +
.../main/resources/case/tcl/set-transaction.xml | 3 +++
.../resources/sql/supported/dcl/grant-user.xml | 26 ++++++++++----------
.../resources/sql/supported/dcl/revoke-user.xml | 27 +++++++++++----------
.../src/main/resources/sql/supported/dml/call.xml | 10 ++++----
.../main/resources/sql/supported/dml/load-data.xml | 6 ++---
.../main/resources/sql/supported/dml/load-xml.xml | 6 ++---
.../resources/sql/supported/dml/select-window.xml | 2 +-
.../src/main/resources/sql/supported/lcl/lock.xml | 8 +++----
.../main/resources/sql/supported/lcl/unlock.xml | 6 ++---
.../sql/supported/tcl/begin-transcation.xml | 4 ++--
.../main/resources/sql/supported/tcl/commit.xml | 2 +-
.../main/resources/sql/supported/tcl/rollback.xml | 4 ++--
.../main/resources/sql/supported/tcl/savepoint.xml | 2 +-
.../sql/supported/tcl/set-auto-commit.xml | 4 ++--
.../sql/supported/tcl/set-transaction.xml | 28 ++++++++++++----------
16 files changed, 73 insertions(+), 66 deletions(-)
diff --git a/test/it/parser/src/main/resources/case/dcl/revoke.xml
b/test/it/parser/src/main/resources/case/dcl/revoke.xml
index edd0813e6ae..45838df3afb 100644
--- a/test/it/parser/src/main/resources/case/dcl/revoke.xml
+++ b/test/it/parser/src/main/resources/case/dcl/revoke.xml
@@ -54,6 +54,7 @@
<owner name="ds_0" start-index="25" stop-index="28" />
</table>
</revoke>
+ <revoke sql-case-id="revoke_proxy_on_user" />
<revoke sql-case-id="revoke_role_from_user" />
<revoke sql-case-id="revoke_roles_from_users" />
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 1f49ea6fe2a..c0d906c5941 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
@@ -21,13 +21,16 @@
<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" />
<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_isolation_level_read_uncommitted" />
<set-transaction sql-case-id="set_transaction_isolation_level_snapshot" />
<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" />
+ <set-transaction sql-case-id="set_session_transaction_doris" />
<xa sql-case-id="xa_recover" />
<xa sql-case-id="xa_start" />
<xa sql-case-id="xa_begin" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
index c95279f47ff..1c49b5d6c3c 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/grant-user.xml
@@ -21,19 +21,19 @@
<sql-case id="grant_user_with_grant" value="GRANT SELECT, UPDATE, INSERT,
DELETE ON t_order to user_dev with GRANT option"
db-types="Oracle,PostgreSQL,openGauss,SQLServer" />
<sql-case id="grant_role" value="GRANT role_dev to user_dev"
db-types="Oracle,PostgreSQL,openGauss" />
<sql-case id="grant_user_with_admin" value="GRANT ADVISOR, ALTER DATABASE
to user_dev with admin option" db-types="Oracle" />
- <sql-case id="grant_user_on_db" value="GRANT ALL ON sharding_db.* TO
'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="grant_user_on_table" value="GRANT ALL ON t_order TO
'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="grant_user_on_db_and_table" value="GRANT ALL ON
sharding_db.t_order TO 'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="grant_user_with_hostname" value="GRANT select, update ON
t_order TO 'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="grant_select" value="GRANT SELECT ON *.* TO user1"
db-types="MySQL" />
- <sql-case id="grant_select_column" value="GRANT SELECT (order_id) ON
ds_0.t_order TO user1" db-types="MySQL,SQLServer" />
- <sql-case id="grant_select_to_local_user" value="GRANT SELECT ON *.* TO
'user1'@'localhost'" db-types="MySQL" />
- <sql-case id="grant_create_to_local_user" value="GRANT CREATE ON *.* TO
user_name_len_25_01234567@localhost" db-types="MySQL" />
- <sql-case id="grant_proxy_to_local_user" value="GRANT PROXY ON
bug20364862_dest@localhost TO bug20364862_user@localhost" db-types="MySQL" />
- <sql-case id="grant_crud" value="GRANT INSERT, SELECT, UPDATE, DELETE ON
*.* TO user1" db-types="MySQL" />
- <sql-case id="grant_all" value="GRANT ALL PRIVILEGES ON *.* TO user1"
db-types="MySQL" />
- <sql-case id="grant_all_on_table" value="GRANT ALL PRIVILEGES ON
ds_0.t_order TO user1" db-types="MySQL,PostgreSQL,openGauss,SQLServer" />
- <sql-case id="grant_role_to_user" value="GRANT role1 TO user1"
db-types="MySQL" />
+ <sql-case id="grant_user_on_db" value="GRANT ALL ON sharding_db.* TO
'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="grant_user_on_table" value="GRANT ALL ON t_order TO
'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="grant_user_on_db_and_table" value="GRANT ALL ON
sharding_db.t_order TO 'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="grant_user_with_hostname" value="GRANT select, update ON
t_order TO 'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="grant_select" value="GRANT SELECT ON *.* TO user1"
db-types="MySQL,Doris" />
+ <sql-case id="grant_select_column" value="GRANT SELECT (order_id) ON
ds_0.t_order TO user1" db-types="MySQL,SQLServer,Doris" />
+ <sql-case id="grant_select_to_local_user" value="GRANT SELECT ON *.* TO
'user1'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="grant_create_to_local_user" value="GRANT CREATE ON *.* TO
user_name_len_25_01234567@localhost" db-types="MySQL,Doris" />
+ <sql-case id="grant_proxy_to_local_user" value="GRANT PROXY ON
bug20364862_dest@localhost TO bug20364862_user@localhost"
db-types="MySQL,Doris" />
+ <sql-case id="grant_crud" value="GRANT INSERT, SELECT, UPDATE, DELETE ON
*.* TO user1" db-types="MySQL,Doris" />
+ <sql-case id="grant_all" value="GRANT ALL PRIVILEGES ON *.* TO user1"
db-types="MySQL,Doris" />
+ <sql-case id="grant_all_on_table" value="GRANT ALL PRIVILEGES ON
ds_0.t_order TO user1" db-types="MySQL,PostgreSQL,openGauss,SQLServer,Doris" />
+ <sql-case id="grant_role_to_user" value="GRANT role1 TO user1"
db-types="MySQL,Doris" />
<sql-case id="grant_roles_to_users" value="GRANT role1, role2 TO user1,
user2" db-types="MySQL,Oracle" />
<sql-case id="grant_system_privilege" value="GRANT CREATE SESSION TO
user1" db-types="Oracle" />
<sql-case id="grant_system_privileges" value="GRANT CREATE ANY
MATERIALIZED VIEW, ALTER ANY MATERIALIZED VIEW, DROP ANY MATERIALIZED VIEW TO
user1" db-types="Oracle" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
index 8dc854c1f85..a43efdc8e38 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/revoke-user.xml
@@ -20,19 +20,20 @@
<sql-case id="revoke_user_without_hostname" value="REVOKE SELECT, UPDATE
on t_order from user_dev" db-types="Oracle,PostgreSQL,openGauss,SQLServer" />
<sql-case id="revoke_role" value="REVOKE role_dev from user_dev"
db-types="Oracle,PostgreSQL,openGauss" />
<sql-case id="revoke_user_from" value="REVOKE ADVISOR, ALTER DATABASE from
user_dev" db-types="Oracle" />
- <sql-case id="revoke_user_with_hostname_on_db" value="REVOKE select,
insert ON * FROM 'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="revoke_user_with_hostname_on_table" value="REVOKE select,
insert ON t_order FROM 'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="revoke_user_with_hostname_on_db_and_table" value="REVOKE
select, insert ON primary_ds.t_order FROM 'user_dev'@'localhost'"
db-types="MySQL" />
- <sql-case id="revoke_user_with_hostname" value="REVOKE ALL PRIVILEGES,
GRANT OPTION FROM 'user_dev'@'localhost'" db-types="MySQL" />
- <sql-case id="revoke_select" value="REVOKE SELECT ON *.* FROM user1"
db-types="MySQL" />
- <sql-case id="revoke_select_column" value="REVOKE SELECT (order_id) ON
ds_0.t_order FROM user1" db-types="MySQL" />
- <sql-case id="revoke_select_from_local_user" value="REVOKE SELECT ON *.*
FROM 'user1'@'localhost'" db-types="MySQL" />
- <sql-case id="revoke_crud" value="REVOKE INSERT, SELECT, UPDATE, DELETE ON
*.* FROM user1" db-types="MySQL" />
- <sql-case id="revoke_all" value="REVOKE ALL PRIVILEGES ON *.* FROM user1"
db-types="MySQL" />
- <sql-case id="revoke_all_on_schema" value="REVOKE ALL PRIVILEGES ON ds_0.*
FROM user1" db-types="MySQL" />
- <sql-case id="revoke_all_on_table" value="REVOKE ALL PRIVILEGES ON
ds_0.t_order FROM user1" db-types="MySQL,PostgreSQL,openGauss" />
- <sql-case id="revoke_role_from_user" value="REVOKE role1 FROM user1"
db-types="MySQL,Oracle" />
- <sql-case id="revoke_roles_from_users" value="REVOKE role1, role2 FROM
user1, user2" db-types="MySQL" />
+ <sql-case id="revoke_user_with_hostname_on_db" value="REVOKE select,
insert ON * FROM 'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="revoke_user_with_hostname_on_table" value="REVOKE select,
insert ON t_order FROM 'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="revoke_user_with_hostname_on_db_and_table" value="REVOKE
select, insert ON primary_ds.t_order FROM 'user_dev'@'localhost'"
db-types="MySQL,Doris" />
+ <sql-case id="revoke_user_with_hostname" value="REVOKE ALL PRIVILEGES,
GRANT OPTION FROM 'user_dev'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="revoke_select" value="REVOKE SELECT ON *.* FROM user1"
db-types="MySQL,Doris" />
+ <sql-case id="revoke_select_column" value="REVOKE SELECT (order_id) ON
ds_0.t_order FROM user1" db-types="MySQL,Doris" />
+ <sql-case id="revoke_select_from_local_user" value="REVOKE SELECT ON *.*
FROM 'user1'@'localhost'" db-types="MySQL,Doris" />
+ <sql-case id="revoke_crud" value="REVOKE INSERT, SELECT, UPDATE, DELETE ON
*.* FROM user1" db-types="MySQL,Doris" />
+ <sql-case id="revoke_all" value="REVOKE ALL PRIVILEGES ON *.* FROM user1"
db-types="MySQL,Doris" />
+ <sql-case id="revoke_all_on_schema" value="REVOKE ALL PRIVILEGES ON ds_0.*
FROM user1" db-types="MySQL,Doris" />
+ <sql-case id="revoke_all_on_table" value="REVOKE ALL PRIVILEGES ON
ds_0.t_order FROM user1" db-types="MySQL,PostgreSQL,openGauss,Doris" />
+ <sql-case id="revoke_role_from_user" value="REVOKE role1 FROM user1"
db-types="MySQL,Oracle,Doris" />
+ <sql-case id="revoke_roles_from_users" value="REVOKE role1, role2 FROM
user1, user2" db-types="MySQL,Doris" />
+ <sql-case id="revoke_proxy_on_user" value="REVOKE PROXY ON
'user1'@'localhost' FROM 'user2'@'localhost'" db-types="Doris" />
<sql-case id="revoke_system_privilege" value="REVOKE CREATE SESSION FROM
user1" db-types="Oracle" />
<sql-case id="revoke_system_privileges" value="REVOKE CREATE ANY
MATERIALIZED VIEW, ALTER ANY MATERIALIZED VIEW, DROP ANY MATERIALIZED VIEW FROM
user1" db-types="Oracle" />
<sql-case id="revoke_all_system_privileges" value="REVOKE ALL PRIVILEGES
FROM user1" 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 5e285a74748..06f3a04b065 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
@@ -17,11 +17,11 @@
-->
<sql-cases>
- <sql-case id="call_without_parameters" value="CALL p" db-types="MySQL" />
- <sql-case id="call_with_parameters_all_variable" value="CALL p(@order_id,
@user_id)" db-types="MySQL" />
- <sql-case id="call_with_parameters_all_placeholder" value="CALL p(?, ?) "
db-types="MySQL" />
- <sql-case id="call_with_parameters_all_expression" value="CALL p('user',
'order')" db-types="MySQL" />
- <sql-case id="call_with_parameters_mix" value="CALL p(@order_id, 'user',
?)" db-types="MySQL" />
+ <sql-case id="call_without_parameters" value="CALL p"
db-types="MySQL,Doris" />
+ <sql-case id="call_with_parameters_all_variable" value="CALL p(@order_id,
@user_id)" db-types="MySQL,Doris" />
+ <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_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" />
<sql-case id="call_with_mixed_notation" value="CALL p(null, 7, c =>
2);" db-types="PostgreSQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/load-data.xml
b/test/it/parser/src/main/resources/sql/supported/dml/load-data.xml
index 4b320a3b74e..01c29c7266e 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/load-data.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/load-data.xml
@@ -17,9 +17,9 @@
-->
<sql-cases>
- <sql-case id="load_data_into_table_from_server_file" value="LOAD DATA
INFILE '/temp/test.txt' INTO TABLE t_order" db-types="MySQL" />
- <sql-case id="load_data_into_table_from_local_file" value="LOAD DATA LOCAL
INFILE '/temp/test.txt' INTO TABLE t_order" db-types="MySQL" />
- <sql-case id="load_data_into_table_with_schema_name" value="LOAD DATA
INFILE '/temp/test.txt' INTO TABLE sharding_db.t_order" db-types="MySQL" />
+ <sql-case id="load_data_into_table_from_server_file" value="LOAD DATA
INFILE '/temp/test.txt' INTO TABLE t_order" db-types="MySQL,Doris" />
+ <sql-case id="load_data_into_table_from_local_file" value="LOAD DATA LOCAL
INFILE '/temp/test.txt' INTO TABLE t_order" db-types="MySQL,Doris" />
+ <sql-case id="load_data_into_table_with_schema_name" value="LOAD DATA
INFILE '/temp/test.txt' INTO TABLE sharding_db.t_order" db-types="MySQL,Doris"
/>
<sql-case id="load_data_into_table_with_lines_starting" value="LOAD DATA
INFILE '/tmp/test.txt' INTO TABLE t_order FIELDS TERMINATED BY ',' LINES
STARTING BY 'xxx'" db-types="MySQL" />
<sql-case id="load_data_into_table_with_ignore_lines" value="LOAD DATA
INFILE '/tmp/test.txt' INTO TABLE t_order IGNORE 1 LINES" db-types="MySQL" />
<sql-case id="load_data_into_table_with_at_01" value="LOAD DATA INFILE
'file.txt' INTO TABLE t1 (column1, @var1) SET column2 = @var1/100;"
db-types="MySQL"/>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/load-xml.xml
b/test/it/parser/src/main/resources/sql/supported/dml/load-xml.xml
index 0c7fe4656c5..b47d7ffa856 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/load-xml.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/load-xml.xml
@@ -17,8 +17,8 @@
-->
<sql-cases>
- <sql-case id="load_xml_into_table_from_server_file" value="LOAD XML INFILE
'/temp/test.xml' INTO TABLE t_order" db-types="MySQL" />
- <sql-case id="load_xml_into_table_from_local_file" value="LOAD XML LOCAL
INFILE '/temp/test.xml' INTO TABLE t_order" db-types="MySQL" />
- <sql-case id="load_xml_into_table_with_schema_name" value="LOAD XML INFILE
'/temp/test.xml' INTO TABLE sharding_db.t_order" db-types="MySQL" />
+ <sql-case id="load_xml_into_table_from_server_file" value="LOAD XML INFILE
'/temp/test.xml' INTO TABLE t_order" db-types="MySQL,Doris" />
+ <sql-case id="load_xml_into_table_from_local_file" value="LOAD XML LOCAL
INFILE '/temp/test.xml' INTO TABLE t_order" db-types="MySQL,Doris" />
+ <sql-case id="load_xml_into_table_with_schema_name" value="LOAD XML INFILE
'/temp/test.xml' INTO TABLE sharding_db.t_order" db-types="MySQL,Doris" />
<sql-case id="load_xml_into_table_with_ignore_lines" value="LOAD XML
INFILE '/tmp/test.xml' INTO TABLE t_order IGNORE 1 LINES" db-types="MySQL" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dml/select-window.xml
b/test/it/parser/src/main/resources/sql/supported/dml/select-window.xml
index 46538255abc..eb9f286c0b2 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/select-window.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/select-window.xml
@@ -17,5 +17,5 @@
-->
<sql-cases>
- <sql-case id="select_window" value="SELECT user_id, ROW_NUMBER() OVER w AS
'row_number', RANK() OVER w AS 'rank', DENSE_RANK() OVER w AS 'dense_rank' FROM
t_order WHERE order_id = ? WINDOW w AS (ORDER BY user_id)" db-types="MySQL" />
+ <sql-case id="select_window" value="SELECT user_id, ROW_NUMBER() OVER w AS
'row_number', RANK() OVER w AS 'rank', DENSE_RANK() OVER w AS 'dense_rank' FROM
t_order WHERE order_id = ? WINDOW w AS (ORDER BY user_id)"
db-types="MySQL,Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/lcl/lock.xml
b/test/it/parser/src/main/resources/sql/supported/lcl/lock.xml
index 6134419cd4b..ff56fbe0729 100644
--- a/test/it/parser/src/main/resources/sql/supported/lcl/lock.xml
+++ b/test/it/parser/src/main/resources/sql/supported/lcl/lock.xml
@@ -21,12 +21,12 @@
<sql-case id="lock_single_table_with_alias_table_write" value="lock table
mysql.general_log WRITE" db-types="MySQL" />
<sql-case id="lock_table_with_table_owner_read" value="lock tables
mysql.general_log READ" db-types="MySQL" />
<sql-case id="lock_table_with_alias_table_write" value="lock tables
mysql.general_log WRITE" db-types="MySQL" />
- <sql-case id="lock_table_with_read" value="lock tables t1 READ"
db-types="MySQL" />
- <sql-case id="lock_table_with_write" value="lock tables t1 WRITE"
db-types="MySQL" />
- <sql-case id="lock_table_with_multi_table" value="lock tables t1 write, t1
as a read, t1 as b read" db-types="MySQL" />
+ <sql-case id="lock_table_with_read" value="lock tables t1 READ"
db-types="MySQL,Doris" />
+ <sql-case id="lock_table_with_write" value="lock tables t1 WRITE"
db-types="MySQL,Doris" />
+ <sql-case id="lock_table_with_multi_table" value="lock tables t1 write, t1
as a read, t1 as b read" db-types="MySQL,Doris" />
<sql-case id="lock_instance_for_backup" value="LOCK INSTANCE FOR BACKUP"
db-types="MySQL" />
<sql-case id="lock_table_with_read_local" value="LOCK TABLES t1 READ
LOCAL" db-types="MySQL" />
- <sql-case id="lock_table_with_alias" value="LOCK TABLES t1 READ, t1 as
TableAlias READ" db-types="MySQL" />
+ <sql-case id="lock_table_with_alias" value="LOCK TABLES t1 READ, t1 as
TableAlias READ" db-types="MySQL,Doris" />
<sql-case id="lock_table_with_only" value="LOCK TABLE ONLY lock_tbl1;"
db-types="PostgreSQL" />
<sql-case id="lock_table" value="LOCK TABLE fast_emp4000;"
db-types="PostgreSQL" />
<sql-case id="lock_table_access_exclusive" value="LOCK TABLE lock_tbl1 *
IN ACCESS EXCLUSIVE MODE;" db-types="PostgreSQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/lcl/unlock.xml
b/test/it/parser/src/main/resources/sql/supported/lcl/unlock.xml
index 5ab82c76a61..67af42e614c 100644
--- a/test/it/parser/src/main/resources/sql/supported/lcl/unlock.xml
+++ b/test/it/parser/src/main/resources/sql/supported/lcl/unlock.xml
@@ -17,7 +17,7 @@
-->
<sql-cases>
- <sql-case id="unlock_table" value="unlock table" db-types="MySQL" />
- <sql-case id="unlock_tables" value="unlock tables" db-types="MySQL" />
- <sql-case id="unlock_instance" value="UNLOCK INSTANCE" db-types="MySQL" />
+ <sql-case id="unlock_table" value="unlock table" db-types="MySQL,Doris" />
+ <sql-case id="unlock_tables" value="unlock tables" db-types="MySQL,Doris"
/>
+ <sql-case id="unlock_instance" value="UNLOCK INSTANCE"
db-types="MySQL,Doris" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/tcl/begin-transcation.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/begin-transcation.xml
index 90446ea6985..219788c877b 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/begin-transcation.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/begin-transcation.xml
@@ -17,8 +17,8 @@
-->
<sql-cases>
- <sql-case id="begin" value="BEGIN" db-types="MySQL,PostgreSQL,openGauss" />
- <sql-case id="begin_work" value="BEGIN WORK" db-types="MySQL" />
+ <sql-case id="begin" value="BEGIN"
db-types="MySQL,PostgreSQL,openGauss,Doris" />
+ <sql-case id="begin_work" value="BEGIN WORK" db-types="MySQL,Doris" />
<sql-case id="begin_transaction" value="BEGIN TRANSACTION"
db-types="SQLServer,PostgreSQL,openGauss" />
<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" />
diff --git a/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
index 54faae8e65a..64cc670af4e 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/commit.xml
@@ -17,7 +17,7 @@
-->
<sql-cases>
- <sql-case id="commit" value="COMMIT"
db-types="MySQL,Oracle,SQLServer,PostgreSQL,openGauss" />
+ <sql-case id="commit" value="COMMIT"
db-types="MySQL,Oracle,SQLServer,PostgreSQL,openGauss,Doris" />
<sql-case id="commit_transaction" value="COMMIT TRANSACTION"
db-types="SQLServer" />
<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" />
diff --git a/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
index e5ff9382863..f0058f481da 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/rollback.xml
@@ -17,10 +17,10 @@
-->
<sql-cases>
- <sql-case id="rollback" value="ROLLBACK"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer" />
+ <sql-case id="rollback" value="ROLLBACK"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer,Doris" />
<sql-case id="rollback_transaction" value="ROLLBACK TRAN @TransactionName"
db-types="SQLServer" />
<sql-case id="rollback_with_name" value="ROLLBACK TRANSACTION
transaction1" db-types="SQLServer" />
- <sql-case id="rollback_to_savepoint" value="ROLLBACK TO savepoint1"
db-types="MySQL,PostgreSQL,openGauss,Oracle" />
+ <sql-case id="rollback_to_savepoint" value="ROLLBACK TO savepoint1"
db-types="MySQL,PostgreSQL,openGauss,Oracle,Doris" />
<sql-case id="rollback_force" value="ROLLBACK FORCE 'transaction1'"
db-types="Oracle" />
<sql-case id="rollback_prepare" value="ROLLBACK PREPARED 'transaction1'"
db-types="PostgreSQL,openGauss" />
<sql-case id="rollback_in_pg" value="ROLLBACK TRANSACTION AND CHAIN"
db-types="PostgreSQL,openGauss" />
diff --git a/test/it/parser/src/main/resources/sql/supported/tcl/savepoint.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/savepoint.xml
index 12570dbfe5a..1e8b81d5ac8 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/savepoint.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/savepoint.xml
@@ -17,6 +17,6 @@
-->
<sql-cases>
- <sql-case id="savepoint" value="SAVEPOINT savepoint1"
db-types="MySQL,PostgreSQL,openGauss,Oracle" />
+ <sql-case id="savepoint" value="SAVEPOINT savepoint1"
db-types="MySQL,PostgreSQL,openGauss,Oracle,Doris" />
<sql-case id="savepoint_transaction" value="SAVE TRANSACTION
ProcedureSave" db-types="SQLServer" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/tcl/set-auto-commit.xml
b/test/it/parser/src/main/resources/sql/supported/tcl/set-auto-commit.xml
index 0721d24c23a..76a8b4a3ad9 100644
--- a/test/it/parser/src/main/resources/sql/supported/tcl/set-auto-commit.xml
+++ b/test/it/parser/src/main/resources/sql/supported/tcl/set-auto-commit.xml
@@ -17,9 +17,9 @@
-->
<sql-cases>
- <sql-case id="set_auto_commit_on" value="SET AUTOCOMMIT = 1"
db-types="MySQL" />
+ <sql-case id="set_auto_commit_on" value="SET AUTOCOMMIT = 1"
db-types="MySQL,Doris" />
<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" value="SET AUTOCOMMIT = 0"
db-types="MySQL,Doris" />
<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="SET
IMPLICIT_TRANSACTIONS OFF" db-types="SQLServer" />
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 2d33dddec6a..6e499e5d222 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
@@ -17,22 +17,24 @@
-->
<sql-cases>
- <sql-case id="set_transaction" value="SET TRANSACTION ISOLATION LEVEL
REPEATABLE READ" db-types="MySQL,PostgreSQL,openGauss,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,openGauss"
/>
- <sql-case id="set_transaction_read_only" value="SET TRANSACTION READ ONLY"
db-types="MySQL,Oracle" />
+ <sql-case id="set_transaction" value="SET TRANSACTION ISOLATION LEVEL
REPEATABLE READ" db-types="MySQL,PostgreSQL,openGauss,SQLServer,Doris" />
+ <sql-case id="set_global_transaction" value="SET GLOBAL TRANSACTION
ISOLATION LEVEL REPEATABLE READ" db-types="MySQL,Doris" />
+ <sql-case id="set_session_transaction_doris" value="SET SESSION
TRANSACTION ISOLATION LEVEL READ COMMITTED" 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_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" />
- <sql-case id="set_transaction_isolation_level_read_committed" value="SET
TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="Oracle, SQLServer" />
+ <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_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" />
<sql-case id="set_transaction_snapshot" value="SET TRANSACTION SNAPSHOT
'snapshot1'" db-types="PostgreSQL,openGauss" />
- <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="xa_recover" value="XA RECOVER" db-types="MySQL,Doris" />
+ <sql-case id="xa_start" value="XA start 'abcdef7' join"
db-types="MySQL,Doris" />
+ <sql-case id="xa_begin" value="XA begin 'abcdef7' join"
db-types="MySQL,Doris" />
+ <sql-case id="xa_end" value="XA end 'abcdef7'" db-types="MySQL,Doris" />
+ <sql-case id="xa_prepare" value="XA prepare 'abcdef7'"
db-types="MySQL,Doris" />
+ <sql-case id="xa_commit" value="XA commit 'abcdef7'"
db-types="MySQL,Doris" />
+ <sql-case id="xa_rollback" value="XA rollback 'abcdef7'"
db-types="MySQL,Doris" />
</sql-cases>
