This is an automated email from the ASF dual-hosted git repository.
panjuan 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 958cbcc Update rewrite.cn.md (#9097)
958cbcc is described below
commit 958cbcca8a09bed1ef21b3db3457315bd3fc4622
Author: MingHao Li <[email protected]>
AuthorDate: Wed Jan 20 12:08:46 2021 +0800
Update rewrite.cn.md (#9097)
---
docs/document/content/features/sharding/principle/rewrite.cn.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/docs/document/content/features/sharding/principle/rewrite.cn.md
b/docs/document/content/features/sharding/principle/rewrite.cn.md
index 9554a66..1e98e52 100644
--- a/docs/document/content/features/sharding/principle/rewrite.cn.md
+++ b/docs/document/content/features/sharding/principle/rewrite.cn.md
@@ -187,7 +187,7 @@ SELECT score FROM t_score ORDER BY score DESC LIMIT 1, 2;

通过图中所示,想要取得两个表中共同的按照分数排序的第 2 条和第 3 条数据,应该是 `95` 和 `90`。
-由于执行的 SQL 只能从每个表中获取第 2 条和第 3 条数据,即从 t_score_0 表中获取的是 `90` 和 `80`;从 t_score_0
表中获取的是 `85` 和 `75`。
+由于执行的 SQL 只能从每个表中获取第 2 条和第 3 条数据,即从 t_score_0 表中获取的是 `90` 和 `80`;从 t_score_1
表中获取的是 `85` 和 `75`。
因此进行结果归并时,只能从获取的 `90`,`80`,`85` 和 `75` 之中进行归并,那么结果归并无论怎么实现,都不可能获得正确的结果。
正确的做法是将分页条件改写为 `LIMIT 0, 3`,取出所有前两页数据,再结合排序条件计算出正确的数据。