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/10/28 00:52:56 UTC
[GitHub] [shardingsphere] wangjiihao opened a new issue, #21810: Does the shard key support like
wangjiihao opened a new issue, #21810:
URL: https://github.com/apache/shardingsphere/issues/21810
Does the partition key support querying in the like mode and How to use it if it supports
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangjiihao commented on issue #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1294278397
@TeslaCN
--
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] wangjiihao commented on issue #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1296452227
@RaigorJiang
Can I customize a like routing rule? By implementation or inheritance
--
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] wangjiihao commented on issue #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1294280528
example:
select * from user where name like '王%'
name is the shard key
--
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 #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1295857649
@wangjiihao
Sharding key just supports `=` or range (`>`, `>=`, `<`, `<=`, `between`)
--
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 #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1296508430
Unfortunately, in the sharding scenario, there is currently no interface to implement `LIKE`.
--
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 #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #21810: Does the shard key support like
URL: https://github.com/apache/shardingsphere/issues/21810
--
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] wangjiihao commented on issue #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1294284953
version: shardingsphere-jdbc-core-spring-boot-starter 5.0.0
--
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] wangjiihao commented on issue #21810: Does the shard key support like
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21810:
URL: https://github.com/apache/shardingsphere/issues/21810#issuecomment-1296456827
When querying shard fields, I need to use the like method, because there is a parent-child relationship between data similar to the codes of provinces and cities, and provinces and cities have a unified prefix
--
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