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>

Reply via email to