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 2a56d76e654 Add more test cases on Doris SQL parser (#37685)
2a56d76e654 is described below
commit 2a56d76e6548be814921d09174a5905bf7b8437f
Author: Liang Zhang <[email protected]>
AuthorDate: Thu Jan 8 15:21:36 2026 +0800
Add more test cases on Doris SQL parser (#37685)
* Add more test cases on Doris SQL parser
* Add more test cases on Doris SQL parser
* Add more test cases on Doris SQL parser
* Add more test cases on Doris SQL parser
---
.../metadata/jdbc/JDBCInstanceMetaData.java | 14 +++----------
.../segment/dml/sample/SampleOptionSegment.java | 2 +-
.../dml/statistics/StatisticsOptionSegment.java | 2 +-
.../dml/statistics/StatisticsStrategySegment.java | 2 +-
.../{dcl/rename-user.xml => dal/analyze-table.xml} | 3 +--
.../it/parser/src/main/resources/case/dal/show.xml | 23 ++++++++++++++++++++++
.../rename-user.xml => dal/start-stop-slave.xml} | 5 +++--
.../src/main/resources/case/dal/uninstall.xml | 8 ++++++++
.../src/main/resources/case/dcl/alter-user.xml | 1 +
.../src/main/resources/case/dcl/create-user.xml | 10 ++++++++++
.../src/main/resources/case/dcl/rename-user.xml | 1 +
.../src/main/resources/case/ddl/alter-table.xml | 9 +++++++++
.../parser/src/main/resources/case/dml/select.xml | 11 +++++++++++
.../parser/src/main/resources/case/tcl/unlock.xml | 1 +
.../src/main/resources/sql/supported/dal/alter.xml | 2 +-
.../dal/{shutdown.xml => analyze-table.xml} | 2 +-
.../src/main/resources/sql/supported/dal/clone.xml | 6 +++---
.../main/resources/sql/supported/dal/create.xml | 4 ++--
.../main/resources/sql/supported/dal/delimiter.xml | 2 +-
.../src/main/resources/sql/supported/dal/drop.xml | 2 +-
.../src/main/resources/sql/supported/dal/set.xml | 2 +-
.../src/main/resources/sql/supported/dal/show.xml | 19 ++++++++++++++++++
.../main/resources/sql/supported/dal/shutdown.xml | 2 +-
.../dal/{drop.xml => start-stop-slave.xml} | 4 +++-
.../main/resources/sql/supported/dal/uninstall.xml | 2 ++
.../resources/sql/supported/dcl/alter-user.xml | 1 +
.../resources/sql/supported/dcl/create-user.xml | 10 ++++++++++
.../resources/sql/supported/dcl/rename-user.xml | 1 +
.../resources/sql/supported/ddl/alter-table.xml | 1 +
.../main/resources/sql/supported/dml/select.xml | 1 +
.../src/main/resources/sql/supported/dml/table.xml | 6 +++---
.../main/resources/sql/supported/dml/values.xml | 2 +-
.../src/main/resources/sql/supported/lcl/lock.xml | 1 +
33 files changed, 128 insertions(+), 34 deletions(-)
diff --git
a/infra/common/src/main/java/org/apache/shardingsphere/infra/instance/metadata/jdbc/JDBCInstanceMetaData.java
b/infra/common/src/main/java/org/apache/shardingsphere/infra/instance/metadata/jdbc/JDBCInstanceMetaData.java
index 91365261380..00687c3a595 100644
---
a/infra/common/src/main/java/org/apache/shardingsphere/infra/instance/metadata/jdbc/JDBCInstanceMetaData.java
+++
b/infra/common/src/main/java/org/apache/shardingsphere/infra/instance/metadata/jdbc/JDBCInstanceMetaData.java
@@ -18,6 +18,7 @@
package org.apache.shardingsphere.infra.instance.metadata.jdbc;
import lombok.Getter;
+import lombok.RequiredArgsConstructor;
import org.apache.shardingsphere.infra.version.ShardingSphereVersion;
import org.apache.shardingsphere.infra.instance.metadata.InstanceMetaData;
import org.apache.shardingsphere.infra.instance.metadata.InstanceType;
@@ -26,6 +27,7 @@ import org.apache.shardingsphere.infra.instance.util.IpUtils;
/**
* JDBC instance meta data.
*/
+@RequiredArgsConstructor
@Getter
public final class JDBCInstanceMetaData implements InstanceMetaData {
@@ -38,17 +40,7 @@ public final class JDBCInstanceMetaData implements
InstanceMetaData {
private final String databaseName;
public JDBCInstanceMetaData(final String id, final String databaseName) {
- this.id = id;
- ip = IpUtils.getIp();
- version = ShardingSphereVersion.VERSION;
- this.databaseName = databaseName;
- }
-
- public JDBCInstanceMetaData(final String id, final String attributes,
final String version, final String databaseName) {
- this.id = id;
- ip = attributes;
- this.version = version;
- this.databaseName = databaseName;
+ this(id, IpUtils.getIp(), ShardingSphereVersion.VERSION, databaseName);
}
@Override
diff --git
a/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/sample/SampleOptionSegment.java
b/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/sample/SampleOptionSegment.java
index 870308890d6..848f90f5b4c 100644
---
a/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/sample/SampleOptionSegment.java
+++
b/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/sample/SampleOptionSegment.java
@@ -28,9 +28,9 @@ import java.util.List;
/**
* Update statistics sample option segment.
*/
+@NoArgsConstructor
@Getter
@Setter
-@NoArgsConstructor
public final class SampleOptionSegment implements SQLSegment {
private int startIndex;
diff --git
a/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsOptionSegment.java
b/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsOptionSegment.java
index 6621c8a7135..2382b28dbd3 100644
---
a/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsOptionSegment.java
+++
b/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsOptionSegment.java
@@ -26,9 +26,9 @@ import
org.apache.shardingsphere.sql.parser.statement.core.segment.SQLSegment;
/**
* Update statistics option segment.
*/
+@NoArgsConstructor
@Getter
@Setter
-@NoArgsConstructor
public final class StatisticsOptionSegment implements SQLSegment {
private int startIndex;
diff --git
a/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsStrategySegment.java
b/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsStrategySegment.java
index 0a507bbd75a..183fb40ce2a 100644
---
a/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsStrategySegment.java
+++
b/parser/sql/statement/core/src/main/java/org/apache/shardingsphere/sql/parser/statement/core/segment/dml/statistics/StatisticsStrategySegment.java
@@ -26,9 +26,9 @@ import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.sample.Sa
/**
* Update statistics strategy segment.
*/
+@NoArgsConstructor
@Getter
@Setter
-@NoArgsConstructor
public final class StatisticsStrategySegment implements SQLSegment {
private int startIndex;
diff --git a/test/it/parser/src/main/resources/case/dcl/rename-user.xml
b/test/it/parser/src/main/resources/case/dal/analyze-table.xml
similarity index 90%
copy from test/it/parser/src/main/resources/case/dcl/rename-user.xml
copy to test/it/parser/src/main/resources/case/dal/analyze-table.xml
index 5041c63b0fa..c7e8bb85662 100644
--- a/test/it/parser/src/main/resources/case/dcl/rename-user.xml
+++ b/test/it/parser/src/main/resources/case/dal/analyze-table.xml
@@ -17,6 +17,5 @@
-->
<sql-parser-test-cases>
- <rename-user sql-case-id="rename_user" />
- <rename-user sql-case-id="rename_users" />
+ <common sql-case-id="analyze_table_doris" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dal/show.xml
b/test/it/parser/src/main/resources/case/dal/show.xml
index e7399303205..484f9fc7dd6 100644
--- a/test/it/parser/src/main/resources/case/dal/show.xml
+++ b/test/it/parser/src/main/resources/case/dal/show.xml
@@ -1120,4 +1120,27 @@
<show sql-case-id="show_compactions_with_limit" />
<show sql-case-id="show_compactions_with_compaction_ID" />
<show sql-case-id="show_compactions_all_options" />
+ <show sql-case-id="show_create_database_doris" />
+ <show sql-case-id="show_create_view_doris" />
+ <show sql-case-id="show_create_event_doris" />
+ <show sql-case-id="show_create_function_doris" />
+ <show sql-case-id="show_create_procedure_doris" />
+ <show-create-trigger sql-case-id="show_create_trigger_doris">
+ <trigger name="trg_test" start-index="20" stop-index="26" />
+ </show-create-trigger>
+ <show-create-user sql-case-id="show_create_user_doris">
+ <user name="user1" start-index="17" stop-index="21" />
+ </show-create-user>
+ <show sql-case-id="show_binary_logs_doris" />
+ <show-binlog-events sql-case-id="show_binlog_events_doris" />
+ <show sql-case-id="show_processlist_doris" />
+ <show-open-tables sql-case-id="show_open_tables_doris" />
+ <show-triggers sql-case-id="show_triggers_doris" />
+ <show-function-status sql-case-id="show_function_status_doris" />
+ <show-procedure-status sql-case-id="show_procedure_status_doris" />
+ <show sql-case-id="show_master_status_doris" />
+ <show-slave-status sql-case-id="show_slave_status_doris" />
+ <show-slave-hosts sql-case-id="show_slave_hosts_doris" />
+ <show-replica-status sql-case-id="show_replica_status_doris" />
+ <show-relay-log-events sql-case-id="show_relaylog_events_doris" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dcl/rename-user.xml
b/test/it/parser/src/main/resources/case/dal/start-stop-slave.xml
similarity index 86%
copy from test/it/parser/src/main/resources/case/dcl/rename-user.xml
copy to test/it/parser/src/main/resources/case/dal/start-stop-slave.xml
index 5041c63b0fa..4565102be5a 100644
--- a/test/it/parser/src/main/resources/case/dcl/rename-user.xml
+++ b/test/it/parser/src/main/resources/case/dal/start-stop-slave.xml
@@ -17,6 +17,7 @@
-->
<sql-parser-test-cases>
- <rename-user sql-case-id="rename_user" />
- <rename-user sql-case-id="rename_users" />
+ <common sql-case-id="start_slave_doris" />
+ <common sql-case-id="stop_slave_doris" />
+ <common sql-case-id="start_replica_doris" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dal/uninstall.xml
b/test/it/parser/src/main/resources/case/dal/uninstall.xml
index 635ccbdc0dd..8c5bab7beb0 100644
--- a/test/it/parser/src/main/resources/case/dal/uninstall.xml
+++ b/test/it/parser/src/main/resources/case/dal/uninstall.xml
@@ -29,4 +29,12 @@
<uninstall-plugin sql-case-id="uninstall_plugin">
<plugin name="binlog" start-index="17" stop-index="27" />
</uninstall-plugin>
+
+ <uninstall-component sql-case-id="uninstall_component_doris">
+ <component name="file://component_doris" start-index="20"
stop-index="43" />
+ </uninstall-component>
+
+ <uninstall-plugin sql-case-id="uninstall_plugin_doris">
+ <plugin name="audit" start-index="17" stop-index="21" />
+ </uninstall-plugin>
</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 701d2a4deab..0fef39f4504 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
@@ -70,4 +70,5 @@
<alter-user sql-case-id="alter_user_alias_to_existing_azure_id" />
<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" />
</sql-parser-test-cases>
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 6fe3021ddd6..3c605873ebc 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
@@ -73,4 +73,14 @@
<create-user sql-case-id="create_user_require_none_doris" />
<create-user sql-case-id="create_user_require_x509_doris" />
<create-user sql-case-id="create_user_require_tls_specified_doris" />
+ <create-user
sql-case-id="create_user_account_unlock_password_expire_interval_doris" />
+ <create-user sql-case-id="create_user_password_expire_never_doris" />
+ <create-user sql-case-id="create_user_password_expire_now_doris" />
+ <create-user sql-case-id="create_user_password_history_length_doris" />
+ <create-user sql-case-id="create_user_password_reuse_interval_doris" />
+ <create-user
sql-case-id="create_user_password_reuse_interval_default_doris" />
+ <create-user
sql-case-id="create_user_password_require_current_optional_doris" />
+ <create-user sql-case-id="create_user_password_require_current_yes_doris"
/>
+ <create-user sql-case-id="create_user_failed_login_and_lock_time_doris" />
+ <create-user sql-case-id="create_user_password_lock_time_unbounded_doris"
/>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/dcl/rename-user.xml
b/test/it/parser/src/main/resources/case/dcl/rename-user.xml
index 5041c63b0fa..0ad94325f25 100644
--- a/test/it/parser/src/main/resources/case/dcl/rename-user.xml
+++ b/test/it/parser/src/main/resources/case/dcl/rename-user.xml
@@ -19,4 +19,5 @@
<sql-parser-test-cases>
<rename-user sql-case-id="rename_user" />
<rename-user sql-case-id="rename_users" />
+ <rename-user sql-case-id="rename_user_doris" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-table.xml
b/test/it/parser/src/main/resources/case/ddl/alter-table.xml
index e0736f69331..b7446949e18 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-table.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-table.xml
@@ -2592,4 +2592,13 @@
</column-position>
</add-column>
</alter-table>
+
+ <alter-table sql-case-id="alter_table_with_algorithm_lock_doris">
+ <table name="t_order" start-index="12" stop-index="18" />
+ <add-column>
+ <column-definition type="INT" start-index="31" stop-index="41">
+ <column name="col_alg" start-index="31" stop-index="37" />
+ </column-definition>
+ </add-column>
+ </alter-table>
</sql-parser-test-cases>
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 72492ec9345..abf7f555b9f 100644
--- a/test/it/parser/src/main/resources/case/dml/select.xml
+++ b/test/it/parser/src/main/resources/case/dml/select.xml
@@ -11963,4 +11963,15 @@
</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" />
+ </projections>
+ <from start-index="14" stop-index="29">
+ <function-table start-index="14" stop-index="29">
+ <table-function function-name="table_func" text="table_func(1,
2)" start-index="14" stop-index="29" />
+ </function-table>
+ </from>
+ </select>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/tcl/unlock.xml
b/test/it/parser/src/main/resources/case/tcl/unlock.xml
index 8dfa4982767..ec049885d62 100644
--- a/test/it/parser/src/main/resources/case/tcl/unlock.xml
+++ b/test/it/parser/src/main/resources/case/tcl/unlock.xml
@@ -20,4 +20,5 @@
<unlock sql-case-id="unlock_table" />
<unlock sql-case-id="unlock_tables" />
<unlock sql-case-id="unlock_instance" />
+ <unlock sql-case-id="unlock_tables_doris" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/alter.xml
b/test/it/parser/src/main/resources/sql/supported/dal/alter.xml
index 5182c3cf8e4..9bd3eb77a85 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/alter.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/alter.xml
@@ -17,7 +17,7 @@
-->
<sql-cases>
- <sql-case id="alter_resource_group" value="ALTER RESOURCE GROUP rg"
db-types="MySQL" />
+ <sql-case id="alter_resource_group" value="ALTER RESOURCE GROUP rg"
db-types="MySQL,Doris" />
<sql-case id="alter_resource_cost_cpu_time" value="ALTER RESOURCE COST
CPU_PER_SESSION 100 CONNECT_TIME 1" db-types="Oracle" />
<sql-case id="alter_resource_cost_cpu" value="ALTER RESOURCE COST
CPU_PER_SESSION 100" db-types="Oracle" />
<sql-case id="alter_resource_properties" value="ALTER RESOURCE 'remote_s3'
PROPERTIES ("s3.connection.maximum" = "100");"
db-types="Doris" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
b/test/it/parser/src/main/resources/sql/supported/dal/analyze-table.xml
similarity index 90%
copy from test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
copy to test/it/parser/src/main/resources/sql/supported/dal/analyze-table.xml
index 1381dffa226..793a90c6c46 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/analyze-table.xml
@@ -17,5 +17,5 @@
-->
<sql-cases>
- <sql-case id="shutdown" value="SHUTDOWN" db-types="MySQL" />
+ <sql-case id="analyze_table_doris" value="ANALYZE TABLE t_order"
db-types="Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/clone.xml
b/test/it/parser/src/main/resources/sql/supported/dal/clone.xml
index b9a61a30eba..3c7f6714676 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/clone.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/clone.xml
@@ -18,8 +18,8 @@
<sql-cases>
<sql-case id="clone_local" value="CLONE LOCAL DATA DIRECTORY =
'/path/to/clone_dir'" db-types="MySQL" />
- <sql-case id="clone_instance" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password'"
db-types="MySQL" />
- <sql-case id="clone_instance_with_data_dir" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password' DATA
DIRECTORY = '/tmp/clone_dir'" db-types="MySQL" />
- <sql-case id="clone_instance_require_ssl" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password'
REQUIRE SSL" db-types="MySQL" />
+ <sql-case id="clone_instance" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password'"
db-types="MySQL,Doris" />
+ <sql-case id="clone_instance_with_data_dir" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password' DATA
DIRECTORY = '/tmp/clone_dir'" db-types="MySQL,Doris" />
+ <sql-case id="clone_instance_require_ssl" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password'
REQUIRE SSL" db-types="MySQL,Doris" />
<sql-case id="clone_instance_require_no_ssl" value="CLONE INSTANCE FROM
'donor_clone_user'@'example.donor.host.com':3306 IDENTIFIED BY 'password'
REQUIRE NO SSL" db-types="MySQL" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/create.xml
b/test/it/parser/src/main/resources/sql/supported/dal/create.xml
index 18835190798..2b3bc4ef685 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/create.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/create.xml
@@ -17,8 +17,8 @@
-->
<sql-cases>
- <sql-case id="create_resource_group" value="CREATE RESOURCE GROUP rg type
= user" db-types="MySQL" />
- <sql-case id="create_resource_group_with_system_type_and_thread_priority"
value="CREATE RESOURCE GROUP rg2 TYPE = SYSTEM THREAD_PRIORITY = -20 DISABLE"
db-types="MySQL"/>
+ <sql-case id="create_resource_group" value="CREATE RESOURCE GROUP rg type
= user" db-types="MySQL,Doris" />
+ <sql-case id="create_resource_group_with_system_type_and_thread_priority"
value="CREATE RESOURCE GROUP rg2 TYPE = SYSTEM THREAD_PRIORITY = -20 DISABLE"
db-types="MySQL,Doris"/>
<sql-case id="create_sql_block_rule_with_sql" value="CREATE SQL_BLOCK_RULE
test_rule PROPERTIES("sql"="select \\* from
order_analysis","global"="true","enable"="true")"
db-types="Doris" />
<sql-case id="create_sql_block_rule_with_sqlhash" value="CREATE
SQL_BLOCK_RULE block_rule_sqlhash
PROPERTIES("sqlHash"="0e5491b37dbea5e8","enable"="true")"
db-types="Doris" />
<sql-case id="create_sql_block_rule_with_partition_num" value="CREATE
SQL_BLOCK_RULE limit_partition_rule
PROPERTIES("partition_num"="30","global"="true")"
db-types="Doris" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/delimiter.xml
b/test/it/parser/src/main/resources/sql/supported/dal/delimiter.xml
index 940d1aee76e..eb5f3694d39 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/delimiter.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/delimiter.xml
@@ -17,5 +17,5 @@
-->
<sql-cases>
- <sql-case id="delimiter" value="DELIMITER |" db-types="MySQL" />
+ <sql-case id="delimiter" value="DELIMITER |" db-types="MySQL,Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/drop.xml
b/test/it/parser/src/main/resources/sql/supported/dal/drop.xml
index e06c0549c36..8e1a29dd424 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/drop.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/drop.xml
@@ -17,5 +17,5 @@
-->
<sql-cases>
- <sql-case id="drop_resource_group" value="DROP RESOURCE GROUP rg"
db-types="MySQL" />
+ <sql-case id="drop_resource_group" value="DROP RESOURCE GROUP rg"
db-types="MySQL,Doris" />
</sql-cases>
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 94660d252fb..3985edf77be 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,7 +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_resource_group" value="SET RESOURCE GROUP rg"
db-types="MySQL" />
+ <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" />
<sql-case id="set_client_encoding" value="SET CLIENT_ENCODING TO 'UTF8'"
db-types="PostgreSQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/show.xml
b/test/it/parser/src/main/resources/sql/supported/dal/show.xml
index 1c11624d74c..7c531c356b8 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/show.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/show.xml
@@ -241,4 +241,23 @@
<sql-case id="show_query_stats_all" value="SHOW QUERY STATS ALL"
db-types="Doris" />
<sql-case id="show_query_stats_verbose" value="SHOW QUERY STATS VERBOSE"
db-types="Doris" />
<sql-case id="show_query_stats_from_table_all_verbose" value="SHOW QUERY
STATS FROM test_table ALL VERBOSE" db-types="Doris" />
+ <sql-case id="show_create_database_doris" value="SHOW CREATE DATABASE
test_db" db-types="Doris" />
+ <sql-case id="show_create_view_doris" value="SHOW CREATE VIEW v_sales"
db-types="Doris" />
+ <sql-case id="show_create_event_doris" value="SHOW CREATE EVENT ev_annual"
db-types="Doris" />
+ <sql-case id="show_create_function_doris" value="SHOW CREATE FUNCTION
udf_add" db-types="Doris" />
+ <sql-case id="show_create_procedure_doris" value="SHOW CREATE PROCEDURE
proc_test" db-types="Doris" />
+ <sql-case id="show_create_trigger_doris" value="SHOW CREATE TRIGGER
trg_test" db-types="Doris" />
+ <sql-case id="show_create_user_doris" value="SHOW CREATE USER user1"
db-types="Doris" />
+ <sql-case id="show_binary_logs_doris" value="SHOW BINARY LOGS"
db-types="Doris" />
+ <sql-case id="show_binlog_events_doris" value="SHOW BINLOG EVENTS"
db-types="Doris" />
+ <sql-case id="show_processlist_doris" value="SHOW PROCESSLIST"
db-types="Doris" />
+ <sql-case id="show_open_tables_doris" value="SHOW OPEN TABLES"
db-types="Doris" />
+ <sql-case id="show_triggers_doris" value="SHOW TRIGGERS" db-types="Doris"
/>
+ <sql-case id="show_function_status_doris" value="SHOW FUNCTION STATUS"
db-types="Doris" />
+ <sql-case id="show_procedure_status_doris" value="SHOW PROCEDURE STATUS"
db-types="Doris" />
+ <sql-case id="show_master_status_doris" value="SHOW MASTER STATUS"
db-types="Doris" />
+ <sql-case id="show_slave_status_doris" value="SHOW SLAVE STATUS"
db-types="Doris" />
+ <sql-case id="show_slave_hosts_doris" value="SHOW SLAVE HOSTS"
db-types="Doris" />
+ <sql-case id="show_replica_status_doris" value="SHOW REPLICA STATUS"
db-types="Doris" />
+ <sql-case id="show_relaylog_events_doris" value="SHOW RELAYLOG EVENTS"
db-types="Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
b/test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
index 1381dffa226..919957949f2 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/shutdown.xml
@@ -17,5 +17,5 @@
-->
<sql-cases>
- <sql-case id="shutdown" value="SHUTDOWN" db-types="MySQL" />
+ <sql-case id="shutdown" value="SHUTDOWN" db-types="MySQL,Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/drop.xml
b/test/it/parser/src/main/resources/sql/supported/dal/start-stop-slave.xml
similarity index 76%
copy from test/it/parser/src/main/resources/sql/supported/dal/drop.xml
copy to test/it/parser/src/main/resources/sql/supported/dal/start-stop-slave.xml
index e06c0549c36..ebc6156e781 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/drop.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/start-stop-slave.xml
@@ -17,5 +17,7 @@
-->
<sql-cases>
- <sql-case id="drop_resource_group" value="DROP RESOURCE GROUP rg"
db-types="MySQL" />
+ <sql-case id="start_slave_doris" value="START SLAVE SQL_THREAD USER='u'"
db-types="Doris" />
+ <sql-case id="stop_slave_doris" value="STOP SLAVE SQL_THREAD"
db-types="Doris" />
+ <sql-case id="start_replica_doris" value="START REPLICA SQL_THREAD"
db-types="Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dal/uninstall.xml
b/test/it/parser/src/main/resources/sql/supported/dal/uninstall.xml
index 5e9e997cba6..44e9205dc09 100644
--- a/test/it/parser/src/main/resources/sql/supported/dal/uninstall.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dal/uninstall.xml
@@ -20,4 +20,6 @@
<sql-case id="uninstall_component" value="UNINSTALL COMPONENT
'file://component1'" db-types="MySQL" />
<sql-case id="uninstall_components" value="UNINSTALL COMPONENT
'file://component1', 'file://component2'" db-types="MySQL" />
<sql-case id="uninstall_plugin" value="UNINSTALL PLUGIN binlog"
db-types="MySQL" />
+ <sql-case id="uninstall_component_doris" value="UNINSTALL COMPONENT
'file://component_doris'" db-types="Doris" />
+ <sql-case id="uninstall_plugin_doris" value="UNINSTALL PLUGIN audit"
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 1c7325eccd3..5374500d578 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
@@ -35,6 +35,7 @@
<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_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_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/sql/supported/dcl/create-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
index c422d09d6f9..9ae7eaef403 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
@@ -35,6 +35,16 @@
<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_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" />
+ <sql-case id="create_user_password_expire_now_doris" value="CREATE USER
user_expire_now PASSWORD EXPIRE" db-types="Doris" />
+ <sql-case id="create_user_password_history_length_doris" value="CREATE
USER user_history PASSWORD HISTORY 5" db-types="Doris" />
+ <sql-case id="create_user_password_reuse_interval_doris" value="CREATE
USER user_reuse PASSWORD REUSE INTERVAL 10 DAY" db-types="Doris" />
+ <sql-case id="create_user_password_reuse_interval_default_doris"
value="CREATE USER user_reuse_default PASSWORD REUSE INTERVAL DEFAULT"
db-types="Doris" />
+ <sql-case id="create_user_password_require_current_optional_doris"
value="CREATE USER user_require_optional PASSWORD REQUIRE CURRENT OPTIONAL"
db-types="Doris" />
+ <sql-case id="create_user_password_require_current_yes_doris"
value="CREATE USER user_require_yes PASSWORD REQUIRE CURRENT" db-types="Doris"
/>
+ <sql-case id="create_user_failed_login_and_lock_time_doris" value="CREATE
USER user_failed_lock PASSWORD EXPIRE DEFAULT FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 7" db-types="Doris" />
+ <sql-case id="create_user_password_lock_time_unbounded_doris"
value="CREATE USER user_lock_unbounded PASSWORD EXPIRE DEFAULT
PASSWORD_LOCK_TIME UNBOUNDED" db-types="Doris" />
<sql-case id="create_user_require_ssl_doris" value="CREATE USER user_ssl
REQUIRE SSL" db-types="Doris" />
<sql-case id="create_user_require_none_doris" value="CREATE USER
user_no_tls REQUIRE NONE" db-types="Doris" />
<sql-case id="create_user_require_x509_doris" value="CREATE USER user_x509
REQUIRE X509" db-types="Doris" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/rename-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/rename-user.xml
index c1210097d32..7246f190e83 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/rename-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/rename-user.xml
@@ -19,4 +19,5 @@
<sql-cases>
<sql-case id="rename_user" value="RENAME USER 'user_dev'@'localhost' TO
'user_dev'@'127.0.0.1'" db-types="MySQL" />
<sql-case id="rename_users" value="RENAME USER user1_bak TO user1,
user2_bak TO user2" db-types="MySQL" />
+ <sql-case id="rename_user_doris" value="RENAME USER user_old TO user_new"
db-types="Doris" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-table.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-table.xml
index 0e667345175..074037d55f6 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-table.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-table.xml
@@ -377,4 +377,5 @@
<sql-case id="alter_table_rename_column_doris" value="ALTER TABLE
example_table RENAME COLUMN c1 c2" db-types="Doris" />
<sql-case id="alter_table_rename_rollup" value="ALTER TABLE example_table
RENAME ROLLUP rollup1 rollup2" db-types="Doris" />
<sql-case id="alter_table_rename_partition" value="ALTER TABLE
example_table RENAME PARTITION partition1 partition2" db-types="Doris" />
+ <sql-case id="alter_table_with_algorithm_lock_doris" value="ALTER TABLE
t_order ADD COLUMN col_alg INT, ALGORITHM=INSTANT, LOCK=NONE" db-types="Doris"
/>
</sql-cases>
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 c6b6ca78fdd..e84f715a416 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
@@ -393,4 +393,5 @@
<sql-case id="select_force_single_node_plan_hint" value="SELECT * FROM
Person OPTION (FORCE SINGLE NODE PLAN);" db-types="SQLServer"/>
<sql-case id="select_querytraceon_hint" value="SELECT * FROM Person OPTION
(QUERYTRACEON 4199, QUERYTRACEON 4137);" db-types="SQLServer"/>
<sql-case id="select_with_sample_clause" value="SELECT 1 AS C1 FROM
T_ORDER SAMPLE BLOCK (1.43302, 8) SEED(9) T_ORDER" db-types="Oracle" />
+ <sql-case id="select_from_function_table_doris" value="SELECT * FROM
table_func(1, 2)" db-types="Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/table.xml
b/test/it/parser/src/main/resources/sql/supported/dml/table.xml
index c6f550d1357..00dd4fca7da 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/table.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/table.xml
@@ -17,8 +17,8 @@
-->
<sql-cases>
- <sql-case id="explicit_table" value="table f" db-types="MySQL" />
- <sql-case id="table_with_order_by_limit_offset" value="TABLE t_order ORDER
BY order_id LIMIT 1 OFFSET 2" db-types="MySQL" />
- <sql-case id="table_union" value="TABLE T1 UNION TABLE T2"
db-types="MySQL" />
+ <sql-case id="explicit_table" value="table f" db-types="MySQL,Doris" />
+ <sql-case id="table_with_order_by_limit_offset" value="TABLE t_order ORDER
BY order_id LIMIT 1 OFFSET 2" db-types="MySQL,Doris" />
+ <sql-case id="table_union" value="TABLE T1 UNION TABLE T2"
db-types="MySQL,Doris" />
<sql-case id="select_from_with_table" value="SELECT * FROM (TABLE t0) AS
dt" db-types="MySQL" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/values.xml
b/test/it/parser/src/main/resources/sql/supported/dml/values.xml
index 4ffecf2961c..4337786a4a2 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/values.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/values.xml
@@ -18,7 +18,7 @@
<sql-cases>
<sql-case id="values_with_regexp_replace" value="SELECT REGEXP_REPLACE(e,
'pattern', 'xyz')FROM (VALUES ROW('Find pattern'), ROW(NULL), ROW('Find
pattern')) AS v(e)" db-types="MySQL" />
- <sql-case id="values_with_row" value="values ROW(1,2)"
db-types="MySQL,Presto" />
+ <sql-case id="values_with_row" value="values ROW(1,2)"
db-types="MySQL,Presto,Doris" />
<sql-case id="values_with_order_limit" value="VALUES ROW(1,-2,3),
ROW(5,7,9), ROW(4,6,8) ORDER BY column_1 desc , column_0 desc limit 10"
db-types="MySQL" />
<sql-case id="values_with_select" value="values row((select 1), 2)"
db-types="MySQL" />
</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 ff56fbe0729..12549780725 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
@@ -30,6 +30,7 @@
<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" />
+ <sql-case id="unlock_tables_doris" value="UNLOCK TABLES" db-types="Doris"
/>
<sql-case id="lock_table_access_exclusive_nowait" value="LOCK TABLE
lock_tbl1 IN ACCESS EXCLUSIVE MODE NOWAIT;" db-types="PostgreSQL" />
<sql-case id="lock_table_access_share_nowait" value="LOCK TABLE lock_tbl1
IN ACCESS SHARE MODE NOWAIT;" db-types="PostgreSQL" />
<sql-case id="lock_table_access_share" value="LOCK TABLE lock_tbl1 IN
ACCESS SHARE MODE;" db-types="PostgreSQL" />
