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 b8dee5f3021 Add SQL parser test cases for Doris (#37780)
b8dee5f3021 is described below
commit b8dee5f3021f3f15bcc771d757b98a1f80f614a6
Author: Liang Zhang <[email protected]>
AuthorDate: Tue Jan 20 00:52:28 2026 +0800
Add SQL parser test cases for Doris (#37780)
* Add SQL parser test cases for Doris
* Add SQL parser test cases for Doris
---
.../src/main/resources/case/dal/create-loadable-function.xml | 1 +
test/it/parser/src/main/resources/case/dcl/alter-user.xml | 4 ++++
.../resources/case/ddl/{create-server.xml => alter-instance.xml} | 2 +-
test/it/parser/src/main/resources/case/ddl/alter-server.xml | 1 +
test/it/parser/src/main/resources/case/ddl/create-server.xml | 1 +
test/it/parser/src/main/resources/case/ddl/drop-server.xml | 1 +
test/it/parser/src/main/resources/case/ddl/drop-trigger.xml | 1 +
.../main/resources/sql/supported/dal/create-loadable-function.xml | 1 +
test/it/parser/src/main/resources/sql/supported/dcl/alter-user.xml | 4 ++++
.../ddl/drop-server.xml => sql/supported/ddl/alter-instance.xml} | 7 +++----
.../parser/src/main/resources/sql/supported/ddl/alter-server.xml | 1 +
.../main/resources/{case => sql/supported}/ddl/create-server.xml | 6 +++---
.../it/parser/src/main/resources/sql/supported/ddl/drop-server.xml | 1 +
.../parser/src/main/resources/sql/supported/ddl/drop-trigger.xml | 1 +
14 files changed, 24 insertions(+), 8 deletions(-)
diff --git
a/test/it/parser/src/main/resources/case/dal/create-loadable-function.xml
b/test/it/parser/src/main/resources/case/dal/create-loadable-function.xml
index 09b51cde24d..17b1b160824 100644
--- a/test/it/parser/src/main/resources/case/dal/create-loadable-function.xml
+++ b/test/it/parser/src/main/resources/case/dal/create-loadable-function.xml
@@ -19,4 +19,5 @@
<sql-parser-test-cases>
<create-loadable-function
sql-case-id="create_loadable_function_return_int"/>
<create-loadable-function
sql-case-id="create_loadable_function_return_dec"/>
+ <create-loadable-function sql-case-id="create_loadable_function_doris"/>
</sql-parser-test-cases>
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 0fef39f4504..63461a6a755 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
@@ -71,4 +71,8 @@
<alter-user sql-case-id="alter_user_identified_with_single_quoted" />
<alter-user sql-case-id="alter_user_with_factor" />
<alter-user sql-case-id="alter_user_with_password_doris" />
+ <alter-user sql-case-id="alter_user_doris_password_policy" />
+ <alter-user sql-case-id="alter_user_doris_account_lock_unlock" />
+ <alter-user sql-case-id="alter_user_doris_require_ssl" />
+ <alter-user sql-case-id="alter_user_doris_resource_limits" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-server.xml
b/test/it/parser/src/main/resources/case/ddl/alter-instance.xml
similarity index 92%
copy from test/it/parser/src/main/resources/case/ddl/create-server.xml
copy to test/it/parser/src/main/resources/case/ddl/alter-instance.xml
index 06ebeb4fd24..b42691f9eb3 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-server.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-instance.xml
@@ -17,5 +17,5 @@
-->
<sql-parser-test-cases>
-<!-- <create-server sql-case-id="create_server" />-->
+ <common sql-case-id="alter_instance_doris_rotate_innodb_master_key" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-server.xml
b/test/it/parser/src/main/resources/case/ddl/alter-server.xml
index 2a17cbeec18..51abca9e8ef 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-server.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-server.xml
@@ -19,4 +19,5 @@
<sql-parser-test-cases>
<alter-server sql-case-id="alter_server_options" />
<alter-server sql-case-id="alter_server_version" />
+ <alter-server sql-case-id="alter_server_doris_options" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-server.xml
b/test/it/parser/src/main/resources/case/ddl/create-server.xml
index 06ebeb4fd24..922a53d667e 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-server.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-server.xml
@@ -18,4 +18,5 @@
<sql-parser-test-cases>
<!-- <create-server sql-case-id="create_server" />-->
+ <create-server sql-case-id="create_server_doris_basic" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/drop-server.xml
b/test/it/parser/src/main/resources/case/ddl/drop-server.xml
index a041bb82da4..118dd51172a 100644
--- a/test/it/parser/src/main/resources/case/ddl/drop-server.xml
+++ b/test/it/parser/src/main/resources/case/ddl/drop-server.xml
@@ -19,4 +19,5 @@
<sql-parser-test-cases>
<drop-server sql-case-id="drop_server" />
<drop-server sql-case-id="drop_server_if_exists" />
+ <drop-server sql-case-id="drop_server_doris" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/drop-trigger.xml
b/test/it/parser/src/main/resources/case/ddl/drop-trigger.xml
index a72f258f13f..25ab3e0ed92 100644
--- a/test/it/parser/src/main/resources/case/ddl/drop-trigger.xml
+++ b/test/it/parser/src/main/resources/case/ddl/drop-trigger.xml
@@ -22,4 +22,5 @@
<drop-trigger sql-case-id="drop_trigger_if_exists" />
<drop-trigger sql-case-id="drop_trigger_cascade" />
<drop-trigger sql-case-id="drop_trigger_restrict" />
+ <drop-trigger sql-case-id="drop_trigger_doris_simple" />
</sql-parser-test-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dal/create-loadable-function.xml
b/test/it/parser/src/main/resources/sql/supported/dal/create-loadable-function.xml
index 29fc694d263..5fc73b0e149 100644
---
a/test/it/parser/src/main/resources/sql/supported/dal/create-loadable-function.xml
+++
b/test/it/parser/src/main/resources/sql/supported/dal/create-loadable-function.xml
@@ -19,4 +19,5 @@
<sql-cases>
<sql-case id="create_loadable_function_return_int" value="CREATE FUNCTION
service_get_read_locks RETURNS INT SONAME 'locking_service.so'"
db-types="MySQL,Doris" />
<sql-case id="create_loadable_function_return_dec" value="CREATE FUNCTION
version_tokens_lock_exclusive RETURNS DEC SONAME 'version_token.so'"
db-types="MySQL,Doris"/>
+ <sql-case id="create_loadable_function_doris" value="CREATE AGGREGATE
FUNCTION udf_sum RETURNS INTEGER SONAME 'udf_sum.so'" db-types="Doris" />
</sql-cases>
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 5374500d578..b35d02c0e2b 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
@@ -36,6 +36,10 @@
<sql-case id="alter_user_with_lock_option" value="ALTER USER user1 ACCOUNT
LOCK" 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" />
+ <sql-case id="alter_user_doris_account_lock_unlock" value="ALTER USER
user_lock ACCOUNT LOCK PASSWORD EXPIRE" db-types="Doris" />
+ <sql-case id="alter_user_doris_require_ssl" value="ALTER USER user_ssl
REQUIRE SSL" db-types="Doris" />
+ <sql-case id="alter_user_doris_resource_limits" value="ALTER USER
user_limits WITH MAX_QUERIES_PER_HOUR 10 MAX_UPDATES_PER_HOUR 5"
db-types="Doris" />
<sql-case id="alter_external_user" value="ALTER USER user1 IDENTIFIED
EXTERNALLY" db-types="Oracle" />
<sql-case id="alter_global_user" value="ALTER USER user1 IDENTIFIED
GLOBALLY AS 'CN=user1'" db-types="Oracle" />
<sql-case id="alter_user_with_tablespace_option" value="ALTER USER user1
DEFAULT TABLESPACE tablespace1" db-types="Oracle" />
diff --git a/test/it/parser/src/main/resources/case/ddl/drop-server.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-instance.xml
similarity index 84%
copy from test/it/parser/src/main/resources/case/ddl/drop-server.xml
copy to test/it/parser/src/main/resources/sql/supported/ddl/alter-instance.xml
index a041bb82da4..f127e8645de 100644
--- a/test/it/parser/src/main/resources/case/ddl/drop-server.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-instance.xml
@@ -16,7 +16,6 @@
~ limitations under the License.
-->
-<sql-parser-test-cases>
- <drop-server sql-case-id="drop_server" />
- <drop-server sql-case-id="drop_server_if_exists" />
-</sql-parser-test-cases>
+<sql-cases>
+ <sql-case id="alter_instance_doris_rotate_innodb_master_key" value="ALTER
INSTANCE ROTATE INNODB MASTER KEY" db-types="Doris" />
+</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-server.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-server.xml
index 213dcff18d1..3984ededc01 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-server.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-server.xml
@@ -19,4 +19,5 @@
<sql-cases>
<sql-case id="alter_server_options" value="ALTER SERVER foo OPTIONS (host
'foo', dbname 'foodb');" db-types="PostgreSQL" />
<sql-case id="alter_server_version" value="ALTER SERVER foo VERSION
'8.4';" db-types="PostgreSQL" />
+ <sql-case id="alter_server_doris_options" value="ALTER SERVER s0 OPTIONS
(USER 'doris_admin')" db-types="Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-server.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/create-server.xml
similarity index 82%
copy from test/it/parser/src/main/resources/case/ddl/create-server.xml
copy to test/it/parser/src/main/resources/sql/supported/ddl/create-server.xml
index 06ebeb4fd24..48415e8dfea 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-server.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-server.xml
@@ -16,6 +16,6 @@
~ limitations under the License.
-->
-<sql-parser-test-cases>
-<!-- <create-server sql-case-id="create_server" />-->
-</sql-parser-test-cases>
+<sql-cases>
+ <sql-case id="create_server_doris_basic" value="CREATE SERVER s0 FOREIGN
DATA WRAPPER mysql OPTIONS (USER 'doris_user', HOST '127.0.0.1')"
db-types="Doris" />
+</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/drop-server.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/drop-server.xml
index ed1d2d7969d..1a8f004c57c 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/drop-server.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/drop-server.xml
@@ -19,4 +19,5 @@
<sql-cases>
<sql-case id="drop_server" value="DROP SERVER s0"
db-types="PostgreSQL,openGauss" />
<sql-case id="drop_server_if_exists" value="DROP SERVER IF EXISTS s0"
db-types="PostgreSQL,openGauss" />
+ <sql-case id="drop_server_doris" value="DROP SERVER server_doris"
db-types="Doris" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/drop-trigger.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/drop-trigger.xml
index c8c476786a6..e0d4ee0fd14 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/drop-trigger.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/drop-trigger.xml
@@ -22,4 +22,5 @@
<sql-case id="drop_trigger_if_exists" value="DROP TRIGGER IF EXISTS foo ON
no_such_schema.bar" db-types="PostgreSQL" />
<sql-case id="drop_trigger_cascade" value="DROP TRIGGER foo ON
no_such_schema.bar CASCADE" db-types="PostgreSQL" />
<sql-case id="drop_trigger_restrict" value="DROP TRIGGER IF EXISTS foo ON
no_such_schema.bar RESTRICT" db-types="PostgreSQL" />
+ <sql-case id="drop_trigger_doris_simple" value="DROP TRIGGER trg_test"
db-types="Doris" />
</sql-cases>
