分页取数据出现异常**

cxxwz123

在数据集的分页取数据方案中设定每页记录数为100与不设定分页取数据（设定-1）的差异。
测试后，如果不设定分页取数据是正常的，设定了分页取数据造成数据混乱，一些数据重复，而另一部分数据不足。但是总数是一样的。

附上：SQL 事假探查器 查询的SQL语句

SELECT POLICEACTION.eventid, POLICEACTION.weifamanid, POLICEACTION.suitongrenyuan, POLICEACTION.weifamiaoshu, POLICEACTION.chahuotime1, POLICEACTION.staquyu, POLICEACTION.chahuorenyuan1, POLICEACTION.chahuorenyuan2, POLICEACTION.chengban1, POLICEACTION.chengban2, POLICEACTION.XLBH, POLICEACTION.ZTBH, POLICEACTION.CHDD, POLICEACTION.CHDW1, POLICEACTION.CHDW2, POLICEACTION.CBDW1, POLICEACTION.CBDW2, POLICEACTION.CHYY, POLICEACTION.TSRY, POLICEACTION.HSMJ1, POLICEACTION.HSMJ2, POLICEACTION.HSDW1, POLICEACTION.HSDW2, WEIFAMANINFO.manname, WEIFAMANINFO.othername, WEIFAMANINFO.sex, WEIFAMANINFO.minzu, WEIFAMANINFO.personcode, WEIFAMANINFO.age, WEIFAMANINFO.wenhua, WEIFAMANINFO.hujisheng, WEIFAMANINFO.hujishi, WEIFAMANINFO.hujidetail, WEIFAMANINFO.zaihuqu, WEIFAMANINFO.zaihulu, WEIFAMANINFO.zaihudetail, WEIFAMANINFO.gongzuodanwei, WEIFAMANINFO.lianxifangshi, WEIFAMANINFO.opman, WEIFAMANINFO.shengao, WEIFAMANINFO.tezheng, WEIFAMANINFO.ZJLXH, POLICEACTION.DJR, POLICEACTION.DJSJ, POLICEACTION.DJBM, POLICEACTION.YYJS, POLICEACTION.FRBS, POLICEACTION.ENDTIME, POLICEACTION.CRWF
  FROM POLICEACTION, WEIFAMANINFO
  WHERE (POLICEACTION.WEIFAMANID = WEIFAMANINFO.MANID) AND (( KSRQ >= '' and KSRQ <= '2008-3-28' and POLICEACTION.weifamanid in (select weifamanid AS "人员编号" from POLICEACTION group BY POLICEACTION.weifamanid HAVING COUNT(POLICEACTION.eventid) = 3)))

cxxwz123

正常的截图，已人员分组，记录数都是3条。

cxxwz123

已人员分组，数据混乱。应该正常情况下都是3才对

cxxwz123

查看异常的具体明细，编号是不可能重复的！

jiahaiminghr

楼主，使用的哪个版本？

jiahaiminghr

具体是如何设置的？

cxxwz123

两张表合在一起查询会出现问题，但是只用一张表的话是正常的。

jiahaiminghr

利用楼主的资源包，重现了问题。
已经提交缺陷了。