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 adb42957837 Add testcase to support parsing of ALTER SCHEMA in
PostgreSQL (#19311)
adb42957837 is described below
commit adb4295783713c2febceb7014dca96d6bf3220ff
Author: Everly Precia Suresh <[email protected]>
AuthorDate: Mon Jul 18 18:02:47 2022 +0530
Add testcase to support parsing of ALTER SCHEMA in PostgreSQL (#19311)
* Add testcase to support parsing of ALTER SCHEMA in PostgreSQL
* make requested changes
---
.../src/main/resources/case/ddl/alter-schema.xml | 2 ++
.../src/main/resources/sql/supported/ddl/alter-schema.xml | 2 ++
2 files changed, 4 insertions(+)
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-schema.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-schema.xml
index 7a890f46b43..f1900d23d55 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-schema.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-schema.xml
@@ -18,4 +18,6 @@
<sql-parser-test-cases>
<alter-schema sql-case-id="alter_schema_transfer_ownership" />
+ <alter-schema sql-case-id="alter_schema_rename_to" />
+ <alter-schema sql-case-id="alter_schema_owner_to" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-schema.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-schema.xml
index 8a688b67bc8..a4b351e0d7a 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-schema.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-schema.xml
@@ -18,4 +18,6 @@
<sql-cases>
<sql-case id="alter_schema_transfer_ownership" value="ALTER SCHEMA
HumanResources TRANSFER Person.Address" db-types="SQLServer" />
+ <sql-case id="alter_schema_rename_to" value="ALTER SCHEMA accounts RENAME
TO accounting;" db-types="PostgreSQL" />
+ <sql-case id="alter_schema_owner_to" value="ALTER SCHEMA accounting OWNER
TO CURRENT_USER;" db-types="PostgreSQL" />
</sql-cases>
