Issue Type: Bug Created: 2010-09-14T19:32:12.000+0000 Last Updated: 2011-03-05T01:29:27.000+0000 Status: Open Fix version(s): Reporter: Nathan Bell (nathanpbell) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db
Related issues: - ZF-10659
When using the Zend_Db_Adapter_Pdo_Mssql, an incorrect number of rows are returned when specifying an offset with limit(). For instance, if you have a possible 26 rows in a result set, and you specify a limit of 10 with an offset of 20, you would expect to get back the last 6 rows. This is how the other DB adapters work. With the SQL Server adapter, you get back 10 rows.
This is also discussed in ZF-8148, particularly in the comment by Ankit Aggarwal: http://framework.zend.com/issues/browse/… The fix for bug ZF-8148 did not solve this issue.
Possible solutions for SQL Server 2000 and up are discussed at http://stackoverflow.com/questions/216673/…
No comments to display
Have you found an issue?
See the Overview section for more details.