You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2026/08/12 02:38:30 UTC

(shardingsphere) branch master updated: Support parsing Oracle CREATE INDEXTYPE sql and Add CREATE INDEX/OPERATOR sql it test (#39302)

This is an automated email from the ASF dual-hosted git repository.

terrymanu 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 881898ca445 Support parsing Oracle CREATE INDEXTYPE sql and Add CREATE INDEX/OPERATOR sql it test (#39302)
881898ca445 is described below

commit 881898ca445598de81bfc711d32acd7c7957e5ad
Author: Claire <cl...@163.com>
AuthorDate: Wed Aug 12 10:38:23 2026 +0800

    Support parsing Oracle CREATE INDEXTYPE sql and Add CREATE INDEX/OPERATOR sql it test (#39302)
    
    * support oracle create indextype
    
    * release notes
    
    * add test
    
    * release notes
    
    * update code
    
    * confict
---
 RELEASE-NOTES.md                                   |  1 +
 .../core/database/visitor/SQLVisitorRule.java      |  2 ++
 .../src/main/antlr4/imports/oracle/DDLStatement.g4 |  8 ++++++
 .../sql/parser/autogen/OracleStatement.g4          |  1 +
 .../statement/type/OracleDDLStatementVisitor.java  |  7 +++++
 .../ddl/index/OracleCreateIndexTypeStatement.java  | 31 ++++++++++++++++++++++
 .../dialect/oracle/OracleDDLStatementAssert.java   |  5 ++++
 .../cases/parser/jaxb/RootSQLParserTestCases.java  |  4 +++
 .../OracleCreateIndexTypeStatementTestCase.java    | 26 ++++++++++++++++++
 .../{create-operator.xml => create-index-type.xml} | 11 +++-----
 .../src/main/resources/case/ddl/create-index.xml   |  8 ++++++
 .../main/resources/case/ddl/create-operator.xml    |  1 +
 .../supported/ddl/create-index-type.xml}           | 15 +++++------
 .../resources/sql/supported/ddl/create-index.xml   |  1 +
 .../sql/supported/ddl/create-operator.xml          |  1 +
 15 files changed, 106 insertions(+), 16 deletions(-)

diff --git a/RELEASE-NOTES.md b/RELEASE-NOTES.md
index ec3e6ba947e..fc96fa7ce6e 100644
--- a/RELEASE-NOTES.md
+++ b/RELEASE-NOTES.md
@@ -86,6 +86,7 @@
 1. SQL Parser: Support Oracle procedure parser and binder - [#39231](https://github.com/apache/shardingsphere/pull/39231)
 1. SQL Parser: Support Oracle database object DDL parsing - [#39286](https://github.com/apache/shardingsphere/pull/39286)
 1. SQL Parser: Support parsing Oracle CREATE INDEX sql - [#39292](https://github.com/apache/shardingsphere/pull/39292)
+1. SQL Parser: Support parsing Oracle CREATE INDEXTYPE sql and Add CREATE INDEX/OPERATOR sql it test - [#39302](https://github.com/apache/shardingsphere/pull/39302) 
 1. SQL Parser: Support function table alias column parsing for PostgreSQL and openGauss - [#39268](https://github.com/apache/shardingsphere/pull/39268)
 1. SQL Parser: Support MySQL and Oracle CTAS parsing and binding enhancements, and Doris TABLE statement segment extraction - [#39332](https://github.com/apache/shardingsphere/pull/39332)
 1. SQL Parser: Support Oracle full width SQL symbols parsing - [#39349](https://github.com/apache/shardingsphere/pull/39349)
diff --git a/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java b/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
index 122c7f6e69d..e4f7b06f112 100644
--- a/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
+++ b/parser/sql/engine/core/src/main/java/org/apache/shardingsphere/sql/parser/engine/core/database/visitor/SQLVisitorRule.java
@@ -815,6 +815,8 @@ public enum SQLVisitorRule {
     
     CREATE_OPERATOR("CreateOperator", SQLStatementType.DDL),
     
+    CREATE_INDEX_TYPE("CreateIndexType", SQLStatementType.DDL),
+    
     CREATE_POLICY("CreatePolicy", SQLStatementType.DDL),
     
     DROP_INDEX_TYPE("DropIndexType", SQLStatementType.DDL),
diff --git a/parser/sql/engine/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 b/parser/sql/engine/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
index 526c9ce2cca..03186aa0efc 100644
--- a/parser/sql/engine/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
+++ b/parser/sql/engine/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
@@ -83,6 +83,14 @@ functionNameDef
     : identifier (DOT_ functionName)?
     ;
 
+createIndexType
+    : CREATE (OR REPLACE)? INDEXTYPE indexTypeName FOR indexTypeOperatorClause (COMMA_ indexTypeOperatorClause)* usingTypeClause withLocalClause
+    ;
+
+indexTypeOperatorClause
+    : operatorName LP_ parameterType (COMMA_ parameterType)* RP_
+    ;
+
 createType
     : CREATE (OR REPLACE)? (EDITIONABLE | NONEDITIONABLE)? TYPE plsqlTypeSource
     ;
diff --git a/parser/sql/engine/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4 b/parser/sql/engine/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
index eab2f43ad52..d243f9963da 100644
--- a/parser/sql/engine/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
+++ b/parser/sql/engine/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
@@ -164,6 +164,7 @@ execute
     | show
     | spool
     | createOperator
+    | createIndexType
     | createOutline
     ) SEMI_? SLASH_? EOF
     ;
diff --git a/parser/sql/engine/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/engine/oracle/visitor/statement/type/OracleDDLStatementVisitor.java b/parser/sql/engine/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/engine/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
index adbb645284d..c95c680e3b4 100644
--- a/parser/sql/engine/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/engine/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
+++ b/parser/sql/engine/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/engine/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
@@ -215,6 +215,7 @@ import org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.Trunca
 import org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.TypeNameContext;
 import org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.VariableNameContext;
 import org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.VarrayTypeSpecContext;
+import org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.CreateIndexTypeContext;
 import org.apache.shardingsphere.sql.parser.engine.oracle.visitor.statement.OracleStatementVisitor;
 import org.apache.shardingsphere.sql.parser.statement.core.segment.dal.VariableSegment;
 import org.apache.shardingsphere.sql.parser.statement.core.segment.ddl.AlterDefinitionSegment;
@@ -340,6 +341,7 @@ import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.flashback.Oracl
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.flashback.OracleFlashbackTableStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.function.OracleCreateFunctionStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.index.OracleAlterIndexTypeStatement;
+import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.index.OracleCreateIndexTypeStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.index.OracleDropIndexTypeStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.java.OracleAlterJavaStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.java.OracleCreateJavaStatement;
@@ -1523,6 +1525,11 @@ public final class OracleDDLStatementVisitor extends OracleStatementVisitor impl
         return new OracleAlterIndexTypeStatement(getDatabaseType());
     }
     
+    @Override
+    public ASTNode visitCreateIndexType(final CreateIndexTypeContext ctx) {
+        return new OracleCreateIndexTypeStatement(getDatabaseType());
+    }
+    
     @Override
     public ASTNode visitAlterMaterializedView(final AlterMaterializedViewContext ctx) {
         return new AlterMaterializedViewStatement(getDatabaseType());
diff --git a/parser/sql/statement/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/statement/oracle/ddl/index/OracleCreateIndexTypeStatement.java b/parser/sql/statement/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/statement/oracle/ddl/index/OracleCreateIndexTypeStatement.java
new file mode 100644
index 00000000000..d91988d2e7c
--- /dev/null
+++ b/parser/sql/statement/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/statement/oracle/ddl/index/OracleCreateIndexTypeStatement.java
@@ -0,0 +1,31 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.sql.parser.statement.oracle.ddl.index;
+
+import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
+import org.apache.shardingsphere.sql.parser.statement.core.statement.type.ddl.DDLStatement;
+
+/**
+ * Create index type statement for Oracle.
+ */
+public final class OracleCreateIndexTypeStatement extends DDLStatement {
+    
+    public OracleCreateIndexTypeStatement(final DatabaseType databaseType) {
+        super(databaseType);
+    }
+}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ddl/dialect/oracle/OracleDDLStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ddl/dialect/oracle/OracleDDLStatementAssert.java
index 9beebbe4e75..dd29ad37c12 100644
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ddl/dialect/oracle/OracleDDLStatementAssert.java
+++ b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ddl/dialect/oracle/OracleDDLStatementAssert.java
@@ -29,6 +29,7 @@ import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.OraclePurgeStat
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.flashback.OracleFlashbackTableStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.pkg.OracleCreatePackageStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.statistics.OracleAssociateStatisticsStatement;
+import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.index.OracleCreateIndexTypeStatement;
 import org.apache.shardingsphere.sql.parser.statement.oracle.ddl.statistics.OracleDisassociateStatisticsStatement;
 import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
 import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ddl.dialect.oracle.type.OracleAlterSessionStatementAssert;
@@ -50,6 +51,7 @@ import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.s
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.OracleNoAuditStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.OraclePurgeStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.flashback.OracleFlashbackTableStatementTestCase;
+import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.index.OracleCreateIndexTypeStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.statistics.OracleAssociateStatisticsStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.statistics.OracleDisassociateStatisticsStatementTestCase;
 
@@ -87,6 +89,9 @@ public final class OracleDDLStatementAssert {
             OracleFlashbackTableStatementAssert.assertIs(assertContext, (OracleFlashbackTableStatement) actual, (OracleFlashbackTableStatementTestCase) expected);
         } else if (actual instanceof OraclePurgeStatement) {
             OraclePurgeStatementAssert.assertIs(assertContext, (OraclePurgeStatement) actual, (OraclePurgeStatementTestCase) expected);
+        } else if (expected instanceof OracleCreateIndexTypeStatementTestCase) {
+            org.hamcrest.MatcherAssert.assertThat(assertContext.getText("Actual statement should be OracleCreateIndexTypeStatement."),
+                    actual, org.hamcrest.CoreMatchers.instanceOf(OracleCreateIndexTypeStatement.class));
         }
     }
 }
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
index f028486af0d..47b80949f60 100644
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
+++ b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
@@ -202,6 +202,7 @@ import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.s
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.flashback.OracleFlashbackDatabaseStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.flashback.OracleFlashbackTableStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.index.OracleAlterIndexTypeStatementTestCase;
+import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.index.OracleCreateIndexTypeStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.index.OracleDropIndexTypeStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.java.OracleAlterJavaStatementTestCase;
 import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.java.OracleCreateJavaStatementTestCase;
@@ -1681,6 +1682,9 @@ public final class RootSQLParserTestCases {
     @XmlElement(name = "alter-index-type")
     private final List<OracleAlterIndexTypeStatementTestCase> alterIndexTypeTestCases = new LinkedList<>();
     
+    @XmlElement(name = "create-index-type")
+    private final List<OracleCreateIndexTypeStatementTestCase> createIndexTypeTestCases = new LinkedList<>();
+    
     @XmlElement(name = "alter-lockdown-profile")
     private final List<OracleAlterLockdownProfileStatementTestCase> alterLockdownProfileTestCases = new LinkedList<>();
     
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ddl/dialect/oracle/index/OracleCreateIndexTypeStatementTestCase.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ddl/dialect/oracle/index/OracleCreateIndexTypeStatementTestCase.java
new file mode 100644
index 00000000000..d8a1d1b35e2
--- /dev/null
+++ b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ddl/dialect/oracle/index/OracleCreateIndexTypeStatementTestCase.java
@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ddl.dialect.oracle.index;
+
+import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
+
+/**
+ * Create index type statement test case for Oracle.
+ */
+public final class OracleCreateIndexTypeStatementTestCase extends SQLParserTestCase {
+}
diff --git a/test/it/parser/src/main/resources/case/ddl/create-operator.xml b/test/it/parser/src/main/resources/case/ddl/create-index-type.xml
similarity index 64%
copy from test/it/parser/src/main/resources/case/ddl/create-operator.xml
copy to test/it/parser/src/main/resources/case/ddl/create-index-type.xml
index b6538526970..58b132f8bfe 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-operator.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-index-type.xml
@@ -17,11 +17,8 @@
   -->
 
 <sql-parser-test-cases>
-    <create-operator sql-case-id="create_operator" />
-    <create-operator sql-case-id="create_operator_with_procedure" />
-    <create-operator sql-case-id="create_operator_with_function" />
-    <create-operator sql-case-id="create_operator_with_schema_qualified_name" />
-    <create-operator sql-case-id="create_operator_with_binding" />
-    <create-operator sql-case-id="create_operator_with_binding_custom_datatype" />
-    <create-operator sql-case-id="create_operator_with_compute_ancillary_data" />
+    <create-index-type sql-case-id="create_index_type_with_system_managed_storage" />
+    <create-index-type sql-case-id="create_index_type_basic" />
+    <create-index-type sql-case-id="create_index_type_with_single_operators" />
+    <create-index-type sql-case-id="create_index_type_with_multiple_operators" />
 </sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-index.xml b/test/it/parser/src/main/resources/case/ddl/create-index.xml
index e0c1fcf7a30..7778f2b1773 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-index.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-index.xml
@@ -475,4 +475,12 @@
         </table>
         <column start-index="29" stop-index="36" name="document" />
     </create-index>
+
+    <create-index sql-case-id="create_index_with_indextype_and_parameters" index-type="indtype">
+        <index name="Test_indx" start-index="13" stop-index="21" />
+        <table>
+            <simple-table name="Test_tab" start-index="26" stop-index="33" />
+        </table>
+        <column start-index="35" stop-index="39" name="col_a" />
+    </create-index>
 </sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-operator.xml b/test/it/parser/src/main/resources/case/ddl/create-operator.xml
index b6538526970..0b5aa9c7fad 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-operator.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-operator.xml
@@ -24,4 +24,5 @@
     <create-operator sql-case-id="create_operator_with_binding" />
     <create-operator sql-case-id="create_operator_with_binding_custom_datatype" />
     <create-operator sql-case-id="create_operator_with_compute_ancillary_data" />
+    <create-operator sql-case-id="create_operator_with_single_binding" />
 </sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/create-operator.xml b/test/it/parser/src/main/resources/sql/supported/ddl/create-index-type.xml
similarity index 51%
copy from test/it/parser/src/main/resources/case/ddl/create-operator.xml
copy to test/it/parser/src/main/resources/sql/supported/ddl/create-index-type.xml
index b6538526970..ea7e50a3e86 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-operator.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-index-type.xml
@@ -16,12 +16,9 @@
   ~ limitations under the License.
   -->
 
-<sql-parser-test-cases>
-    <create-operator sql-case-id="create_operator" />
-    <create-operator sql-case-id="create_operator_with_procedure" />
-    <create-operator sql-case-id="create_operator_with_function" />
-    <create-operator sql-case-id="create_operator_with_schema_qualified_name" />
-    <create-operator sql-case-id="create_operator_with_binding" />
-    <create-operator sql-case-id="create_operator_with_binding_custom_datatype" />
-    <create-operator sql-case-id="create_operator_with_compute_ancillary_data" />
-</sql-parser-test-cases>
+<sql-cases>
+    <sql-case id="create_index_type_with_system_managed_storage" value="CREATE INDEXTYPE TextIndexType FOR Contains (VARCHAR2, VARCHAR2) USING TextIndexMethods WITH SYSTEM MANAGED STORAGE TABLES" db-types="Oracle" />
+    <sql-case id="create_index_type_basic" value="CREATE INDEXTYPE position_indextype FOR position_between(NUMBER, NUMBER, NUMBER) USING position_im" db-types="Oracle" />
+    <sql-case id="create_index_type_with_single_operators" value="CREATE INDEXTYPE indtype FOR userOp(NUMBER) USING imptype WITH SYSTEM MANAGED STORAGE TABLES" db-types="Oracle" />
+    <sql-case id="create_index_type_with_multiple_operators" value="CREATE INDEXTYPE indtype FOR userOp(NUMBER), anotherOp(VARCHAR2, NUMBER) USING imptype WITH SYSTEM MANAGED STORAGE TABLES" db-types="Oracle" />
+</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/create-index.xml b/test/it/parser/src/main/resources/sql/supported/ddl/create-index.xml
index eaae0b47f03..8d95d2646b9 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-index.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-index.xml
@@ -100,4 +100,5 @@
     <sql-case id="create_index_doris_with_comment" value="CREATE INDEX index1 ON table1 (column1) USING INVERTED COMMENT 'inverted index'" db-types="Doris" />
     <sql-case id="create_index_doris_full_syntax" value="CREATE INDEX IF NOT EXISTS index1 ON table1 (column1) USING INVERTED PROPERTIES ('parser' = 'standard') COMMENT 'full syntax'" db-types="Doris" />
     <sql-case id="create_index_with_domain_index_type" value="CREATE INDEX doc_idx on docs(document) indextype is ctxsys.context FILTER BY category, author ORDER BY pub_date desc, docid PARAMETERS ('memory 500M')" db-types="Oracle" />
+    <sql-case id="create_index_with_indextype_and_parameters" value="CREATE INDEX Test_indx ON Test_tab(col_a) INDEXTYPE IS indtype PARAMETERS('example')" db-types="Oracle" />
 </sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/create-operator.xml b/test/it/parser/src/main/resources/sql/supported/ddl/create-operator.xml
index 542b666b291..c29f76f0bbb 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-operator.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-operator.xml
@@ -24,4 +24,5 @@
     <sql-case id="create_operator_with_binding" value="CREATE OPERATOR Contains BINDING (VARCHAR2, VARCHAR2) RETURN NUMBER USING TextContains;" db-types="Oracle" />
     <sql-case id="create_operator_with_binding_custom_datatype" value="CREATE OPERATOR Contains BINDING (VARCHAR2, VARCHAR2) RETURN NUMBER USING text.contains, (Spatial.Geo, Spatial.Geo) RETURN NUMBER USING Spatial.contains;" db-types="Oracle" />
     <sql-case id="create_operator_with_compute_ancillary_data" value="CREATE OPERATOR Contains BINDING (VARCHAR2, VARCHAR2) RETURN NUMBER WITH INDEX CONTEXT, SCAN CONTEXT TextIndexMethods COMPUTE ANCILLARY DATA USING TextContains;" db-types="Oracle" />
+    <sql-case id="create_operator_with_single_binding" value="CREATE OPERATOR userOp BINDING (NUMBER) RETURN NUMBER USING userOp_func;" db-types="Oracle" />
 </sql-cases>