You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/11/03 14:11:14 UTC
[GitHub] [shardingsphere] jingshanglu commented on a change in pull request #7962: fix doc for sql support
jingshanglu commented on a change in pull request #7962:
URL: https://github.com/apache/shardingsphere/pull/7962#discussion_r515981446
##########
File path: docs/document/content/features/sharding/use-norms/sql.cn.md
##########
@@ -49,20 +49,25 @@ tbl_name [AS] alias] [index_hint_list]
### 路由至多数据节点
-不支持CASE WHEN、HAVING、UNION (ALL)，有限支持子查询。
+部分支持CASE WHEN
+* `CASE WHEN` 中包含子查询不支持
+* `CASE WHEN` 中使用逻辑表名不支持（请使用表别名）
+不支持 HAVING、UNION (ALL)
+部分支持子查询
+* 存在子查询，同时sql中没有分片键条件不支持，如果子查询中有分片键，需要和父查询中分片键条件一致
Review comment:
Ok
##########
File path: docs/document/content/features/sharding/use-norms/sql.cn.md
##########
@@ -49,20 +49,25 @@ tbl_name [AS] alias] [index_hint_list]
### 路由至多数据节点
-不支持CASE WHEN、HAVING、UNION (ALL)，有限支持子查询。
+部分支持CASE WHEN
+* `CASE WHEN` 中包含子查询不支持
+* `CASE WHEN` 中使用逻辑表名不支持（请使用表别名）
+不支持 HAVING、UNION (ALL)
+部分支持子查询
+* 存在子查询，同时sql中没有分片键条件不支持，如果子查询中有分片键，需要和父查询中分片键条件一致
Review comment:
Ok，Great idea.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org