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 2022/03/10 08:55:39 UTC
[GitHub] [shardingsphere] wangzb105 opened a new issue #15970: distsql rdl create sharding algorithm
wangzb105 opened a new issue #15970:
URL: https://github.com/apache/shardingsphere/issues/15970
## Question
yaml config
shardingAlgorithms:
db_sharding_by_area:
type: INLINE
props:
algorithm-expression: seer_${area==0?'default':area}
result:
mysql> show sharding algorithms;
+------------------------------+--------+------------------------------------------------------------------+
| name | type | props |
+------------------------------+--------+------------------------------------------------------------------+
| db_sharding_by_area | INLINE | algorithm-expression=seer_${area==0?'default':area} |
distsql rdl
create sharding algorithm db_sharding_by_area (
type(name=inline,properties("algorithm-expression"="seer_${area==0?'default':area}"))
);
result:
mysql> show sharding algorithms;
+------------------------------+--------+------------------------------------------------------------------+
| name | type | props |
+------------------------------+--------+------------------------------------------------------------------+
| db_sharding_by_area | INLINE | algorithm-expression=seer_${area==0?default:area} |
use shardingsphere-proxy-5.1.0 version
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] lanchengx commented on issue #15970: distsql rdl create sharding algorithm
Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #15970:
URL: https://github.com/apache/shardingsphere/issues/15970#issuecomment-1063874637
@RaigorJiang @wangzb105 I will check
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #15970: distsql rdl create sharding algorithm
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #15970:
URL: https://github.com/apache/shardingsphere/issues/15970#issuecomment-1063871356
Hi @wangzb105
Thanks for your report.
@lanchengx Could you help to check it?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #15970: Lost quotes for value in `PROPERTIES` when adding rules using DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #15970:
URL: https://github.com/apache/shardingsphere/issues/15970
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org