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
Related issues: Attachments:
It is mentioned in the bug 5956 [http://framework.zend.com/issues/browse/ZF-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.