Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.1.5
-
Fix Version/s: None
-
Component/s: Pager
-
Labels:None
-
Environment:Local: Windows/Cygwin/XAMPP
Stage & Prod: CentOS
Apache / MySQL
Framework: Zend
Description
Pager breaks when HAVING clause references any existing table column.
Query used:
$q = Doctrine_Query::create()
->select("u.id, u.first_name, u.last_name, u.is_active")
->addSelect('COUNT(u.id) as rolecount')
->from('User u')
->leftJoin('u.Roles r')
->groupBy('u.id')
->having("rolecount > 2 and u.is_active = 1");
Execution of query by itself works fine (eg via execute(), fetch...)
When putting this query in a Doctrine_Pager, error outputs:
$pager = new Doctrine_Pager(
$q,
$currentPage,
$resultsPerPage
);
$pager->execute();
Error Received:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.is_active' in 'having clause'