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/23 12:18:43 UTC
(shardingsphere) branch master updated: Add parser IT cases for Oracle CLUSTER_SET function and BIGFILE tablespace with datafile (#39577)
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 f88273b2e9a Add parser IT cases for Oracle CLUSTER_SET function and BIGFILE tablespace with datafile (#39577)
f88273b2e9a is described below
commit f88273b2e9a0a9711b35b843ae367711e37093c0
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Sun Aug 23 20:18:36 2026 +0800
Add parser IT cases for Oracle CLUSTER_SET function and BIGFILE tablespace with datafile (#39577)
Cover the Oracle CLUSTER_SET mining function with topN and cutoff arguments
through the featureFunction rule, and CREATE BIGFILE TABLESPACE with DATAFILE,
SIZE and AUTOEXTEND clauses through permanentTablespaceClause. Both forms are
already supported by the grammar, so only test resources change.
Fixes #27018
---
.../parser/src/main/resources/case/ddl/create-tablespace.xml | 1 +
.../parser/src/main/resources/case/dml/select-expression.xml | 11 +++++++++++
.../main/resources/sql/supported/ddl/create-tablespace.xml | 1 +
.../main/resources/sql/supported/dml/select-expression.xml | 1 +
4 files changed, 14 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml b/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
index 2a7f3e5a3b7..2d56a7a877c 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
@@ -27,6 +27,7 @@
<create-tablespace sql-case-id="create_permanent_tablespace_offline" />
<create-tablespace sql-case-id="create_permanent_tablespace_bigfile" />
<create-tablespace sql-case-id="create_permanent_tablespace_smallfile" />
+ <create-tablespace sql-case-id="create_bigfile_tablespace_with_datafile" />
<create-tablespace sql-case-id="create_tablespace_with_multi_filespecification" />
<create-tablespace sql-case-id="create_tablespace_with_filespecification_next" />
<create-tablespace sql-case-id="create_tablespace_with_filespecification" />
diff --git a/test/it/parser/src/main/resources/case/dml/select-expression.xml b/test/it/parser/src/main/resources/case/dml/select-expression.xml
index 1b76447f8d1..1acd0321d0f 100644
--- a/test/it/parser/src/main/resources/case/dml/select-expression.xml
+++ b/test/it/parser/src/main/resources/case/dml/select-expression.xml
@@ -2969,6 +2969,17 @@
</from>
</select>
+ <select sql-case-id="select_cluster_set_function">
+ <projections start-index="7" stop-index="52">
+ <expression-projection text="CLUSTER_SET(km_sh_clus_sample, 2, 0.1 USING *)" start-index="7" stop-index="52">
+ <function function-name="CLUSTER_SET" text="CLUSTER_SET(km_sh_clus_sample, 2, 0.1 USING *)" />
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table name="mining_data_apply_v" start-index="59" stop-index="77" />
+ </from>
+ </select>
+
<select sql-case-id="select_with_multiset_except_expression">
<from>
<simple-table name="customers_demo" start-index="103" stop-index="116" />
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml b/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
index 84613b3b9ee..462f321ff7a 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
@@ -27,6 +27,7 @@
<sql-case id="create_permanent_tablespace_offline" value="CREATE TABLESPACE test_space OFFLINE" db-types="Oracle" />
<sql-case id="create_permanent_tablespace_bigfile" value="CREATE BIGFILE TABLESPACE test_space ONLINE" db-types="Oracle" />
<sql-case id="create_permanent_tablespace_smallfile" value="CREATE SMALLFILE TABLESPACE test_space ONLINE" db-types="Oracle" />
+ <sql-case id="create_bigfile_tablespace_with_datafile" value="CREATE BIGFILE TABLESPACE bigtbs_01 DATAFILE 'bigtbs_f1.dbf' SIZE 20M AUTOEXTEND ON;" db-types="Oracle" />
<sql-case id="create_tablespace_with_multi_filespecification" value="CREATE TABLESPACE test_space
DATAFILE 'disk1:df1.dbf' AUTOEXTEND ON,
'disk2:df2.dbf' AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml b/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
index 51cbf42e00a..1c5191de2de 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
@@ -123,6 +123,7 @@
<sql-case id="select_interval_day_to_second_expression" value="SELECT (SYSTIMESTAMP - order_date) DAY(9) TO SECOND FROM orders" db-types="Oracle" />
<sql-case id="select_feature_function" value="SELECT FEATURE_VALUE(nmf_sh_sample, 3 USING *) FROM nmf_sh_sample_apply_prepared" db-types="Oracle" />
<sql-case id="select_cluster_function" value="SELECT CLUSTER_PROBABILITY(km_sh_clus_sample, 2 USING *) FROM mining_data_apply_v" db-types="Oracle" />
+ <sql-case id="select_cluster_set_function" value="SELECT CLUSTER_SET(km_sh_clus_sample, 2, 0.1 USING *) FROM mining_data_apply_v" db-types="Oracle" />
<sql-case id="select_with_multiset_except_expression" value="SELECT customer_id, cust_address_ntab MULTISET EXCEPT DISTINCT cust_address2_ntab multiset_except FROM customers_demo ORDER BY customer_id;" db-types="Oracle" />
<sql-case id="select_with_multiset_intersect_expression" value="SELECT customer_id, cust_address_ntab MULTISET INTERSECT DISTINCT cust_address2_ntab multiset_intersect FROM customers_demo ORDER BY customer_id;" db-types="Oracle" />
<sql-case id="select_with_multiset_union_expression" value="SELECT customer_id, cust_address_ntab MULTISET UNION cust_address2_ntab multiset_union FROM customers_demo ORDER BY customer_id;" db-types="Oracle" />