This is an automated email from the ASF dual-hosted git repository.
zhaojinchao 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 4dd471b2c4f Update document for getGeneratedKeys in sharding feature
(#23644)
4dd471b2c4f is described below
commit 4dd471b2c4f0e3956cb284a095da02e0e088e412
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Thu Jan 19 11:28:59 2023 +0800
Update document for getGeneratedKeys in sharding feature (#23644)
---
docs/document/content/features/sharding/appendix.cn.md | 4 ++++
docs/document/content/features/sharding/appendix.en.md | 4 ++++
2 files changed, 8 insertions(+)
diff --git a/docs/document/content/features/sharding/appendix.cn.md
b/docs/document/content/features/sharding/appendix.cn.md
index c5e9daf0138..d290a33b216 100644
--- a/docs/document/content/features/sharding/appendix.cn.md
+++ b/docs/document/content/features/sharding/appendix.cn.md
@@ -3,6 +3,10 @@ title = "附录"
weight = 3
+++
+有限支持的 SQL：
+
+- 使用 JDBC 规范 `getGeneratedKeys` 接口返回自增主键时，需要配合使用支持自增的分布式主键生成器，不支持其他类型的分布式主键生成器
+
不支持的 SQL：
- CASE WHEN 中包含子查询
diff --git a/docs/document/content/features/sharding/appendix.en.md
b/docs/document/content/features/sharding/appendix.en.md
index a7b43971d3d..2e8d5355e6b 100644
--- a/docs/document/content/features/sharding/appendix.en.md
+++ b/docs/document/content/features/sharding/appendix.en.md
@@ -3,6 +3,10 @@ title = "Appendix with SQL operator"
weight = 3
+++
+Limited supported SQL:
+
+- When using `getGeneratedKeys` interface of JDBC specification to return
auto-increment key, it is necessary to use a distributed key generator that
supports auto-increment, and does not support other types of distributed key
generators
+
Unsupported SQL:
- CASE WHEN contains sub-query
