ZF-10599: Wrong limit statement when using db_select and paginator

Issue Type:
Bug
Created:
2010-10-26T02:58:54.000+0000
Last Updated:
2012-05-30T12:58:36.000+0000
Status:
Open
Fix version(s):
    Reporter:
    Andrey (whyte624)
    Assignee:
    Ralph Schindler (ralph)
    Tags:
    • Zend_Db_Select
    • Zend_Paginator
    Related issues:
    Attachments:

    Description

    I have connection to MSSql.

    Then I'm triing to create select for paginator select adapter from several other selects. $select = $db->select()->union($selects); echo $select->__toString(); //looks fine, and executing in sql anager successfully

    But when I use this select in paginator I have wrong rows. Because "select top 10" in query affects only on first select in unioned query.

    Sorry for my english.

    Comments

    Posted by Ramlan Gustian (rampog) on 2010-10-27T01:10:14.000+0000

    there is also bug in limitpage function for adapter sqlsrv

    ex: if there are 3 records in table if we use limitpage(2,2) return 2 records instead of 1 records

    Posted by Ramlan Gustian (rampog) on 2010-11-17T23:02:35.000+0000

    http://framework.zend.com/issues/browse/…

    this is the solutions

    Posted by Andrey (whyte624) on 2010-11-18T01:01:35.000+0000

    Thank you for this solution. But I think, this issue have to be fixed in ZF (Zend_Db_Select).