Zend Framework

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s: 1.8.4
• Component/s: Zend_Paginator
• Labels:

  None

Zend_Paginator_Adapter_DbSelect seems to create a wrong query for getting the count when the query has a 'HAVING' in it.

Simplified example:

$select = $db->select()
->from('user', 'user_id AS foo')
->having('foo > ?', 4);

// query is: SELECT `user`.`user_id` AS `foo` FROM `user` HAVING (foo > 4)

$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($select));

Created query is:
SELECT COUNT AS `zend_paginator_row_count` FROM `user` HAVING (foo > 4)

which is obviously not working.

Haven't tested it yet in 1.8.0.

BR
anselm

• Assignee:

  Jurrien Stutterheim

  Reporter:

  Anselm Föhr

• Created:

  06/May/09 9:14 AM

  Updated:

  18/Jun/09 9:24 PM

  Resolved:

  18/Jun/09 9:24 PM