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/10/30 07:13:38 UTC

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

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



##########
File path: docs/document/content/features/sharding/use-norms/sql.cn.md
##########
@@ -49,7 +49,12 @@ tbl_name [AS] alias] [index_hint_list]
 
 ### 路由至多数据节点
 
-不支持CASE WHEN、HAVING、UNION (ALL)，有限支持子查询。
+部分支持CASE WHEN
+* `CASE WHEN` 中包含子查询不支持
+* `CASE WHEN` 中使用逻辑表名不支持（请使用表别名）
+不支持 HAVING、UNION (ALL)
+部分支持子查询
+* 子查询中没有分片键条件不支持，参考[子查询支持详情](https://github.com/apache/shardingsphere/issues/6497)

Review comment:
       Can we summary the issue content as document?




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