Issues

ZF-10455: Zend_DB SQL Server adapter's limit/offset clause does not function as expected for the last page of results

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

Attachments:

Description

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/…

Comments

No comments to display

Have you found an issue?

See the Overview section for more details.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts