Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sharding-jdbc单库分表查询不拆分数据表分页只能查询到第一页数据 #375

Closed
maber1993 opened this issue Sep 12, 2017 · 4 comments

Comments

@maber1993
Copy link

Please answer these questions before submitting your issue. Thanks!

Which version of Sharding-Jdbc do you using?

1.5.3

Expected behavior

mysql分页不需要改动即可正常显示

Actual behavior

数据分页第一页执行“select * from table limit 5”可以正常查询到结果集,但是当查询第二页执行“select * from table limit 5,5”查询不到数据

Steps to reproduce the behavior

1.初始化脚本在sjdbc-demo\src\main\resources\META-INF\schema\mysql.sql
2.运行com.mabo.example.jpa.Main#main方法
3.查看输出结果控制台打印5和0

Please provide the reproduce example codes (such as github link) if possible.

http://git.oschina.net/mabo1993/sjdbc-demo

terrymanu added a commit that referenced this issue Sep 12, 2017
@terrymanu
Copy link
Member

fixed at 1.5.4

@peak0632
Copy link

这个问题我在最新的3.1.0版本里也同样存在呢?需要什么特殊的配置吗?我用的是springboot 2.1 + JPA + Sharding 3.1.0。在Pageable里即使是大于0,返回的记录依然与第0页是一样的。如果把Sharding的配置注释掉,换用Spring的标准配置,分页正常显示

@cxlet
Copy link

cxlet commented Mar 25, 2019

退到3.0.0可以

@denofiend
Copy link

什么时候修复一下?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants