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/10 06:32:41 UTC
[GitHub] [shardingsphere] ZZemptypoint opened a new issue, #20461: short-circuit query
ZZemptypoint opened a new issue, #20461:
URL: https://github.com/apache/shardingsphere/issues/20461
## Feature Request
Assuming that our sharding-clomn type is a time-type, when we use the "limit" statement in the SQL, generally means we want it to short-circuit evaluation, Instead of routing it all the way.
For example:
``` sql
select * from table where time <'xxxx-xx-xx' limit 2
```
We want to find the first two pieces of data available before this time, they may be in different tables, but obviously there is no need to route all the tables. Now we make it table by table in business logic code, it's not cool.
### Is your feature request related to a problem?
NO, new feature request.
--
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] RaigorJiang commented on issue #20461: short-circuit query
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #20461:
URL: https://github.com/apache/shardingsphere/issues/20461#issuecomment-1407626665
Hi @ZZemptypoint
You can achieve this by configuring sharding rules and implementing sharding algorithms.
Considering this issue has been inactive for a long time, I'm closing it now.
If you still have the same problem, please reopen it or submit a new one.
--
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] github-actions[bot] commented on issue #20461: short-circuit query
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20461:
URL: https://github.com/apache/shardingsphere/issues/20461#issuecomment-1272348732
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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 #20461: short-circuit query
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #20461: short-circuit query
URL: https://github.com/apache/shardingsphere/issues/20461
--
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] github-actions[bot] closed issue #20461: short-circuit query
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20461: short-circuit query
URL: https://github.com/apache/shardingsphere/issues/20461
--
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