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/19 02:03:20 UTC
[shardingsphere] branch master updated: Add support for SET SESSION openGauss (#28458)
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 adedf9a927f Add support for SET SESSION openGauss (#28458)
adedf9a927f is described below
commit adedf9a927f5bed9e8e8e55fd564c04b8fac9a49
Author: Akash Pambhar <71...@users.noreply.github.com>
AuthorDate: Tue Sep 19 07:33:12 2023 +0530
Add support for SET SESSION openGauss (#28458)
Add support for SET SESSION AUTHORIZATION FOR openGauss
---
.../dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4 | 2 +-
test/it/parser/src/main/resources/case/dal/set.xml | 1 +
test/it/parser/src/main/resources/sql/supported/dal/set.xml | 1 +
3 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4
index c7e2d9c0147..6344fecc527 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4
@@ -33,7 +33,7 @@ set
| SCHEMA STRING_
| NAMES encoding?
| ROLE nonReservedWordOrSconst
- | SESSION AUTHORIZATION nonReservedWordOrSconst
+ | SESSION AUTHORIZATION IDENTIFIER_ PASSWORD STRING_
| SESSION AUTHORIZATION DEFAULT
| XML OPTION documentOrContent)
;
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 80b95dfbceb..f955d30e79a 100644
--- a/test/it/parser/src/main/resources/case/dal/set.xml
+++ b/test/it/parser/src/main/resources/case/dal/set.xml
@@ -118,4 +118,5 @@
<parameter name="CLIENT_ENCODING" />
</parameter-assign>
</set-parameter>
+ <set-parameter sql-case-id="set_session_authorization" />
</sql-parser-test-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 7c748805f26..0f92b710d61 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
@@ -44,4 +44,5 @@
<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" />
+ <sql-case id="set_session_authorization" value="SET SESSION AUTHORIZATION user1 PASSWORD 'password'" db-types="openGauss" />
</sql-cases>