default datasource page limit problem

[wuqiu-ai]

version：4.0.0.M1-SNAPSHOT
branch：dev
orm: spring jpa

not sharding table use default datasource，but page data is the same，for the following limit:

limit 1,10
limit 2,10
limt 3,10

java code

//junit test java code 
        Pageable pageable1 = new PageRequest(1,10);
        List<UserPo> pos1 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable1);
        log.info("pos1:{}",pos1.toString());

        Pageable pageable2 = new PageRequest(2,10);
        List<UserPo> pos2 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable2);
        log.info("pos2:{}",pos2.toString());

        Pageable pageable3 = new PageRequest(3,10);
        List<UserPo> pos3 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable3);
        log.info("pos3:{}",pos3.toString());

//orm code
  @Query("SELECT u FROM UserPo u WHERE u.userId is NULL and u.appName = ?1 and u.modifyTime < ?2")
  List<UserPo> getWithoutUserIdListBy(String appName, Date date, Pageable pageable);

output log

2019-01-10 17:04:51.158  INFO 95981 --- [           main] ShardingSphere-SQL                       : Rule Type: sharding
2019-01-10 17:04:51.158  INFO 95981 --- [           main] ShardingSphere-SQL                       : Logic SQL: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ?
2019-01-10 17:04:51.158  INFO 95981 --- [           main] ShardingSphere-SQL                       : SQLStatement: SelectStatement(super=DQLStatement(super=io.shardingsphere.core.parsing.parser.sql.dql.select.SelectStatement@7da70124), containStar=false, firstSelectItemStartPosition=7, selectListLastPosition=460, groupByLastPosition=0, items=[CommonSelectItem(expression=userpo0_.id, alias=Optional.of(id1_5_)), CommonSelectItem(expression=userpo0_.createTime, alias=Optional.of(createTi2_5_)), CommonSelectItem(expression=userpo0_.appCode, alias=Optional.of(appCode3_5_)), CommonSelectItem(expression=userpo0_.appName, alias=Optional.of(appName4_5_)), CommonSelectItem(expression=userpo0_.appVersion, alias=Optional.of(appVersi5_5_)), CommonSelectItem(expression=userpo0_.deviceMc, alias=Optional.of(deviceMc6_5_)), CommonSelectItem(expression=userpo0_.deviceToken, alias=Optional.of(deviceTo7_5_)), CommonSelectItem(expression=userpo0_.deviceTokenType, alias=Optional.of(deviceTo8_5_)), CommonSelectItem(expression=userpo0_.deviceType, alias=Optional.of(deviceTy9_5_)), CommonSelectItem(expression=userpo0_.modifyTime, alias=Optional.of(modifyT10_5_)), CommonSelectItem(expression=userpo0_.osVersion, alias=Optional.of(osVersi11_5_)), CommonSelectItem(expression=userpo0_.userId, alias=Optional.of(userId12_5_)), CommonSelectItem(expression=userpo0_.version, alias=Optional.of(version13_5_))], groupByItems=[], orderByItems=[], limit=Limit(offset=LimitValue(value=10, index=2, boundOpened=false), rowCount=LimitValue(value=10, index=3, boundOpened=false)), subQueryStatement=null, subQueryStatements=[], subQueryConditions=[])
2019-01-10 17:04:51.159  INFO 95981 --- [           main] ShardingSphere-SQL                       : Actual SQL: main ::: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ? ::: [[appcode_idxyer_android, 2019-01-10 17:04:49.417, 0, 20]]
2019-01-10 17:04:51.324  INFO 95981 --- [           main] c.d.p.push.service.UserServiceTest       : pos1:[UserPo{userId='13870325', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.4', osVersion='8.0.0', deviceType='Android', deviceMc='87c894be5f7b4c42a3927985a72018bf', deviceTokenType='ANDROID', deviceToken='Gj3Gfge3dCygO1uUq0V8qVMuqIdu+N758R+dd4M46Jg=', modifyTime=2018-02-06 16:29:42.0, version=0}, UserPo{userId='13873758', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='379326c5a69a42cd80989c2472a28ac5', deviceTokenType='GETUI', deviceToken='9c53678a8234a30e2fc625f9f13e3b3f', modifyTime=2018-11-27 13:17:14.0, version=2}, UserPo{userId='13874733', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='d5f32b5998cd4b208c69f117f6955470', deviceTokenType='GETUI', deviceToken='e277f89da8d2e622f6260cf328072625', modifyTime=2019-01-08 20:07:36.0, version=8}, UserPo{userId='13874828', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='37ba63ce0ba94b5ea7daa76a64a0affb', deviceTokenType='GETUI', deviceToken='20bb8e121d44843f74dc47046076b804', modifyTime=2019-01-09 13:35:34.0, version=3}, UserPo{userId='13874848', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='40e16380c87f44518bf3a53493969d41', deviceTokenType='GETUI', deviceToken='480e564536a70b5842d9d041d45909ab', modifyTime=2019-01-09 19:15:17.0, version=2}, UserPo{userId='13871480', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0.3', osVersion='6.0.1', deviceType='HUAWEI ATH-AL00', deviceMc='0000000040bb4e89dc87704f1e8dc50b', deviceTokenType='ANDROID', deviceToken='7mrI8oEJONd1rrTszdw50VdZYFfDNEN3L/gIWul+GtcMqaCFSl5+aGDZDTwf/B1S', modifyTime=2018-06-28 15:08:55.0, version=0}, UserPo{userId='13871210', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0.0', osVersion='8.0.0', deviceType='HUAWEI DUK-AL20', deviceMc='84f05e03749b4b54872fda60d3ff8c29', deviceTokenType='ANDROID', deviceToken='7RP7dly55jRaVZqKcJpsv4hUZtZUF9J3bIBQn3VkGUk=', modifyTime=2018-06-01 17:54:19.0, version=0}, UserPo{userId='13869945', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.4.2', osVersion='4.4.2', deviceType='HUAWEI G750-T01', deviceMc='ffffffffb971f1cccf7a5bf70033c587', deviceTokenType='ANDROID', deviceToken='y5Etn5TKVUksjFg8urjiBHb11gy+kiVWbDCCgB3fSuA=~', modifyTime=2018-01-19 18:34:57.0, version=0}, UserPo{userId='13870431', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.7.3', osVersion='4.4.2', deviceType='HUAWEI G750-T01', deviceMc='ffffffffb971f1cccf7a5bf70033c587', deviceTokenType='ANDROID', deviceToken='kfCT4MbWnJWZL4XUNLcV6OD/u9TbNoTIRaStPXEzTjQ=', modifyTime=2018-03-13 18:20:28.0, version=0}, UserPo{userId='13871082', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.7.6', osVersion='6.0', deviceType='HUAWEI GRA-CL00', deviceMc='00000000337246391a93c1ae0033c587', deviceTokenType='ANDROID', deviceToken='H1/h8RhkYATVtPuqwduPzMfCAJwRP47h4YFxPhFmyRw=', modifyTime=2018-05-25 14:18:03.0, version=0}]
Hibernate: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ?
2019-01-10 17:04:51.327  INFO 95981 --- [           main] ShardingSphere-SQL                       : Rule Type: sharding
2019-01-10 17:04:51.327  INFO 95981 --- [           main] ShardingSphere-SQL                       : Logic SQL: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ?
2019-01-10 17:04:51.327  INFO 95981 --- [           main] ShardingSphere-SQL                       : SQLStatement: SelectStatement(super=DQLStatement(super=io.shardingsphere.core.parsing.parser.sql.dql.select.SelectStatement@7da70124), containStar=false, firstSelectItemStartPosition=7, selectListLastPosition=460, groupByLastPosition=0, items=[CommonSelectItem(expression=userpo0_.id, alias=Optional.of(id1_5_)), CommonSelectItem(expression=userpo0_.createTime, alias=Optional.of(createTi2_5_)), CommonSelectItem(expression=userpo0_.appCode, alias=Optional.of(appCode3_5_)), CommonSelectItem(expression=userpo0_.appName, alias=Optional.of(appName4_5_)), CommonSelectItem(expression=userpo0_.appVersion, alias=Optional.of(appVersi5_5_)), CommonSelectItem(expression=userpo0_.deviceMc, alias=Optional.of(deviceMc6_5_)), CommonSelectItem(expression=userpo0_.deviceToken, alias=Optional.of(deviceTo7_5_)), CommonSelectItem(expression=userpo0_.deviceTokenType, alias=Optional.of(deviceTo8_5_)), CommonSelectItem(expression=userpo0_.deviceType, alias=Optional.of(deviceTy9_5_)), CommonSelectItem(expression=userpo0_.modifyTime, alias=Optional.of(modifyT10_5_)), CommonSelectItem(expression=userpo0_.osVersion, alias=Optional.of(osVersi11_5_)), CommonSelectItem(expression=userpo0_.userId, alias=Optional.of(userId12_5_)), CommonSelectItem(expression=userpo0_.version, alias=Optional.of(version13_5_))], groupByItems=[], orderByItems=[], limit=Limit(offset=LimitValue(value=20, index=2, boundOpened=false), rowCount=LimitValue(value=10, index=3, boundOpened=false)), subQueryStatement=null, subQueryStatements=[], subQueryConditions=[])
2019-01-10 17:04:51.327  INFO 95981 --- [           main] ShardingSphere-SQL                       : Actual SQL: main ::: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ? ::: [[appcode_idxyer_android, 2019-01-10 17:04:51.325, 0, 30]]
2019-01-10 17:04:51.343  INFO 95981 --- [           main] c.d.p.push.service.UserServiceTest       : pos2:[UserPo{userId='13870325', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.4', osVersion='8.0.0', deviceType='Android', deviceMc='87c894be5f7b4c42a3927985a72018bf', deviceTokenType='ANDROID', deviceToken='Gj3Gfge3dCygO1uUq0V8qVMuqIdu+N758R+dd4M46Jg=', modifyTime=2018-02-06 16:29:42.0, version=0}, UserPo{userId='13873758', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='379326c5a69a42cd80989c2472a28ac5', deviceTokenType='GETUI', deviceToken='9c53678a8234a30e2fc625f9f13e3b3f', modifyTime=2018-11-27 13:17:14.0, version=2}, UserPo{userId='13874733', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='d5f32b5998cd4b208c69f117f6955470', deviceTokenType='GETUI', deviceToken='e277f89da8d2e622f6260cf328072625', modifyTime=2019-01-08 20:07:36.0, version=8}, UserPo{userId='13874828', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='37ba63ce0ba94b5ea7daa76a64a0affb', deviceTokenType='GETUI', deviceToken='20bb8e121d44843f74dc47046076b804', modifyTime=2019-01-09 13:35:34.0, version=3}, UserPo{userId='13874848', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='40e16380c87f44518bf3a53493969d41', deviceTokenType='GETUI', deviceToken='480e564536a70b5842d9d041d45909ab', modifyTime=2019-01-09 19:15:17.0, version=2}, UserPo{userId='13871480', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0.3', osVersion='6.0.1', deviceType='HUAWEI ATH-AL00', deviceMc='0000000040bb4e89dc87704f1e8dc50b', deviceTokenType='ANDROID', deviceToken='7mrI8oEJONd1rrTszdw50VdZYFfDNEN3L/gIWul+GtcMqaCFSl5+aGDZDTwf/B1S', modifyTime=2018-06-28 15:08:55.0, version=0}, UserPo{userId='13871210', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0.0', osVersion='8.0.0', deviceType='HUAWEI DUK-AL20', deviceMc='84f05e03749b4b54872fda60d3ff8c29', deviceTokenType='ANDROID', deviceToken='7RP7dly55jRaVZqKcJpsv4hUZtZUF9J3bIBQn3VkGUk=', modifyTime=2018-06-01 17:54:19.0, version=0}, UserPo{userId='13869945', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.4.2', osVersion='4.4.2', deviceType='HUAWEI G750-T01', deviceMc='ffffffffb971f1cccf7a5bf70033c587', deviceTokenType='ANDROID', deviceToken='y5Etn5TKVUksjFg8urjiBHb11gy+kiVWbDCCgB3fSuA=~', modifyTime=2018-01-19 18:34:57.0, version=0}, UserPo{userId='13870431', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.7.3', osVersion='4.4.2', deviceType='HUAWEI G750-T01', deviceMc='ffffffffb971f1cccf7a5bf70033c587', deviceTokenType='ANDROID', deviceToken='kfCT4MbWnJWZL4XUNLcV6OD/u9TbNoTIRaStPXEzTjQ=', modifyTime=2018-03-13 18:20:28.0, version=0}, UserPo{userId='13871082', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.7.6', osVersion='6.0', deviceType='HUAWEI GRA-CL00', deviceMc='00000000337246391a93c1ae0033c587', deviceTokenType='ANDROID', deviceToken='H1/h8RhkYATVtPuqwduPzMfCAJwRP47h4YFxPhFmyRw=', modifyTime=2018-05-25 14:18:03.0, version=0}]
Hibernate: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ?
2019-01-10 17:04:51.346  INFO 95981 --- [           main] ShardingSphere-SQL                       : Rule Type: sharding
2019-01-10 17:04:51.346  INFO 95981 --- [           main] ShardingSphere-SQL                       : Logic SQL: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ?
2019-01-10 17:04:51.346  INFO 95981 --- [           main] ShardingSphere-SQL                       : SQLStatement: SelectStatement(super=DQLStatement(super=io.shardingsphere.core.parsing.parser.sql.dql.select.SelectStatement@7da70124), containStar=false, firstSelectItemStartPosition=7, selectListLastPosition=460, groupByLastPosition=0, items=[CommonSelectItem(expression=userpo0_.id, alias=Optional.of(id1_5_)), CommonSelectItem(expression=userpo0_.createTime, alias=Optional.of(createTi2_5_)), CommonSelectItem(expression=userpo0_.appCode, alias=Optional.of(appCode3_5_)), CommonSelectItem(expression=userpo0_.appName, alias=Optional.of(appName4_5_)), CommonSelectItem(expression=userpo0_.appVersion, alias=Optional.of(appVersi5_5_)), CommonSelectItem(expression=userpo0_.deviceMc, alias=Optional.of(deviceMc6_5_)), CommonSelectItem(expression=userpo0_.deviceToken, alias=Optional.of(deviceTo7_5_)), CommonSelectItem(expression=userpo0_.deviceTokenType, alias=Optional.of(deviceTo8_5_)), CommonSelectItem(expression=userpo0_.deviceType, alias=Optional.of(deviceTy9_5_)), CommonSelectItem(expression=userpo0_.modifyTime, alias=Optional.of(modifyT10_5_)), CommonSelectItem(expression=userpo0_.osVersion, alias=Optional.of(osVersi11_5_)), CommonSelectItem(expression=userpo0_.userId, alias=Optional.of(userId12_5_)), CommonSelectItem(expression=userpo0_.version, alias=Optional.of(version13_5_))], groupByItems=[], orderByItems=[], limit=Limit(offset=LimitValue(value=30, index=2, boundOpened=false), rowCount=LimitValue(value=10, index=3, boundOpened=false)), subQueryStatement=null, subQueryStatements=[], subQueryConditions=[])
2019-01-10 17:04:51.346  INFO 95981 --- [           main] ShardingSphere-SQL                       : Actual SQL: main ::: select userpo0_.id as id1_5_, userpo0_.createTime as createTi2_5_, userpo0_.appCode as appCode3_5_, userpo0_.appName as appName4_5_, userpo0_.appVersion as appVersi5_5_, userpo0_.deviceMc as deviceMc6_5_, userpo0_.deviceToken as deviceTo7_5_, userpo0_.deviceTokenType as deviceTo8_5_, userpo0_.deviceType as deviceTy9_5_, userpo0_.modifyTime as modifyT10_5_, userpo0_.osVersion as osVersi11_5_, userpo0_.userId as userId12_5_, userpo0_.version as version13_5_ from push_user userpo0_ where (userpo0_.userId is null) and userpo0_.appName=? and userpo0_.modifyTime<? limit ?, ? ::: [[appcode_idxyer_android, 2019-01-10 17:04:51.344, 0, 40]]
2019-01-10 17:04:51.358  INFO 95981 --- [           main] c.d.p.push.service.UserServiceTest       : pos3:[UserPo{userId='13870325', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.4', osVersion='8.0.0', deviceType='Android', deviceMc='87c894be5f7b4c42a3927985a72018bf', deviceTokenType='ANDROID', deviceToken='Gj3Gfge3dCygO1uUq0V8qVMuqIdu+N758R+dd4M46Jg=', modifyTime=2018-02-06 16:29:42.0, version=0}, UserPo{userId='13873758', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='379326c5a69a42cd80989c2472a28ac5', deviceTokenType='GETUI', deviceToken='9c53678a8234a30e2fc625f9f13e3b3f', modifyTime=2018-11-27 13:17:14.0, version=2}, UserPo{userId='13874733', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='d5f32b5998cd4b208c69f117f6955470', deviceTokenType='GETUI', deviceToken='e277f89da8d2e622f6260cf328072625', modifyTime=2019-01-08 20:07:36.0, version=8}, UserPo{userId='13874828', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='37ba63ce0ba94b5ea7daa76a64a0affb', deviceTokenType='GETUI', deviceToken='20bb8e121d44843f74dc47046076b804', modifyTime=2019-01-09 13:35:34.0, version=3}, UserPo{userId='13874848', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0', osVersion='9', deviceType='Google Pixel 2', deviceMc='40e16380c87f44518bf3a53493969d41', deviceTokenType='GETUI', deviceToken='480e564536a70b5842d9d041d45909ab', modifyTime=2019-01-09 19:15:17.0, version=2}, UserPo{userId='13871480', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0.3', osVersion='6.0.1', deviceType='HUAWEI ATH-AL00', deviceMc='0000000040bb4e89dc87704f1e8dc50b', deviceTokenType='ANDROID', deviceToken='7mrI8oEJONd1rrTszdw50VdZYFfDNEN3L/gIWul+GtcMqaCFSl5+aGDZDTwf/B1S', modifyTime=2018-06-28 15:08:55.0, version=0}, UserPo{userId='13871210', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='8.0.0', osVersion='8.0.0', deviceType='HUAWEI DUK-AL20', deviceMc='84f05e03749b4b54872fda60d3ff8c29', deviceTokenType='ANDROID', deviceToken='7RP7dly55jRaVZqKcJpsv4hUZtZUF9J3bIBQn3VkGUk=', modifyTime=2018-06-01 17:54:19.0, version=0}, UserPo{userId='13869945', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.4.2', osVersion='4.4.2', deviceType='HUAWEI G750-T01', deviceMc='ffffffffb971f1cccf7a5bf70033c587', deviceTokenType='ANDROID', deviceToken='y5Etn5TKVUksjFg8urjiBHb11gy+kiVWbDCCgB3fSuA=~', modifyTime=2018-01-19 18:34:57.0, version=0}, UserPo{userId='13870431', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.7.3', osVersion='4.4.2', deviceType='HUAWEI G750-T01', deviceMc='ffffffffb971f1cccf7a5bf70033c587', deviceTokenType='ANDROID', deviceToken='kfCT4MbWnJWZL4XUNLcV6OD/u9TbNoTIRaStPXEzTjQ=', modifyTime=2018-03-13 18:20:28.0, version=0}, UserPo{userId='13871082', appName='appcode_idxyer_android', appCode='4124c5f1-2029-4fda-b06f-a87ac5ad8d11', appVersion='7.7.6', osVersion='6.0', deviceType='HUAWEI GRA-CL00', deviceMc='00000000337246391a93c1ae0033c587', deviceTokenType='ANDROID', deviceToken='H1/h8RhkYATVtPuqwduPzMfCAJwRP47h4YFxPhFmyRw=', modifyTime=2018-05-25 14:18:03.0, version=0}]

now look this log,limit is not same ,but data is same.
expect：output of other page data.

[master-starcloud]

@ppj19891020 why you used pageable1 three times ,and not use pageable2 pageable3 objects....

[tuohai666]

@ppj19891020 I have the same question as @master-starcloud.

[tuohai666]

I noticed that there may have bug in your test case.

Pageable pageable1 = new PageRequest(1,10);
List pos1 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable1);
log.info("pos1:{}",pos1.toString());

Pageable pageable2 = new PageRequest(2,10);
List pos2 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable1);
log.info("pos2:{}",pos2.toString());

Pageable pageable3 = new PageRequest(3,10);
List pos3 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable1);
log.info("pos2:{}",pos3.toString());

[happy89lgk]

@tuohai666 He use different pageable,
Pageable pageable1 = new PageRequest(1,10);
List pos1 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable1);
log.info("pos1:{}",pos1.toString());

    Pageable pageable2 = new PageRequest(2,10);
    List<UserPo> pos2 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable2);
    log.info("pos2:{}",pos2.toString());

    Pageable pageable3 = new PageRequest(3,10);
    List<UserPo> pos3 = userRepository.getWithoutUserIdListBy("appcode_idxyer_android", new Date(),pageable3);
    log.info("pos3:{}",pos3.toString());

I also have this problem

[tuohai666]

@happy89lgk Thanks for reminder. Will be fixed later.

[wanshi1128]

When can I release the next version?

[dalaocu]

When can I release the next version?

+1

[tuohai666]

@wanshi1128 @dalaocu,
FYI:
http://mail-archives.apache.org/mod_mbox/shardingsphere-dev/201901.mbox/%3Ctencent_9D2FC2C46019518F3C5AE953044A5CB2D906@qq.com%3E