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 <77877486+everly-...@users.noreply.github.com> 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>