Zend Framework

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.9.7
• Fix Version/s: None
• Component/s: Zend_Db_Select
• Labels:

  None

If you specify a DB table then use select statement with an order and limit clause, the output for the limit range is wrong.

$nUserId = 123;
$select = $this->_table->select();
$select->where('user_id = ?', $nUserId)
->order('createddate DESC')
->limit(0, 200);

print $select;

// SELECT `myRecords`.* FROM `myRecords` WHERE (user_id = '123')
// ORDER BY `createddate` DESC LIMIT 2147483647 OFFSET 2

The limit is supposed to be 0 not 2147483647

Regards,
Cliburn M. Solano

• Assignee:

  Ralph Schindler

  Reporter:

  Cliburn M. Solano

• Created:

  26/Jan/10 8:27 PM

  Updated:

  30/Dec/11 8:37 PM