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 2019/12/20 15:19:48 UTC

[GitHub] [incubator-shardingsphere-doc] terrymanu commented on a change in pull request #393: Add description for Do not support shardingColumn in expressions and …

terrymanu commented on a change in pull request #393: Add description for Do not support shardingColumn in expressions and …
URL: https://github.com/apache/incubator-shardingsphere-doc/pull/393#discussion_r360416881
 
 

 ##########
 File path: document/current/content/features/sharding/use-norms/sql.cn.md
 ##########
 @@ -109,6 +124,7 @@ SELECT COUNT(*) FROM (SELECT * FROM t_order o WHERE o.id IN (SELECT id FROM t_or
 | SELECT * FROM tbl_name1 UNION ALL SELECT * FROM tbl_name2                                  | UNION ALL                  |
 | SELECT * FROM ds.tbl_name1                                                                 | 包含schema                 |
 | SELECT SUM(DISTINCT col1), SUM(col1) FROM tbl_name                                         | 详见DISTINCT支持情况详细说明 |
+| SELECT * FROM tbl_name1 WHERE abs(col1) = ?                                                | 不支持运算表达式和函数中的分片键|
 
 Review comment:
   The actual mean is not unsupported the SQL, the description should be cannot sharding, just for full route to all data nodes.  

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


With regards,
Apache Git Services