ZF-3740: Counting results does not work in postgresql with order by in query

Issue Type:
Bug
Created:
2008-07-24T07:33:52.000+0000
Last Updated:
2008-07-24T07:51:38.000+0000
Status:
Resolved
Fix version(s):
  • 1.5.3 (28/Jul/08)
Reporter:
Kamil Nowakowski (kamiln)
Assignee:
Jurrien Stutterheim (norm2782)
Tags:
  • Zend_Paginator
Related issues:
Attachments:

Description

This does not work in postgresql


SELECT COUNT(*) AS zend_paginator_row_count FROM users  order by name asc

it throws error ERROR: column "users.name" must appear in the GROUP BY clause or be used in an aggregate function

You shoud shoul also reset order by


$rowCount   = clone $this->_select;
$rowCount->reset(Zend_Db_Select::COLUMNS)
              ->reset(Zend_Db_Select::ORDER)
               >columns($expression);

Comments

Posted by Jurrien Stutterheim (norm2782) on 2008-07-24T07:51:38.000+0000

Resolved in revision 10351