[bug] Phalcon\Paginator\Adapter\QueryBuilder count is not accurate

[zhouyl]

(Sorry, i am chinese! Too bad English.)

When QueryBuider presence group by, count is not accurate.

My Code

class MyQueryBuilder extends \Phalcon\Paginator\Adapter\QueryBuilder
{

    public function getPaginate()
    {
        $paginate = parent::getPaginate();

        $builder = $this->getQueryBuilder();

        if ($group = $builder->getGroupBy()) {
            $result = $builder->columns('count(distinct ' . $group . ') as total')
                ->groupBy(null)
                ->getQuery()
                ->execute()
                ->getFirst();
            $paginate->total_items = $result->total;
            $paginate->total_pages = ceil($paginate->total_items / $this->getLimit());
        }

        return $paginate;
    }

}

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[bruno-fernandes]

You are using distinct on the count, just remove the group by, is not required.