[shardingsphere] branch master updated: support EXECUTE statement (#28242)

[duanzhengqiang]

This is an automated email from the ASF dual-hosted git repository.

duanzhengqiang 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 1cec5c712f5 support EXECUTE statement (#28242)
1cec5c712f5 is described below

commit 1cec5c712f591a06c93e06076b05cf943397442a
Author: qywang <129274332+wang-qing-y...@users.noreply.github.com>
AuthorDate: Tue Sep 5 14:15:05 2023 +0800

    support EXECUTE statement (#28242)
---
 .../postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4       | 2 +-
 test/it/parser/src/main/resources/case/ddl/execute.xml                  | 1 +
 test/it/parser/src/main/resources/sql/supported/ddl/execute.xml         | 1 +
 3 files changed, 3 insertions(+), 1 deletion(-)

diff --git 
a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
 
b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
index dba4b56180d..de2ad41bd01 100644
--- 
a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
+++ 
b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
@@ -975,7 +975,7 @@ alterMaterializedViewClauses
     ;
 
 executeStmt
-    : EXECUTE name executeParamClause
+    : EXECUTE name executeParamClause?
     ;
 
 createMaterializedView
diff --git a/test/it/parser/src/main/resources/case/ddl/execute.xml 
b/test/it/parser/src/main/resources/case/ddl/execute.xml
index 3d2a8e706eb..4251a129fbf 100644
--- a/test/it/parser/src/main/resources/case/ddl/execute.xml
+++ b/test/it/parser/src/main/resources/case/ddl/execute.xml
@@ -18,4 +18,5 @@
 
 <sql-parser-test-cases>
     <execute sql-case-id="execute_with_expected_db_table" />
+    <execute sql-case-id="execute_without_parameter" />
 </sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/execute.xml 
b/test/it/parser/src/main/resources/sql/supported/ddl/execute.xml
index 5682d3c55a3..209cdbb3199 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/execute.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/execute.xml
@@ -18,4 +18,5 @@
 
 <sql-cases>
     <sql-case id="execute_with_expected_db_table" value="EXECUTE ps1 USING 
@expected, @db, @table" db-types="MySQL" />
+    <sql-case id="execute_without_parameter" value="EXECUTE q" 
db-types="PostgreSQL" />
 </sql-cases>