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 9ca847aa996 Update sharding not support doc (#35398)
9ca847aa996 is described below
commit 9ca847aa99617b4f8f8959d8dd937b67ade07628
Author: Zhengqiang Duan <duanzhengqi...@apache.org>
AuthorDate: Wed May 14 12:04:31 2025 +0800
Update sharding not support doc (#35398)
---
docs/document/content/features/sharding/limitation.cn.md | 4 ++++
docs/document/content/features/sharding/limitation.en.md | 4 ++++
2 files changed, 8 insertions(+)
diff --git a/docs/document/content/features/sharding/limitation.cn.md
b/docs/document/content/features/sharding/limitation.cn.md
index b06a67ba385..5c4ffc18da8 100644
--- a/docs/document/content/features/sharding/limitation.cn.md
+++ b/docs/document/content/features/sharding/limitation.cn.md
@@ -176,6 +176,10 @@ Oracle 和 SQLServer 由于分页查询较为复杂，目前有部分分页查
目前不支持使用 `WITH xxx AS (SELECT …)` 的方式进行分页。由于 Hibernate 自动生成的 SQLServer 分页语句使用了
`WITH` 语句，因此目前并不支持基于 Hibernate 的 SQLServer 分页。 目前也不支持使用两个 TOP + 子查询的方式实现分页。
+### 聚合查询
+
+查询中同时包含多个聚合函数时，不支持带 DISTINCT 的聚合函数和不带 DISTINCT 的聚合函数混合使用。
+
### LOAD DATA / LOAD XML
不支持 MySQL `LOAD DATA` 和 `LOAD XML` 语句加载数据到分片表。
diff --git a/docs/document/content/features/sharding/limitation.en.md
b/docs/document/content/features/sharding/limitation.en.md
index f70580d318d..e10fc25bd16 100644
--- a/docs/document/content/features/sharding/limitation.en.md
+++ b/docs/document/content/features/sharding/limitation.en.md
@@ -167,6 +167,10 @@ The paging method of rownum + BETWEEN is not supported at
present
- SQLServer
Currently, pagination with `WITH xxx AS (SELECT ...)` is not supported. Since
the SQLServer paging statement automatically generated by Hibernate uses the
`WITH` statement, Hibernate-based SQLServer paging is not supported at this
moment. Pagination using two TOP + subquery also cannot be supported at this
time.
+### Aggregation
+
+When a query contains multiple aggregate functions at the same time, it does
not support mixing aggregate functions with DISTINCT and aggregate functions
without DISTINCT.
+
### LOAD DATA / LOAD XML
Not support MySQL `LOAD DATA` and `LOAD XML` statements to load data to
sharding table.
