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 ac4b7b9f097 Add Oracle alter index test sql parse (#27560)
ac4b7b9f097 is described below
commit ac4b7b9f09760d4d6f1469882fda794b66a1942e
Author: niu niu <[email protected]>
AuthorDate: Sun Jul 30 16:02:41 2023 +0800
Add Oracle alter index test sql parse (#27560)
---
.../src/main/resources/case/ddl/alter-index.xml | 20 ++++++++++++++++++++
.../main/resources/sql/supported/ddl/alter-index.xml | 5 +++++
2 files changed, 25 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-index.xml
b/test/it/parser/src/main/resources/case/ddl/alter-index.xml
index ab6edc65118..68aa7548b08 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-index.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-index.xml
@@ -90,6 +90,26 @@
<index name="cost_ix" start-index="12" stop-index="18" />
</alter-index>
+ <alter-index sql-case-id="alter_index_rename_partition">
+ <index name="cost_ix" start-index="12" stop-index="18" />
+ </alter-index>
+
+ <alter-index sql-case-id="alter_index_split_partition_at_into">
+ <index name="cost_ix" start-index="12" stop-index="18" />
+ </alter-index>
+
+ <alter-index sql-case-id="alter_index_storage">
+ <index name="emp_ename" start-index="12" stop-index="20" />
+ </alter-index>
+
+ <alter-index sql-case-id="alter_index_add_partition">
+ <index name="hgidx" start-index="12" stop-index="16" />
+ </alter-index>
+
+ <alter-index sql-case-id="alter_index_parameters">
+ <index name="po_xmlindex_ix" start-index="12" stop-index="25" />
+ </alter-index>
+
<alter-index sql-case-id="alter_index_alter_column" />
<alter-index sql-case-id="alter_index_with_schema" />
<alter-index sql-case-id="alter_index_set_tablespace" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
index 6a69e529721..d3b9abb7a63 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
@@ -37,6 +37,11 @@
<sql-case id="alter_index_parameters_odci" value="ALTER INDEX
ResumeTextIndex PARAMETERS (':Ignore on')" db-types="Oracle" />
<sql-case id="alter_index_modify_partition_unusable" value="ALTER INDEX
cost_ix MODIFY PARTITION p2 UNUSABLE" db-types="Oracle" />
<sql-case id="alter_index_drop_partition" value="ALTER INDEX cost_ix DROP
PARTITION p1" db-types="Oracle" />
+ <sql-case id="alter_index_rename_partition" value="ALTER INDEX cost_ix
RENAME PARTITION p3 TO p3_Q3" db-types="Oracle" />
+ <sql-case id="alter_index_split_partition_at_into" value="ALTER INDEX
cost_ix SPLIT PARTITION p2 AT (1500) INTO (PARTITION p2a TABLESPACE tbs_01
LOGGING, PARTITION p2b TABLESPACE tbs_02)" db-types="Oracle" />
+ <sql-case id="alter_index_storage" value="ALTER INDEX emp_ename STORAGE
(NEXT 40)" db-types="Oracle" />
+ <sql-case id="alter_index_add_partition" value="ALTER INDEX hgidx ADD
PARTITION p5" db-types="Oracle" />
+ <sql-case id="alter_index_parameters" value="ALTER INDEX po_xmlindex_ix
PARAMETERS('DROP PATH TABLE')" db-types="Oracle" />
<sql-case id="alter_index_set_tablespace" value="ALTER INDEX distributors
SET TABLESPACE fasttablespace" db-types="PostgreSQL,openGauss" />
<sql-case id="alter_index_alter_column" value="ALTER INDEX t_order_idx
ALTER COLUMN 3 SET STATISTICS 1000" db-types="PostgreSQL,openGauss" />
<sql-case id="alter_index_with_schema" value="ALTER INDEX
public.t_order_idx ALTER COLUMN 3 SET STATISTICS 1000"
db-types="PostgreSQL,openGauss" />
