pengxianggui opened a new issue, #23128: URL: https://github.com/apache/shardingsphere/issues/23128
I have a question, take the official demo for example. I used the binding table to avoid the Cartesian product, so I must use orderId as the sharding field, but in reality, I need to sharding by year, so I should take order_time as the sharding field. Because there are only interval conditions for orderTime in the paging query condition. How can I avoid Cartesian products in associative table queries while using order_time sharding? Thanks for your answer! 我有一个问题，以官方的demo为例。 我使用绑定表避免笛卡尔积，因此我必须使用orderId作为分片字段，但是实际情况，我需要按年份分片，我需要取order_time作为分片字段。因为分页查询条件里只有针对orderTime的区间条件。 我如何在使用orderTime分片的同时，又能在关联表查询中避免笛卡尔积呢？ 感谢您的解答！ -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
