Zend Framework

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.1
• Fix Version/s: 1.6.2
• Component/s: Zend_Db_Select
• Labels:

  None

In the function _joinUsing of Zend_Db_Select:

public function _joinUsing($type, $name, $cond, $cols = '*', $schema = null)
{
    if (empty($this->_parts[self::FROM])) {
        require_once 'Zend/Db/Select/Exception.php';
        throw new Zend_Db_Select_Exception("You can only perform a joinUsing after specifying a FROM table");
    }

    $join  = $this->_adapter->quoteIdentifier(key($this->_parts[self::FROM]));
    $from  = $this->_adapter->quoteIdentifier($this->_uniqueCorrelation($name));

    $cond1 = $from . '.' . $cond;
    $cond2 = $join . '.' . $cond;
    $cond  = $cond1 . ' = ' . $cond2;

    return $this->_join($type, $name, $cond, $cols, $schema);
}

There is a call to quoteIdentifier, to function with Oracle, we must call with second parameter:

$join  = $this->_adapter->quoteIdentifier(key($this->_parts[self::FROM]), true);
$from  = $this->_adapter->quoteIdentifier($this->_uniqueCorrelation($name), true);

1. 

   zf3152.patch

   25/Apr/08 12:46 PM

   0.7 kB

   Mickael Perraud

• Assignee:

  Mickael Perraud

  Reporter:

  Mickael Perraud

• Created:

  20/Apr/08 9:09 AM

  Updated:

  10/Oct/08 2:41 PM

  Resolved:

  01/Oct/08 2:45 PM