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 2021/05/12 01:40:25 UTC
[GitHub] [shardingsphere] tristaZero commented on issue #10279: Using asynchronous processing for routing errors
tristaZero commented on issue #10279:
URL: https://github.com/apache/shardingsphere/issues/10279#issuecomment-839368113
Hi
which release do you use? Are the relevant tables in this SQL all sharding tables?
> SELECT COUNT(1) FROM ( SELECT detail.item_id, detail.item_code, detail.item_name, MASTER.company_id, MASTER.company_name, MASTER.company_code, sum(expand.base_planned_qty) AS base_planned_qty, sum(expand.base_picked_qty) AS base_picked_qty, sum(expand.base_diffied_qty) AS base_diffied_qty FROM w_outbound_master MASTER LEFT JOIN w_outbound_detail detail ON MASTER.id = detail.outbound_id AND detail.warehouse_code = MASTER.warehouse_code LEFT JOIN w_outbound_detail_expand expand ON detail.id = expand.outbound_detail_id AND detail.warehouse_code = expand.warehouse_code LEFT JOIN w_wave_detail wd ON wd.outbound_master_id = MASTER.id AND wd.warehouse_code = MASTER.warehouse_code LEFT JOIN w_wave_master wm ON wm.id = wd.wave_id AND wm.warehouse_code = wd.warehouse_code LEFT JOIN w_customers customers ON MASTER.customer_id = customers.id AND MASTER.warehouse_code = customers.warehouse_code LEFT JOIN w_customer_collection collection ON collection.id = customers.collection_id AND collecti
on.warehouse_code = customers.warehouse_code LEFT JOIN w_item_master item ON item.id = detail.item_id AND item.warehouse_code = detail.warehouse_code LEFT JOIN w_warm_layer layer ON layer.id = item.temp_id AND layer.warehouse_code = item.warehouse_code LEFT JOIN w_zone zone ON zone.temp_id = layer.id AND zone.warehouse_code = layer.warehouse_code LEFT JOIN w_work_area area ON area.zone_id = zone.id AND area.warehouse_code = zone.warehouse_code WHERE MASTER.warehouse_code = ? AND wm.is_allocated = 1 AND area.STATUS = 1 AND area.id = ? AND detail.item_type = 'BEEF' AND collection.collection_code = ? AND MASTER.delivery_date = ? GROUP BY MASTER.company_id, detail.item_code HAVING sum(expand.base_planned_qty) > (sum(expand.base_picked_qty) + sum(expand.base_diffied_qty)) ) TOTAL
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org