[#ZF-4441] Zend_Db_Select::union doesn't implement Zend_Db_Select and string as noted in docblock - Zend Framework Issue Tracker

Details

Type: Bug
Status: Resolved
Priority: N/A
Resolution: Duplicate
Affects Version/s: 1.6.1
Fix Version/s: 1.10.0
Component/s: Zend_Db_Select
Labels:
None

Description

The docblock says that you can use a string, array, or Zend_Db_Select object as the first parameter with union, but the code does this right away:

if (!is_array($select)) {
            $select = array();
        }

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Ralph Schindler added a comment - 25/Nov/08 2:57 PM

Do you have any potential use cases for an api that would support both string and Zend_Db_Select?

-ralph

Show

Ralph Schindler added a comment - 25/Nov/08 2:57 PM Do you have any potential use cases for an api that would support both string and Zend_Db_Select? -ralph

Hide

Permalink

C Snover added a comment - 30/Nov/08 12:36 PM

Initially I had been trying to use a Zend_Db_Select object, actually. I was expecting to be able to do something similar to

$union = $factoryB->select()->join('related', 'related.related_id = object.object_id', array())
                            ->where('related.related_id = ?')
                            ->setIntegrityCheck(false);

$select = $factoryA->select()->join('related', 'related.related_id = object.object_id', array())
                             ->where('related.related_id = ?')
                             ->union($union)
                             ->setIntegrityCheck(false);

return $factoryA->fetchAll($select);

This would be also a case where I might want to UNION a string that was custom-written for the second set of results. I didn't really expect that I need to have a fresh Zend_Db_Select object that gets called with UNION and an array.

Show

C Snover added a comment - 30/Nov/08 12:36 PM Initially I had been trying to use a Zend_Db_Select object, actually. I was expecting to be able to do something similar to

$union = $factoryB->select()->join('related', 'related.related_id = object.object_id', array())
                            ->where('related.related_id = ?')
                            ->setIntegrityCheck(false);

$select = $factoryA->select()->join('related', 'related.related_id = object.object_id', array())
                             ->where('related.related_id = ?')
                             ->union($union)
                             ->setIntegrityCheck(false);

return $factoryA->fetchAll($select);

This would be also a case where I might want to UNION a string that was custom-written for the second set of results. I didn't really expect that I need to have a fresh Zend_Db_Select object that gets called with UNION and an array.

Hide

Permalink

Benjamin Eberlei added a comment - 17/Sep/09 2:09 PM

Fixed as duplicate of ~~ZF-4772~~

Show

Benjamin Eberlei added a comment - 17/Sep/09 2:09 PM Fixed as duplicate of ~~ZF-4772~~

Zend Framework

Zend_Db_Select::union doesn't implement Zend_Db_Select and string as noted in docblock

Details

Description

Activity

People

Dates