ZF-12369: Limiting rows not working properly in Zend_Db_Select

Issue Type:
Bug
Created:
2012-08-14T15:30:56.000+0000
Last Updated:
2012-09-05T13:00:31.000+0000
Status:
Open
Fix version(s):
    Reporter:
    Stefan Eroteev (eroteev)
    Assignee:
    Ralph Schindler (ralph)
    Tags:
    • Zend_Db_Select
    Related issues:
    Attachments:

    Description

    Limiting result set in Zend_Db_Select is not working when I pass zero as parameter to "limit" method.

    For example $imagesTable->select()->limit(5) will return 5 rows, but $imagesTable->select()->limit(0) will return all rows, because the "LIMIT 0" is not included in the query.

    Comments

    Posted by shamseer (shamseerss) on 2012-09-05T13:00:31.000+0000

    i don't this this major bug. it will be like there is no parameter. and there is an internal check for limit greater than zero.