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:


This does not work in postgresql

<pre class="highlight">
SELECT COUNT(*) AS zend_paginator_row_count FROM users  order by name asc

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

You shoud shoul also reset order by

<pre class="highlight">
$rowCount   = clone $this->_select;


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

Resolved in revision 10351

Have you found an issue?

See the Overview section for more details.


© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.