You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "WindChaserInTheSunset (via GitHub)" <gi...@apache.org> on 2023/04/17 05:52:54 UTC
[GitHub] [shardingsphere] WindChaserInTheSunset opened a new issue, #25188: @zhoubin7 I also encountered the same problem. Is it possible to use filters or interceptors to handle the issue of other sharding tables returning null values? I did not find a technical solution in the official documentation.
WindChaserInTheSunset opened a new issue, #25188:
URL: https://github.com/apache/shardingsphere/issues/25188
@zhoubin7
This is really great news, thanks for your feedback.
Perhaps the subquery in the sharding scenario needs to enable federated query, you can try to configure
[sql-federation-type](https://shardingsphere.apache.org/document/current/en/user-manual/common-config/props/).
_Originally posted by @RaigorJiang in https://github.com/apache/shardingsphere/issues/24058#issuecomment-1424037037_
--
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
Re: [I] @zhoubin7 I also encountered the same problem. Is it possible to use filters or interceptors to handle the issue of other sharding tables returning null values? I did not find a technical solution in the official documentation. [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #25188:
URL: https://github.com/apache/shardingsphere/issues/25188#issuecomment-1973839114
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] @zhoubin7 I also encountered the same problem. Is it possible to use filters or interceptors to handle the issue of other sharding tables returning null values? I did not find a technical solution in the official documentation. [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #25188:
URL: https://github.com/apache/shardingsphere/issues/25188#issuecomment-1763912938
Hi @WindChaserInTheSunset， can you submit bug according to bug template?
--
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] WindChaserInTheSunset commented on issue #25188: @zhoubin7 I also encountered the same problem. Is it possible to use filters or interceptors to handle the issue of other sharding tables returning null values? I did not find a technical solution in the official documentation.
Posted by "WindChaserInTheSunset (via GitHub)" <gi...@apache.org>.
WindChaserInTheSunset commented on issue #25188:
URL: https://github.com/apache/shardingsphere/issues/25188#issuecomment-1510752985
Logic SQL: SELECT b.ORDERID FROM ORDER_MAIN a, ORDER_ITEM b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ?
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2301 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2301 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2301 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2301 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2301 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2301 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2302 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2302 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2302 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2302 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2302 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2302 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2303 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2303 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2303 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2303 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2303 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2303 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2304 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2304 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2304 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2304 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2304 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2304 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2305 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2305 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2305 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2305 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2305 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2305 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2306 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2306 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2306 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2306 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2306 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2306 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2307 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2307 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2307 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2307 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2307 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2307 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2308 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2308 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2308 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2308 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2308 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2308 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2309 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2309 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2309 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2309 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2309 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2309 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2310 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2310 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2310 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2310 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2310 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2310 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2311 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2311 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2311 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2311 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2311 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2311 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2312 a, order_item_2301 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2312 a, order_item_2302 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2312 a, order_item_2303 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2312 a, order_item_2304 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2312 a, order_item_2305 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
Actual SQL: ds1 ::: SELECT b.ORDERID FROM order_main_2312 a, order_item_2306 b WHERE a.ORDERID = b.ORDERID AND a.DELETEFLAG = 0 AND b.DELETEFLAG = 0 AND a.channelcode IN (?, ?, ?) AND a.STATUS = 3 AND b.STATUS = 3 AND now() - b.updatetime > ? LIMIT 0, ? ::: [67061, 67042, 67060, 100.0, 10000]
--
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