You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/09/05 06:15:11 UTC
[shardingsphere] branch master updated: support EXECUTE statement (#28242)
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 <12...@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>