haj8888888 removed a comment on issue #2391: After using the sharding-proxy sub-table to sub-table, use the PageHelper plug-in to query one-to-many data, and the number of returned records is incorrect. URL: https://github.com/apache/incubator-shardingsphere/issues/2391#issuecomment-492915210 > sql.show = true Return result： [DEBUG] 2019-05-15 18:27:44,559 --main-- [com.mec.dao.OrderDao.selectByJoin_COUNT] ==> Preparing: SELECT count() FROM t_order t JOIN t_order_item ti ON t.order_id = ti.order_id [DEBUG] 2019-05-15 18:27:44,617 --main-- [com.mec.dao.OrderDao.selectByJoin_COUNT] ==> Parameters: [DEBUG] 2019-05-15 18:27:44,634 --main-- [com.mec.dao.OrderDao.selectByJoin_COUNT] <== Total: 1 [DEBUG] 2019-05-15 18:27:44,636 --main-- [com.mec.dao.OrderDao.selectByJoin] ==> Preparing: SELECT t., ti.order_item_id as a_order_item_id, ti.order_id as a_order_id, ti.user_id as a_user_id, ti.status as a_status FROM t_order t JOIN t_order_item ti ON t.order_id = ti.order_id limit ?,? [DEBUG] 2019-05-15 18:27:44,642 --main-- [com.mec.dao.OrderDao.selectByJoin] ==> Parameters: 0(Integer), 2(Integer) [DEBUG] 2019-05-15 18:27:44,649 --main-- [com.mec.dao.OrderDao.selectByJoin] <== Total: 2 [INFO ] 2019-05-15 18:27:44,651 --main-- [com.mec.order.test.ShardingProxyMybatisTest] Order{orderId=1557913094808, userId=688, status='ON', orderItemList=[OrderItem{orderItemId=1557913094807, orderId=1557913094808, userId=688, status='OFF'}, OrderItem{orderItemId=1557913094808, orderId=1557913094808, userId=688, status='ON'}]}
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services
