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 fcf4e8b8119 Add SQL parser test cases for Doris (#37787)
fcf4e8b8119 is described below
commit fcf4e8b81191cac0083d689d34a3684ee05ea440
Author: Liang Zhang <[email protected]>
AuthorDate: Tue Jan 20 12:04:40 2026 +0800
Add SQL parser test cases for Doris (#37787)
---
.../src/main/resources/case/dal/describe.xml | 4 ++
test/it/parser/src/main/resources/case/dal/set.xml | 5 ++
.../parser/src/main/resources/case/dml/select.xml | 56 ++++++++++++++++++++++
.../main/resources/case/tcl/set-transaction.xml | 2 +
.../main/resources/sql/supported/dal/explain.xml | 1 +
.../src/main/resources/sql/supported/dal/set.xml | 1 +
.../main/resources/sql/supported/dml/select.xml | 3 ++
.../sql/supported/tcl/set-transaction.xml | 2 +
8 files changed, 74 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/dal/describe.xml
b/test/it/parser/src/main/resources/case/dal/describe.xml
index d412bd86118..b366e2b2ffa 100644
--- a/test/it/parser/src/main/resources/case/dal/describe.xml
+++ b/test/it/parser/src/main/resources/case/dal/describe.xml
@@ -80,6 +80,10 @@
<simple-table name="user_table" start-index="19" stop-index="28" />
</describe>
+ <describe sql-case-id="explain_table_doris" db-types="Doris">
+ <simple-table name="t_order" start-index="8" stop-index="14" />
+ </describe>
+
<describe sql-case-id="describe_table_partition">
<simple-table name="user_table" start-index="9" stop-index="18" />
</describe>
diff --git a/test/it/parser/src/main/resources/case/dal/set.xml
b/test/it/parser/src/main/resources/case/dal/set.xml
index 8988487a121..7819861a2b9 100644
--- a/test/it/parser/src/main/resources/case/dal/set.xml
+++ b/test/it/parser/src/main/resources/case/dal/set.xml
@@ -100,6 +100,11 @@
<parameter name="character_set_client" />
</parameter-assign>
</set-parameter>
+ <set-parameter sql-case-id="set_character_set_doris">
+ <parameter-assign value="utf8mb4">
+ <parameter name="character_set_client" />
+ </parameter-assign>
+ </set-parameter>
<set-resource-group sql-case-id="set_resource_group">
<group name="rg" />
</set-resource-group>
diff --git a/test/it/parser/src/main/resources/case/dml/select.xml
b/test/it/parser/src/main/resources/case/dml/select.xml
index cda2c96cad3..34dcc0eeaed 100644
--- a/test/it/parser/src/main/resources/case/dml/select.xml
+++ b/test/it/parser/src/main/resources/case/dml/select.xml
@@ -12128,6 +12128,30 @@
<lock start-index="22" stop-index="31" />
</select>
+ <select sql-case-id="select_cte_with_columns_doris">
+ <with start-index="0" stop-index="19">
+ <common-table-expression name="c" start-index="5" stop-index="19">
+ <subquery start-index="11" stop-index="18">
+ <select>
+ <projections start-index="18" stop-index="18">
+ <expression-projection text="1" start-index="18"
stop-index="18">
+ <expr>
+ <literal-expression value="1"
start-index="18" stop-index="18" />
+ </expr>
+ </expression-projection>
+ </projections>
+ </select>
+ </subquery>
+ </common-table-expression>
+ </with>
+ <projections start-index="28" stop-index="28">
+ <shorthand-projection start-index="28" stop-index="28" />
+ </projections>
+ <from start-index="30" stop-index="35">
+ <simple-table name="c" start-index="35" stop-index="35" />
+ </from>
+ </select>
+
<select sql-case-id="select_function_with_owner_doris">
<projections start-index="7" stop-index="27">
<expression-projection text="analytics.custom_fn()"
start-index="7" stop-index="27">
@@ -12138,6 +12162,38 @@
</projections>
</select>
+ <select sql-case-id="select_udf_call_doris">
+ <projections start-index="7" stop-index="21">
+ <expression-projection text="my_udf(user_id)" start-index="7"
stop-index="21">
+ <expr>
+ <function function-name="my_udf" text="my_udf(user_id)"
start-index="7" stop-index="21">
+ <parameter>
+ <column name="user_id" start-index="14"
stop-index="20" />
+ </parameter>
+ </function>
+ </expr>
+ </expression-projection>
+ </projections>
+ <from start-index="23" stop-index="34">
+ <simple-table name="t_order" start-index="28" stop-index="34" />
+ </from>
+ </select>
+
+ <select sql-case-id="select_system_variable_scope_doris">
+ <projections start-index="7" stop-index="46">
+ <expression-projection text="@@GLOBAL.time_zone" start-index="7"
stop-index="24">
+ <expr>
+ <variable-segment start-index="7" stop-index="24"
scope="GLOBAL" variable="time_zone" />
+ </expr>
+ </expression-projection>
+ <expression-projection text="@@SESSION.autocommit"
start-index="27" stop-index="46">
+ <expr>
+ <variable-segment start-index="27" stop-index="46"
scope="SESSION" variable="autocommit" />
+ </expr>
+ </expression-projection>
+ </projections>
+ </select>
+
<select sql-case-id="select_from_function_table_doris">
<projections start-index="7" stop-index="7">
<shorthand-projection start-index="7" stop-index="7" />
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 3526a18032d..26e4d8727d7 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
@@ -31,6 +31,8 @@
<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" />
+ <set-transaction sql-case-id="set_session_transaction_read_only_doris" />
+ <set-transaction sql-case-id="set_global_transaction_read_only_doris" />
<set-transaction sql-case-id="set_transaction_sql92" />
<xa sql-case-id="xa_recover" />
<xa sql-case-id="xa_start" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/explain.xml
b/test/it/parser/src/main/resources/sql/supported/dal/explain.xml
index 7f6f98765b8..580ee55d930 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/explain.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/explain.xml
@@ -24,6 +24,7 @@
<sql-case id="explain_update_doris" value="EXPLAIN UPDATE t_order SET
status = 'ok'" db-types="Doris" />
<sql-case id="explain_delete_doris" value="EXPLAIN DELETE FROM t_order
WHERE order_id = 1" db-types="Doris" />
<sql-case id="explain_replace_doris" value="EXPLAIN REPLACE INTO t_order
(order_id, user_id) VALUES (1, 1)" db-types="Doris" />
+ <sql-case id="explain_table_doris" value="EXPLAIN t_order"
db-types="Doris" />
<sql-case id="explain_update_without_condition" value="EXPLAIN UPDATE
t_order SET status = 'finished'" db-types="PostgreSQL, openGauss, MySQL,
SQLServer" />
<sql-case id="explain_insert_without_parameters" value="EXPLAIN INSERT
INTO t_order (order_id, user_id, status) VALUES (1, 1, 'insert')"
db-types="PostgreSQL, openGauss, MySQL, SQLServer" />
<sql-case id="explain_delete_without_sharding_value" value="EXPLAIN DELETE
FROM t_order WHERE status='init'" db-types="PostgreSQL, openGauss, MySQL,
SQLServer" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/set.xml
b/test/it/parser/src/main/resources/sql/supported/dal/set.xml
index 3985edf77be..29ed177dcd5 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/set.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/set.xml
@@ -40,6 +40,7 @@
<sql-case id="set_parameter_equal_list" value="SET extra_float_digits =
1,2,3" db-types="PostgreSQL,openGauss" />
<sql-case id="set_parameter_equal_number_with_signal" value="SET
extra_float_digits = -10.5" db-types="PostgreSQL,openGauss" />
<sql-case id="set_names" value="SET NAMES 'utf8' COLLATE
'utf8_general_ci'" db-types="MySQL,Doris" />
+ <sql-case id="set_character_set_doris" value="SET CHARACTER SET utf8mb4"
db-types="Doris" />
<sql-case id="set_resource_group" value="SET RESOURCE GROUP rg"
db-types="MySQL,Doris" />
<sql-case id="set_charset_mysql" value="SET NAMES 'utf8'" db-types="MySQL"
/>
<sql-case id="set_charset_postgresql" value="SET NAMES 'UTF8'"
db-types="PostgreSQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/select.xml
b/test/it/parser/src/main/resources/sql/supported/dml/select.xml
index f2db0cb0075..110e746f4e8 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/select.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/select.xml
@@ -95,6 +95,9 @@
<sql-case id="select_straight_join_doris" value="SELECT STRAIGHT_JOIN *
FROM t_order" db-types="Doris" />
<sql-case id="select_for_update_doris" value="SELECT * FROM t_order FOR
UPDATE" db-types="Doris" />
<sql-case id="select_union_doris" value="SELECT 1 UNION SELECT 2"
db-types="Doris" />
+ <sql-case id="select_cte_with_columns_doris" value="WITH c AS (SELECT 1)
SELECT * FROM c" db-types="Doris" />
+ <sql-case id="select_udf_call_doris" value="SELECT my_udf(user_id) FROM
t_order" db-types="Doris" />
+ <sql-case id="select_system_variable_scope_doris" value="SELECT
@@GLOBAL.time_zone, @@SESSION.autocommit" db-types="Doris" />
<sql-case id="select_function_with_owner_doris" value="SELECT
analytics.custom_fn()" db-types="Doris" />
<sql-case id="select_with_json_separator" value="select
content_json->>'$.nation' as nation,content_json->>'$.title' as title from
tb_content_json b where b.content_id=1" db-types="MySQL" />
<sql-case id="select_with_json_value_return_type" value="SELECT * FROM
t_order WHERE JSON_VALUE(items, '$.name' RETURNING VARCHAR(100)) = 'jack'"
db-types="MySQL" />
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 6df52200341..2afad90fe12 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
@@ -20,6 +20,8 @@
<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_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_with_name" value="SET TRANSACTION
READ WRITE NAME 'Toronto'" db-types="Oracle" />
