ZF-7203: DB Select object doest not work with Paginator if UNION is applied in the query

Issue Type: Bug Created: 2009-07-06T07:22:35.000+0000 Last Updated: 2011-02-18T19:56:19.000+0000 Status: Open Fix version(s): Reporter: Muhammad Shakeel (shakeel) Assignee: Ramon Henrique Ornelas (ramon) Tags: - Zend_Db_Select

  • Zend_Paginator

Related issues: Attachments:


It is mentioned in the bug 5956 [] that the problem with Zend Paginator while selecting UNION query is fixed in revision 16144 but i have checked out for the latest Trunck today but the problem persists.

We are still getting this crash: exception 'Zend_Db_Select_Exception' with message 'No table has been specified for the FROM clause'

The code looks like below:

Lets say $select1 and $select2 are Zend_Db_Selects that give identical fields.

Then we do $select1 UNION $select2: $select = $db->select()->union(array($select1, $select2));

$paginator = Zend_Paginator::factory($select);

The above exception raises at this level i.e. 'Zend_Db_Select_Exception' with message 'No table has been specified for the FROM clause'


No comments to display

Have you found an issue?

See the Overview section for more details.


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

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