devin-wanghuixiong opened a new issue, #18210: URL: https://github.com/apache/shardingsphere/issues/18210
Logic SQL: select distinct count(distinct checkdetai0_.id, checkdetai0_.tenant_id) as col_0_0_ from check_detail_sale checkdetai0_ left outer join check_detail_sale_item items1_ on checkdetai0_.id=items1_.master_id and checkdetai0_.tenant_id=items1_.tenant_id and ( items1_.deleted=0) where ( checkdetai0_.deleted=0) and checkdetai0_.tenant_id=100 and checkdetai0_.id>=45660871065600000 and checkdetai0_.id<57257282764800000 Actual SQL: check_0 ::: select distinct DISTINCT checkdetai0_.id,checkdetai0_.tenant_id as col_0_0_ from check_detail_sale_2022_05 checkdetai0_ left outer join check_detail_sale_item_2022_05 items1_ on checkdetai0_.id=items1_.master_id and checkdetai0_.tenant_id=items1_.tenant_id and ( items1_.deleted=0) where ( checkdetai0_.deleted=0) and checkdetai0_.tenant_id=100 and checkdetai0_.id>=45660871065600000 and checkdetai0_.id<57257282764800000 -- 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]
