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 13:47:18 UTC

[GitHub] [shardingsphere] strongduanmu commented on a change in pull request #7962: fix doc for sql support

strongduanmu commented on a change in pull request #7962:
URL: https://github.com/apache/shardingsphere/pull/7962#discussion_r515802775



##########
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:
       I feel this expression a bit difficult to understand, how about this expression —— "子查询中必须包含分片键，且分片键必须和父查询中的分片键一致". 😊




----------------------------------------------------------------
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