[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.

[via GitHub]

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-unsubscr...@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org