[GitHub] [incubator-shardingsphere] haj8888888 opened a new 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.

Wed, 15 May 2019 18:44:11 -0700 

haj8888888 opened a new 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
 
 
   Code screenshot：
   
![image](https://user-images.githubusercontent.com/15724396/57820305-d0146580-77be-11e9-80bb-aacfa31968d9.png)
   
![image](https://user-images.githubusercontent.com/15724396/57820309-d73b7380-77be-11e9-9803-aa502196f858.png)
   
![image](https://user-images.githubusercontent.com/15724396/57820323-de628180-77be-11e9-9c13-d824dc702483.png)
   
![image](https://user-images.githubusercontent.com/15724396/57820333-e4586280-77be-11e9-9f3d-b811cf818c06.png)
   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'}]} 
   Problem Description: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.Actually should return 2 records
   

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

Reply via email to