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 2022/02/27 13:10:16 UTC

[GitHub] [shardingsphere] afeiluo opened a new issue #15661: 配合pagehelper使用,分页查询失效

afeiluo opened a new issue #15661:
URL: https://github.com/apache/shardingsphere/issues/15661


   `<dependency>
         <groupId>org.apache.shardingsphere</groupId>
         <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
         <version>4.1.1</version>
     </dependency>
    <exclusion>
         <groupId>com.github.pagehelper</groupId>
         <artifactId>pagehelper</artifactId>
         <version>5.3.0</version>
     </exclusion>
   `
   `PageHelper.startPage(1, 10)..doSelectPage(() -> mybatisMapperSelectMethod()); //查询的表没有分片` 
   正常情况下pagerhelper 会查总数,然后再limit, 但是用了shardingjdbc提供的数据源之后,仅仅查询了mapper里面定义的sql语句,导致分页失效。
   
   
   
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] yx9o commented on issue #15661: 配合pagehelper使用,分页查询失效

Posted by GitBox <gi...@apache.org>.
yx9o commented on issue #15661:
URL: https://github.com/apache/shardingsphere/issues/15661#issuecomment-1053567657


   Hi @afeiluo , for English only, please modify the issue title and content, thank you.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss closed issue #15661: 配合pagehelper使用,分页查询失效

Posted by GitBox <gi...@apache.org>.
menghaoranss closed issue #15661:
URL: https://github.com/apache/shardingsphere/issues/15661


   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org